We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Trim leading spaces while exporting excel data into Datatable

Hello Aspose Team,

I am using aspose cell licence version.

While exporting excel data into datable, I need to trim the leading spaces of excel cell.
Kindly help me in this.

Below is the method, which I using for exporting excel data into datable.

dataTable = worksheet.Cells.ExportDataTable(startRow, startColumn, worksheet.Cells.MaxDataRow + 1, worksheet.Cells.MaxDataColumn + 1, new ExportTableOptions() { CheckMixedValueType = true, ExportColumnName = true });


Thanks for your posting and using Aspose.Cells.

Please provide us sample console application running your code and also sample excel files used inside it. Also if you could provide expected excel files. We will execute your code and improve it to meet your requirements. Thanks for your cooperation.