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

Can't you read in the static data (from an Excel worksheet or elsewhere) and then generate your dynamic data and output the static data in the same (dynamic) sheet. As far as WriteExcel is concerned it doesn't matter whether the data is truly dynamic or just copies of static data.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

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

Replies are listed 'Best First'.
Re^4: Best practices for linking dynamic Excel data to static Excel data? by markjugg (Curate) on Aug 23, 2005 at 01:45 UTC
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	[reply]
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]