ExportDataTable is not reading the cell values in full but only formatted value (visible portion)

Aspose.Cells Product Family
1

Hi team,

Here is the code that we are using to read excel data into DataTable. Could you please let me know what needs to be changed, in order to read cell values in full.

//export options from Excel -> DataTable
var exportTableOptions = new ExportTableOptions()
{
CheckMixedValueType = true,
FormatStrategy = CellValueFormatStrategy.CellStyle,
ExportAsString = true,
ExportColumnName = true
};

                //get data
                var lastDataRow = worksheet.Cells.GetLastDataRow(1);
                var maxColumn = worksheet.Cells.MaxDataColumn;

                //read the data 
                var dt = worksheet.Cells.ExportDataTable(13, 0, (lastDataRow - 13) + 1, maxColumn + 1, exportTableOptions);

Thanks

2

@CTI78,

Thanks for the sample code segment and details.

Please provide your template file and elaborate on the issue with some screenshots to give us details about your requirements. We will check your issue and help you through.