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

[download]

--
John.

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.

[reply]
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
[reply]

In Section Meditations