in reply to Best practices for linking dynamic Excel data to static Excel data?

Can the other sheet be in the same file as the one that you're generating? As far as I remember, you can reference cells in other sheets in the same file with Spreadsheet::WriteExcel.

thor

Feel the white light, the light within
Be your own disciple, fan the sparks of will
For all of us waiting, your kingdom will come

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

Replies are listed 'Best First'.
Re^2: Best practices for linking dynamic Excel data to static Excel data?
by markjugg (Curate) on Aug 22, 2005 at 21:30 UTC
    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

[reply]
      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]
        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]

In Section Seekers of Perl Wisdom