in reply to Excel 2007 and Perl

Can any one tell me what I have to use so that I can use my applications with Excel 2007?
If you could post some code along with the errors your get, someone probably could.
--
print map{chr}unpack(q{A3}x24,q{074117115116032097110111116104101114032080101114108032104097099107101114})

Replies are listed 'Best First'.
Re^2: Excel 2007 and Perl
by merrymonk (Hermit) on Jun 15, 2007 at 07:52 UTC
    As an example of the code, below is the line use to open a spreadsheet.
        $excel = Win32::OLE->new('Excel.Application', 'Quit') or ($cell_re
+s = 0);

    [download]
    The next line is typical of how I write to one of the cells
        $excel->Cells($row, $col)->{Value} = $heading_item;

    [download]
    This is how I save the spreadsheet.
    $excel->Workbooks(1)->SaveAs($manu_sprd)  or ($excel_res = 0, $ew_mess
+age = items spreadsheet");

    [download]
    The only actual error message was a Microsoft dialog box that said
    Can't find spreasheet'
    but as indicated initially, a written spreadsheet had one column missing and two columns swapped in position.
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom