Worksheet for csv files with more as 32767 columns

Aspose.Cells Product Family
1

Hi,

we have to read a csv file with aspose that contains more then 32767 columns.
If we try this the Worksheet.Cells.MaxColumnsis 32767 and Worksheet.Cells.MaxDataColumn is -1.

Is there a limitation to 32k columns?

Regards, Jochen Bernhardt

2

Hi,


Thanks for providing us some details.

Could you provide us your template CSV file, we will check it soon.

Thank you.
3

Hi,i produced the error with the attached file and the following code:

var options = new TxtLoadOptions(LoadFormat.CSV);
options.Separator = ',';
_workbook = new Workbook(filename, options);
_worksheet = _workbook.Worksheets[_workbook.Worksheets.ActiveSheetIndex];

Thanks

4

Hi,


Thanks for the template file.

I have checked your template CSV file, it does not seem to be a correct/ valid CSV (comma separated value) file as it has more than 16384 columns. As you know MS Excel 2007/2010/2013 has a limitation of only 16384 columns in a single worksheet. Even when I opened your template file into Ms Excel and it prompts me that File is not loaded completely, so Ms Excel gives some instructions:
e.g
This message can appear due to one of the following:
The file contains more than 1,048,576 rows or 16,384 columns. To fix this problem, open the source file in a text editor such as Microsoft Word. Save the source file as several smaller files that conform to this row and column limit, and then open the smaller files in Microsoft Excel. If the source data cannot be opened in a text editor, try importing the data into Microsoft Access, and then exporting subsets of the data from Access to Excel.
The area that you are trying to paste the tab-delineated data into is too small. To fix this problem, select an area in the worksheet large enough to accommodate every delimited item.
Notes
Excel cannot exceed the limit of 1,048,576 rows and 16,384 columns.
By default, Excel places three worksheets in a workbook file. Each worksheet can contain 1,048,576 rows and 16,384 columns of data, and workbooks can contain more than three worksheets if your computer has enough memory to support the additional data.


Thank you.

5

Hi

thanks for your reply, its right excel cant open this file. But i don't create this file by excel and i dont want to open this file in excel.

I only want to read this file with aspose cells.

And i think that is not really a suitable way to split this file manuelly in different files. The cells have different sizes for each row so some one has to count for each row the cells - for example up to 15000... with out errors? I think even if mircosoft suggest this - this is not really a solution in a time of automatication of processes!

Regards, Jochen Bernhardt

6

Hi,


Well, Aspose.Cells follows MS Excel standards and specifications in general. If Ms Excel can’t handle this, Aspose.Cells also may not support it.

Anyways, we will further analyze and investigate it and get back to you soon.

Thank you.


7

Hi,


We have analyzed your issue/ requirements further. I am afraid, we cannot support your needs for now. This is due to MS Excel’s limitation and nothing to do with Aspose.Cells APIs. We follow MS Excel standards and specifications regarding the file formats and you cannot have more than 16384 columns in a single worksheet.

Thank you.