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!

Mark Stosberg

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

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

[reply]

In Section Seekers of Perl Wisdom