in reply to Splitting the records into multiple worksheets

I am having trouble running your code.
I installed Excel::Writer::XLSX on my Win10 machine.

In the following code, new( 'filename.xlsx' ) succeeds and generates a workbook, but for some reason new ('C:/Details.xlsx' ); fails. I am not sure why that is?

use strict; use warnings; use Excel::Writer::XLSX; $|=1; ## Create Excel File. #my $workbook = Excel::Writer::XLSX->new( 'C:/Details.xlsx' ); my $workbook = Excel::Writer::XLSX->new( 'filename.xlsx' ); print "workbook is $workbook\n"; __END__
Update:
It is hard for me to imagine a spreadsheet with 616,337 rows! In theory, I guess this is possible, but not a good way to proceed.