.ImportDataTable -> Columns of DataTable is out of range

Aspose.Cells Product Family
1

To whom it may concern,

I am receiving the error "Columns of DataTable is out of range." on this call: ImportDataTable(Me.dtTable1, True, 1, 1), and wanted to find out if there is a column limitation in Apose.Cells? For the record my query is returning 301 columns.

Thanks!
Chris

2

Dear Chris,

Yes, there is a column limitation. It's set by MS Excel. Please launch MS Excel, you can see there are only 256 columns in a worksheet

3

Thanks, I forgot about that limitation.

Chris