Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Read Excel cell comments?

by veeruch (Sexton)
on Apr 02, 2007 at 12:59 UTC ( [id://607812]=note: print w/replies, xml ) Need Help??


in reply to Read Excel cell comments?

you can create,read,insert,update in to excel.
for update into Excel:
use Spreadsheet::ParseExcel::SaveParser;
Below code is reading Excel data from CELL
use Spreadsheet::ParseExcel;<br> my $oBook = $oExcel->Parse("test.xls"); $oWkS = $oBook->{Worksheet}[0]; for(my $iR = 0;defined $oWkS->{MaxRow} && $iR <= $oWkS->{MaxRow} ; $iR +++) { $oWkC0 = $oWkS->{Cells}[$iR][0]; $oWkC1 = $oWkS->{Cells}[$iR][1]; if ($oWkC0->{Val}){ print "$oWkC0->{Val}-------$oWkC1\n"; } }
regards
veeru
"The fragrance of flowers spreads only in the direction of the wind. But the goodness of a person spreads in all direction"

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://607812]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (3)
As of 2024-04-20 05:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found