in reply to Re: Need to generate excel having more than 70,000 records
in thread Need to generate excel having more than 70,000 records

I don't think that will work. Excel::Template says those options use Spreadsheet::WriteExcelXML or Spreadsheet::WriteExcel::Big as backends, and those modules still say they have a row limit of 65536. Spreadsheet::WriteExcel::Big lets you create files > 7MB, but still has the 65536 rows limit.

Update: The XML "template" of Excel::Template is a mini-DSL that the author uses to produce different kinds of files using the same code, and has nothing to do with the XML in Excel.

  • Comment on Re^2: Need to generate excel having more than 70,000 records

In Section Seekers of Perl Wisdom