You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "McIntosh, Mike" <Mi...@schwab.com> on 2004/03/17 16:51:14 UTC

Reading different worksheets

When reading an Excel file, how can I find a specific worksheet by name?

Is this different when using eventmodel parsing vs. the usermodel?  It seems
that the BoundSheetRecord shows the name, but I can't figure out how to
relate that to the cell records I want.

Thanks for your time,

Mike McIntosh
Principal Engineer
Charles Schwab & Co.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

AW: Reading different worksheets

Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Hi Mike.

Let oWB be the workbook.

Then
	sRet = this.oiWB.getSheetName(3);
e.g. returns the name of the 3rd sheet.

So you just need to search until it fits.

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: McIntosh, Mike [mailto:Mike.McIntosh@schwab.com] 
Gesendet: Mittwoch, 17. März 2004 16:51
An: 'poi-user@jakarta.apache.org'
Betreff: Reading different worksheets

When reading an Excel file, how can I find a specific worksheet by name?

Is this different when using eventmodel parsing vs. the usermodel?  It
seems
that the BoundSheetRecord shows the name, but I can't figure out how to
relate that to the cell records I want.

Thanks for your time,

Mike McIntosh
Principal Engineer
Charles Schwab & Co.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org