What ever i try whit this particular file... it always give me a null value in any range i try to retreive from the sheet and to show in the grid...
This is an important file for me to parse... why it give that result.. i cant read any of the data...
The DataTable result is a bunch of NULL value... whatever the selection i try to do in the sheet..
Code exemple :
public DataTable GetExcelData(string fileToProcess)
DataTable dt = new DataTable();
//Instantiating an Workbook object
Workbook workbook = new Workbook();
//Creating a file stream containing the Excel file to be opened
FileStream fstream = new FileStream(fileToProcess, FileMode.Open);
//Opening the Excel file through the file stream
//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets;
//Exporting the contents of x rows and x columns starting from 1st cell to DataTable
dt = worksheet.Cells.ExportDataTableAsString(23, 0, 1, 2, false);
//Closing the file stream to free all resources
catch (Exception ex)