merrymonk has asked for the wisdom of the Perl Monks concerning the following question:

I inlcude the lines of
use Win32::OLE;
use Win32::OLE::Const 'Microsoft Excel';

[download]
to give the Perl tools that I use to manipulate Excel spreadsheets.
This has worked well until now when one of my user's needs to use Excel 2007.
Various errors are being found including:
a. a written spreadsheet missing a column;
b. a requested spreadsheet not being found.

Can any one tell me what I have to use so that I can use my applications with Excel 2007?

Replies are listed 'Best First'.
Re: Excel 2007 and Perl
by andreas1234567 (Vicar) on Jun 14, 2007 at 12:03 UTC
    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})
[reply]
      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]

Back to Seekers of Perl Wisdom