Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Adding new workbook to existing excel

by LanX (Bishop)
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?
    [james28909]: i cannot understand how someone cant see that a cloud of gas that evolves into a solar system or galaxies. it just makes sense to me. everythign that has happened, had to have happened for anything on this planet to be.
    [james28909]: /gas/gas and debris/
    [james28909]: another thing, i used to be atheist. life experiences, personal evidence. and my own perception is the reason why i believe the things i do.
    [erix]: and now you are agnostic?
    [james28909]: arunbear, your picking bits of history to fit your own narrative. right now, humans are smarter than in any of those times.
    [james28909]: in order for there to be a mutation, there has to be a universe with laws setup that even allow a mutation.
    [james28909]: everything past the first two things you piked from my posts are irrelevant to me and my beliefs. they are side effects.

    How do I use this? | Other CB clients
    Other Users?
    Others having an uproarious good time at the Monastery: (17)
    As of 2017-12-15 14:53 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?
      What programming language do you hate the most?




















      Results (433 votes). Check out past polls.

      Notices?