in reply to Text file to Excel with perl

Looks like you want to convert pipe-separated data to Excel. Would csv2xls be an option for you?

$ csv2xls -s'|' -o file.xls file.txt

[download]

This utility does essentially what you describe, but switches to using Spreadsheet::WriteExcel::Big if the size of the input file is over 5Mb

Maybe just changing use Spreadsheet::WriteExcel; to use Spreadsheet::WriteExcel::Big; will fix your issue.

update: it used to switch to the ::Big version until Oct 2011, when I noted that Spreadsheet::WriteExcel deprecated ::Big back in 2007.


Enjoy, Have FUN! H.Merijn

Replies are listed 'Best First'.
Re^2: Text file to Excel with perl
by fishmonger (Chaplain) on Feb 28, 2014 at 18:11 UTC

    Spreadsheet::WriteExcel::Big is depreciated.

    DESCRIPTION

The module was a sub-class of Spreadsheet::WriteExcel used for creating Excel files greater than 7MB. However, it is no longer required and is now deprecated.

As of version 2.17 Spreadsheet::WriteExcel can create files larger than 7MB directly if OLE::Storage_Lite is installed.

This module only exists for backwards compatibility. If your programs use ::Big you should convert them to use Spreadsheet::WritExcel directly.
[reply]

      I know, but the OP did not state a version being used, so the ::Big version */might/* be a solution for him.


      Enjoy, Have FUN! H.Merijn
[reply]

In Section Seekers of Perl Wisdom