Excel to perl

[rpn...@ibksoftware.com]

John;

I might be crazy,but I think there was a script that read an existing
excel file and created a perl program from it. Am I right? if so where
can I get it?

[jmcnamara]

On Oct 29, 2:49 am, "rpno...@ibksoftware.com"

Hi,

There is a Win32::OLE program that ships with the WriteExcel distro
called lecxel.pl that convert an Excel file to a WriteExcel program:

http://cpansearch.perl.org/src/JMCNAMARA/Spreadsheet-WriteExcel-2.25/examples/lecxe.pl

Alternatively, you could create a template of the file you want and
add to it using Spreadsheet::ParseExcel::SaveParser (with some
caveats):

http://search.cpan.org/~jmcnamara/Spreadsheet-ParseExcel-0.55/lib/Spreadsheet/ParseExcel/SaveParser.pm


John.
--