I have had to create large excel files before- and it would not work with Spreadsheet::WriteExcel. I believe that if it is over 36,000 lines or so, you need to use Excel::Writer::XLSX