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

Re: Adding new workbook to existing excel

by LanX (Chancellor)
on Jan 29, 2013 at 10:55 UTC ( #1015847=note: print w/replies, xml ) Need Help??


in reply to Adding new workbook to existing excel

according to Spreadsheet::WriteExcel new() creates a new file, quote: "The following example creates a new Excel file based on a filename:"

And I can't find how to append to an existing file.

2 possible workarounds:

  • hold the data separately until you finalize he hole sheet at once.

  • use Spreadsheet::ParseExcel to read the old data and to rebuild the new spreadsheet

    Cheers Rolf

    • Comment on Re: Adding new workbook to existing excel
  • Replies are listed 'Best First'.
    Re^2: Adding new workbook to existing excel
    by Corion (Pope) on Jan 29, 2013 at 11:02 UTC

    Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Node Status?
    node history
    Node Type: note [id://1015847]
    help
    Chatterbox?
    [Corion]: ambrus: Yes, which kinda makes sense because Prima also has Postscript output or something, I think

    How do I use this? | Other CB clients
    Other Users?
    Others studying the Monastery: (6)
    As of 2016-12-09 10:53 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?
      On a regular basis, I'm most likely to spy upon:













      Results (150 votes). Check out past polls.