peterchan75
Supremacy Member
- Joined
- Apr 26, 2003
- Messages
- 6,468
- Reaction score
- 447
Hi All,
I am trying to use perl to update some excel spreadsheet using Win32 OLE.
1. Comparing ($sheet->Cells(1,1)->{Value} eq $input_array[0]) didn't work. @input_array contained 1 to 5 character string.
But it worked with this ($sheet->Cells(1,1)->{Text} eq $input_array[0]) . Any idea ?
2. Trying to assign a text string to a cell.
$sheet->Cells(1,1)->{Text} = $input_array[0] didn't work.
But $sheet->Cells(1,1)->{Value} = $input_array[0] worked. Any idea ?
Thanks.
I am trying to use perl to update some excel spreadsheet using Win32 OLE.
1. Comparing ($sheet->Cells(1,1)->{Value} eq $input_array[0]) didn't work. @input_array contained 1 to 5 character string.
But it worked with this ($sheet->Cells(1,1)->{Text} eq $input_array[0]) . Any idea ?
2. Trying to assign a text string to a cell.
$sheet->Cells(1,1)->{Text} = $input_array[0] didn't work.
But $sheet->Cells(1,1)->{Value} = $input_array[0] worked. Any idea ?
Thanks.