Write to multiple excel tabs ?

AhmedSamir · Post by **AhmedSamir** » Thu Oct 29, 2015 3:36 am

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 ??

qt_ky · Post by **qt_ky** » Thu Oct 29, 2015 5:37 am

Just curious........................... Why? Is there a business user who is going to go through each record in Excel one by one?

AhmedSamir · Post by **AhmedSamir** » Thu Oct 29, 2015 7:39 am

Finance team need this sheets

chulett · Post by **chulett** » Thu Oct 29, 2015 8:09 am

Create multiple csv files, limited to 1M records max each.

qt_ky · Post by **qt_ky** » Thu Oct 29, 2015 3:14 pm

Ah, the "good old management by spreadsheet" method!