Re^2: Help,WIN32::OLE parse EXCEL ,run error

in reply to Re: Help,WIN32::OLE parse EXCEL ,run error
in thread Help,WIN32::OLE parse EXCEL ,run error

That's because you're not effectively using the Win32::OLE interface to Excel. You want to use the Find function. See a handy reference of Excel methods at the Tek-Tips Forums site. Specifically, check out the "#___ FIND LAST ROW/COLUMN WITH DATA" section. I think you can adapt that to your needs.

Comment on Re^2: Help,WIN32::OLE parse EXCEL ,run error

Replies are listed 'Best First'.
Re^3: Help,WIN32::OLE parse EXCEL ,run error by Anonymous Monk on Jan 26, 2011 at 05:25 UTC
After add $last_row and $last_col,program is still slow speed.Is there a way to optimize the code to run by speed? Thanks,my friend.	[reply]

In Section Seekers of Perl Wisdom