in reply to Re: Excel 2007 and Perl
in thread Excel 2007 and Perl
The next line is typical of how I write to one of the cells$excel = Win32::OLE->new('Excel.Application', 'Quit') or ($cell_re +s = 0);
This is how I save the spreadsheet.$excel->Cells($row, $col)->{Value} = $heading_item;
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.$excel->Workbooks(1)->SaveAs($manu_sprd) or ($excel_res = 0, $ew_mess +age = items spreadsheet");
|
|---|