Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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]];


Replies are listed 'Best First'.
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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://220276]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2018-05-27 20:42 GMT
Find Nodes?
    Voting Booth?