Hi
I have an array with a variable number of multi lines records. Array contains data coming from different txt files. I dont care the file contents, I just need to copy and paste it into Excel worksheets
All other script routines have been developed using Win32::Ole module.
The question is which it would be the best way to write the content of the whole file (array) into the spreadheet since files are huge and write cell by cell consumes too much.
SpreadsheetWriteExcel Module has the solution but I would like to keep the program simple just using Win32OLE Module.
SpreadsheetWriteExcel uses this
What would it be the command for Win32OLE. keep in mind that I dont know number of records, so use Range Excel cant be constant.
When I use it, the whole array contents go to cell A1,
Comments??
dmazzini
GSM/UMTS System and Telecomm Consultant
I have an array with a variable number of multi lines records. Array contains data coming from different txt files. I dont care the file contents, I just need to copy and paste it into Excel worksheets
All other script routines have been developed using Win32::Ole module.
The question is which it would be the best way to write the content of the whole file (array) into the spreadheet since files are huge and write cell by cell consumes too much.
SpreadsheetWriteExcel Module has the solution but I would like to keep the program simple just using Win32OLE Module.
SpreadsheetWriteExcel uses this
Code:
$Sheet_Stats{$tab}->write('A1', [ @INFO ]);
What would it be the command for Win32OLE. keep in mind that I dont know number of records, so use Range Excel cant be constant.
When I use it, the whole array contents go to cell A1,
Code:
$Sheet_Stats{$tab}->Cells(1,1)->{Value} = @INFO;
Comments??
dmazzini
GSM/UMTS System and Telecomm Consultant