Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^4: Best practices for linking dynamic Excel data to static Excel data?

by markjugg (Curate)
on Aug 23, 2005 at 01:45 UTC ( [id://485802]=note: print w/replies, xml ) Need Help??


in reply to Re^3: Best practices for linking dynamic Excel data to static Excel data?
in thread Best practices for linking dynamic Excel data to static Excel data?

A variation of this might work. The static data would be a pain to import properly, because it contains formatting. However, I could keep the nicely formatted static data in it's own file for user reference, and then use DBD::Excel or a CSV export to import just the column I need for my calculation.

Thanks for the suggestion CountZero. It's simple enough that it might just work!

Replies are listed 'Best First'.
Re^5: Best practices for linking dynamic Excel data to static Excel data?
by MidLifeXis (Monsignor) on Aug 23, 2005 at 17:54 UTC

    I can also give high marks to Spreadsheet::ParseExcel to load user data. I am using this right now to bring a slew of data together from multiple sources. It helps to allow the user to work in a tool they are familiar with, and then be able to slurp it in and process it as a chunk of data on the back end.

    --MidLifeXis

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (6)
As of 2024-03-28 11:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found