Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

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

by markjugg (Curate)
on Aug 22, 2005 at 21:30 UTC ( [id://485775]=note: print w/replies, xml ) Need Help??


in reply to Re: Best practices for linking dynamic Excel data to static Excel data?
in thread 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?

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

      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!

        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://485775]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2024-03-29 14:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found