Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
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?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others browsing the Monastery: (10)
    As of 2016-05-04 18:41 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?