I have written a perl script using Win32::OLe module.
I was able to read it completly.
but I have to specify the number of rows in excel sheet as command line option.
I want to know how to retrieve number of rows of the excel sheet and number of columns also.
i tried to retrieve the properties using the each methode.
see below
Expand|Select|Wrap|Line Numbers
- $book=$excel->Workbooks->open("demo.csv");
- while(my ($key,$value)=%$book)
- {
- print "$key:$value\n";
- }
Can Somebody please help me out to resolve this issue.
It will be of great help!!!!!
With Regards,
deep022in