Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Writing Excel spreadsheets with Perl

by jmcnamara (Monsignor)
on Dec 16, 2002 at 17:17 UTC ( #220276=note: print w/ replies, xml ) Need Help??


in reply to Writing Excel spreadsheets with Perl


The second difficulty was that the code ran very slowly. ... My conjecture (though I have no hard data to back it up) is that the problem was my cell-at-a-time code.

This may well be the case. Writing data to Excel via Win32::OLE can be significantly faster if you write it in one go. Example from ActivePerl-Winfaq12:

my $Range = $Sheet->Range("A2:C7"); $Range->{Value} = [['Delivered', 'En route', 'To be shipped'], [504, 102, 86], [670, 150, 174], [891, 261, 201], [1274, 471, 321], [1563, 536, 241]];

--
John.


Comment on Re: Writing Excel spreadsheets with Perl
Download Code
Re (2): Writing Excel spreadsheets with Perl
by VSarkiss (Monsignor) on Dec 16, 2002 at 17:28 UTC

    Aha! I wasn't aware that was possible. If I have an opportunity, I'll try a row-at-a-time style and report on the results.

    Thanks for the pointer to the FAQ, BTW.

Re^2: Writing Excel spreadsheets with Perl
by Anonymous Monk on Mar 15, 2013 at 11:02 UTC

    This solved my prob as i was dyin to find Win32::OLE based code to enter my values to the sheet bt always found Spreadsheet::WriteExcel. Its simple and fast...

    Thanks Dharma

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://220276]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (5)
As of 2014-09-23 03:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (210 votes), past polls