Forum Discussion
More than 1,048,576 rows
I have been sent a 4.4GB Excel .CSV file. It has 16columns, but several million rows. When I try to open it, it only opens the first 1,048,576 rows. Is there a way to open the whole file? I don't min...
Yes, exactly, that could add some logic for splitting rather than simple batch file which splits based on number of rows.
And perhaps it's not necessary to return data back to Excel sheet, load to data model and work with it aggregating data.