Apache POI Question

Discussion in 'Java' started by Si, Dec 16, 2004.

  1. Si

    Si Guest

    I'm parsing an MS Excel spreadsheet using the POI HSSF event api, as this is
    reportedly much faster than reading the entire sheet in as a HSSFSheet
    object.

    This works well but still takes a long time so I want to give the user some
    feedback on progress. However I can't seem to find a good way of knowing how
    large the spreadsheet is going to be and how far through it I am at any one
    point.

    If anyone has experience of using this api and can help I'd very much
    appreciate it.

    Thanks,

    Simon
     
    Si, Dec 16, 2004
    #1
    1. Advertising

  2. Si wrote:
    > I'm parsing an MS Excel spreadsheet using the POI HSSF event api, as this is
    > reportedly much faster than reading the entire sheet in as a HSSFSheet
    > object.
    >
    > This works well but still takes a long time so I want to give the user some
    > feedback on progress. However I can't seem to find a good way of knowing how
    > large the spreadsheet is going to be and how far through it I am at any one
    > point.
    >
    > If anyone has experience of using this api and can help I'd very much
    > appreciate it.
    >
    > Thanks,
    >
    > Simon
    >
    >


    Use the Excel object model to get the number of worksheets in the
    workbook. For each worksheet you can try using the UsedRows property to
    get some idea - though it depends on the dimensions of your sheets.

    Pan
    ===========================================
    TechBookReport - http://www.techbookreport.com
     
    TechBookReport, Dec 17, 2004
    #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. Replies:
    0
    Views:
    14,133
  2. anand

    APIs similar to Apache POI

    anand, Jun 5, 2006, in forum: Java
    Replies:
    0
    Views:
    406
    anand
    Jun 5, 2006
  3. Replies:
    0
    Views:
    446
  4. Replies:
    9
    Views:
    6,871
  5. the apache poi API

    , Aug 17, 2007, in forum: Java
    Replies:
    1
    Views:
    361
    Roedy Green
    Aug 18, 2007
Loading...

Share This Page