Yes - it is on a user's system. My Perl applications reads from and writes to various spreadsheets. I also save copies of spreadsheets to pdf files.
Also I know Excel is used to modify the spreadsheets that I read from.
Some of the Excel 'lines' I use successfully are below
eval { $excel = Win32::OLE->GetActiveObject( 'Excel.Application' ) };
eval { $workbook = $excel->Workbooks->Open($hist_full)};
$worksheet = $workbook->Worksheets($wksh_no);
$$ref_cell_array = $worksheet->range($excel_data_range)->{'value'};
$close_res = $workbook->Close();
The odd thing is that 'Const' was not causing a problem and then it was reported as not working. |