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

I haven't tested your code, but I doubt you really want 1 .. 300 for the columns. This would be more appropriate:

foreach my $col ( 'A' .. 'XFD' ) # Assuming >= Office 2007 { foreach my $row ( 1 .. 300) { next unless defined $Sheet->Cells("$col$row")->{Value}; # the rest of your code here } }

Replies are listed 'Best First'.
Re^2: Help,WIN32::OLE parse EXCEL ,run error
by perllee (Novice) on Jan 25, 2011 at 07:28 UTC
    Thank you,friend. OK.