Select a excel file and import and read.

[Pedro]

I need select a existing excel file and read using syncfusion. All options are for create excel file.

[Davis Jebaraj]

Hi Pedro,

Please refer to this documentation topic:

https://help.syncfusion.com/file-formats/xlsio/loading-and-saving-workbook

using (ExcelEngine excelEngine = new ExcelEngine())
{
  //Loads or open an existing workbook
  FileStream inputStream = new FileStream(inputFileName, FileMode.Open);
  IWorkbook workbook = excelEngine.Excel.Workbooks.Open(inputStream);

  //To-Do some manipulation
  //To-Do some manipulation

  //Set the version of the workbook
  workbook.Version = ExcelVersion.Excel2013;

  //Saving the workbook
  FileStream outputStream = new FileStream(outputFileName, FileMode.Create);
  workbook.SaveAs(outputStream);
}

Regards,

Davis