Free Support Forum -

.ImportDataTable -> Columns of DataTable is out of range

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.


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

Thanks, I forgot about that limitation.