Writing to an Excel Spreadsheet

Discussion in 'Perl Misc' started by FSD, Feb 19, 2005.

  1. FSD

    FSD Guest

    I am using the Spreadsheet-WriteExcel-211 module to write values into a
    spreadsheet. The module is very powerful and robust, but there is one thing
    that I cannot seem to do. I need to open a spreadsheet daily and write
    values to it. Not a problem, but I do not know how to append to a sheet.
    That is, I do not know how to find the last row in the sheet and then simply
    write to $lastrow+1. Does anyone have an idea how I can do this?
    Thanks
    FSD
     
    FSD, Feb 19, 2005
    #1
    1. Advertising

  2. FSD

    Steven Kuo Guest

    On Fri, 18 Feb 2005, FSD wrote:

    > I am using the Spreadsheet-WriteExcel-211 module to write values into a
    > spreadsheet. The module is very powerful and robust, but there is one thing
    > that I cannot seem to do. I need to open a spreadsheet daily and write
    > values to it. Not a problem, but I do not know how to append to a sheet.
    > That is, I do not know how to find the last row in the sheet and then simply
    > write to $lastrow+1. Does anyone have an idea how I can do this?
    > Thanks
    > FSD
    >




    Spreadsheet::parseExcel defines a "Worksheet" object that
    appears to be a blessed hash reference and allows one
    to find the last row by dereferencing. E.g.,

    $oWkS->{MaxRow}

    See the documentation for Spreadsheet::parseExcel for details.
    Use it to parse the spreadsheet, then use Spreadsheet::WriteExcel
    to update the spreadsheet.

    --
    Hope this helps,
    Steven
     
    Steven Kuo, Feb 19, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. FSD
    Replies:
    0
    Views:
    1,203
  2. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,548
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  3.  James
    Replies:
    0
    Views:
    174
    James
    May 19, 2011
  4. Will James
    Replies:
    22
    Views:
    669
    Will James
    May 26, 2011
  5. Pam
    Replies:
    2
    Views:
    105
Loading...

Share This Page