Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Adding new workbook to existing excel

by LanX (Canon)
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
    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?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others studying the Monastery: (15)
    As of 2014-08-28 15:11 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      The best computer themed movie is:











      Results (263 votes), past polls