I am new to C#.NET development and I am trying to figure out how to write data into specific sheets and cells in an workbook. This workbook does not have a specific path, instead it is opened by another method and I´d like to write data to it by another method (seperate button on the winform menu).
Is there a way to do this?
Alternatively a method during the same event click writes to the excel file once it opens. Not sure what approach is best here.
MCMohan Chandran Syncfusion Team January 16, 2019 07:23 AM
Thank you for contacting Syncfusion support.
We have shared a sample to open a Excel file using open File dialog and to manipulate it. This can be downloaded from the following link. The code that helps to achieve this requirement is shared below.
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
//The workbook is opened.
IWorkbook workbook = null;
OpenFileDialog openFileDialog = new OpenFileDialog();