Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Re: Detecting and Deleting empty rows and cols in excel using win32::OLEby strat (Canon) |
on Sep 20, 2008 at 09:17 UTC ( [id://712711]=note: print w/replies, xml ) | Need Help?? |
Hello, you can use the method UsedRange on a worksheet object to find the last used cell in a worksheet object. This way, you don't need to iterate over all 64K rows (or more with Excel 2007) which should save much time. But I don't know a better way to find out which lines or columns are empty than an iteration.
Best regards,
In Section
Seekers of Perl Wisdom
|
|