Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re^6: XLSX read and dump

by chirp84 (Novice)
on Jan 18, 2012 at 20:11 UTC ( #948615=note: print w/replies, xml ) Need Help??

in reply to Re^5: XLSX read and dump
in thread XLSX read and dump

Okay, the data file I renamed had the wrong extension. I had .xls, after I changed to .xlsx the script ran. All the data from excel printed into my terminal window in the format below:
( 1 , 1 ) => -230 ( 1 , 2 ) => -201.25 ( 1 , 3 ) => -172.5 ( 1 , 4 ) => -143.75
and so on... Also, I changed the code to reflect exactly what the Spreadsheet::XLSX synopsis shows because my actual row and column names were causing errors. Now the question is: How can I print just the cells I want to a separate file?

Replies are listed 'Best First'.
Re^7: XLSX read and dump
by talexb (Canon) on Jan 18, 2012 at 20:28 UTC
      How can I print just the cells I want to a separate file?

    What does the documentation say?

    Alex / talexb / Toronto

    "Groklaw is the open-source mentality applied to legal research" ~ Linus Torvalds

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://948615]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (3)
As of 2018-05-26 02:48 GMT
Find Nodes?
    Voting Booth?