Is there any way to override the internal limit of 16,384 columns for creating / reading CSV files?
I realize this is a hard limit in XLSX format, and any file exceeding that limit would not be viable in Excel. However we occasionally need to work with CSV files which exceed these limits, and it would be great if I could use my existing utilities that incorporate GemBox Spreadsheet to do so, rather than having to create a different set of tools for XLSX and CSV formats.
Hi Chris,
We have an example for a similar requirement, for reading a CSV file with more than 1,048,576 rows.
Please check the “Read large CSV files”:
In short, every 1,048,576 records are read into a separate ExcelWorksheet by using a custom TextReader. Perhaps you could try using a similar approach to split a record into multiple records (up to 16,384 fields).
Regards,
Mario
Thanks for the response Mario. Unfortunately your suggestion doesn’t help us in this use case; we really need everything in a single sheet for compatibility with another application. I was hoping there might just be a way to increase the number of fields in the GemBox internal model for use with CSV files, but if not I’ll have to do the CSV handling outside of GemBox spreadsheet. Thanks anyway.