Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: LastCol of an Excel spreadsheet as an alphanumeric using Win32::Ole

by bmann (Priest)
on Nov 23, 2005 at 00:27 UTC ( #510970=note: print w/replies, xml ) Need Help??


in reply to LastCol of an Excel spreadsheet as an alphanumeric using Win32::Ole

You can access a given cell by index, ie:
my $row = 1; my $date = $Sheet->Cells( $row, $LastCol )->{ Value };

You can also get the last cell by using the SpecialCells method (caveat - Excel's notion of "Last Cell" is confusing at best):

my $date = $excel->ActiveCell->SpecialCells( xlLastCell )->{Value}; # assuming you've imported Excel's constants with Win32::OLE::Const

HTH...

BTW, I believe that valof is unnecessary in this case - perl sees the date as a date. If it is necessary, you'll need to change the call to ... = Win32::OLE::valof( $Sheet->... )

Update: Reading the other replies, I realize you want row 1. I thought you wanted the last cell. Added $row = 1

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://510970]
help
Chatterbox?
[james28909]: or the act of getting the data that way is called dereference?
[james28909]: sorry for the dumb questions
[james28909]: oh ok, i gotcha
[shmem]: "talking of facts, it is irrelevant what you or I think about them." --Georg C. Lichtenberg
[james28909]: is reference the same as aliasing?
[shmem]: no
[shmem]: aliasing means "accessing the same thing by another name"
[james28909]: this makes sense to me. https://stackoverf low.com/questions/ 14224831/meaning- of-referencing-and -dereferencing
[james28909]: stack overflow
[james28909]: i think im going to ditch perl and learn C

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2018-05-20 15:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?