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

Thanks for the response, thor.

You are right that this feature exists, but the crux of the issue is that this static data needs to be easy to update, preferably through Excel. Is there way to use Spreadsheet::WriteExcel to generate part of Workbook dynamically, and include other worksheet pages as static documents?

Mark Stosberg

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

Replies are listed 'Best First'.
Re^3: Best practices for linking dynamic Excel data to static Excel data? by CountZero (Bishop) on Aug 22, 2005 at 22:10 UTC
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	[reply]
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]