Calling macros in Perl

nisha has asked for the wisdom of the Perl Monks concerning the following question:

Hello perlmonks, I have a problem with using csv files; if the number of records exeed a certain value, these files cannot be opened with excel. I found a macro which could be run and it would span the extra records to the next sheet in the excel file thus solving the problem. I wanted to know if there is any way where i could call the macro from perl program, how do i go about calling the macro from the perl program. Please guide me with this. Thank You, looking forward for your help. Nisha

Comment on Calling macros in Perl

Replies are listed 'Best First'.
Re: Calling macros in Perl by murugu (Curate) on Dec 20, 2005 at 06:40 UTC
Hi nisha, Have a look at this node Using Win32::OLE and Excel - Tips and Tricks. In that node its mentioned how to run macro. Regards, Murugesan Kandasamy use perl for(;;);	[reply]
Re: Calling macros in Perl by reneeb (Chaplain) on Dec 20, 2005 at 08:58 UTC
If you want to create the Excel files without Win32::OLE, you can look at Spreadsheet::WriteExcel or Spreadsheet::SimpleExcel. S::SE creates a new sheet in the file every 32000th row (you can change this value)...	[reply]
Re: Calling macros in Perl by holli (Abbot) on Dec 20, 2005 at 11:18 UTC
With so many rows this really sounds like a database job to me. Is there a special reason why you cannot use Access? holli, /regexed monk/	[reply] [d/l]
Re: Calling macros in Perl by blazar (Canon) on Dec 20, 2005 at 10:12 UTC
It doesn't have directly to do with excel, but Text::CSV_XS is useful to deal with csv files, and I've used to a great advantage!	[reply]