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

Thank you,friend.

foreach 50000 rows:

use time: 293 wallclock secs (68.59 usr + 45.39 sys = 113.98 CPU)

So slowly.

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

Replies are listed 'Best First'.
Re^2: Help,WIN32::OLE parse EXCEL ,run error
by Sinistral (Monsignor) on Jan 25, 2011 at 15:30 UTC

    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.

      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.