Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://948615]
help
Chatterbox?
[ambrus]: choroba: cbstream alternates between the three direct IP addresses, without hostname, and switches to the next immediately at the first slowdown or error. this heuristic seems to help.
[choroba]: ambrus But pm-cb-g need sto stay logged in

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (7)
As of 2017-10-24 11:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My fridge is mostly full of:

















    Results (288 votes). Check out past polls.

    Notices?