Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

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]
[james28909]: yep, i am scraping a websites date/time stamp from an article. none of that is relevant though because the strings i get are as expected. the returned data from the website is the list of @weekdays
[james28909]: i need to convert those @weekdays to an numerical date based off of scalar localtime

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2017-04-29 03:47 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (531 votes). Check out past polls.