Page 1 of 1

Write to multiple excel tabs ?

Posted: Thu Oct 29, 2015 3:36 am
by AhmedSamir
HI there,

Am tring to load 2,000,000 records to excel sheet, as we know the maximum records accepted per sheet is 1,000,000 as a consequnce i need to divide the records to two tabs.

how to solve this case ??

Posted: Thu Oct 29, 2015 5:37 am
by qt_ky
Just curious........................... Why? Is there a business user who is going to go through each record in Excel one by one?

Posted: Thu Oct 29, 2015 7:39 am
by AhmedSamir
Finance team need this sheets

Posted: Thu Oct 29, 2015 8:09 am
by chulett
Create multiple csv files, limited to 1M records max each.

Posted: Thu Oct 29, 2015 3:14 pm
by qt_ky
Ah, the "good old management by spreadsheet" method! :wink: