I am using POI 1.8.x version however with 2.5 version I can read all the rows.
-----Original Message----- From: Igor Androsov [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 9:51 AM To: POI Users List Subject: RE: Problem reading Excel File This is very strange because when I load it in my test program it read 54 rows but 2 last rows are invisible data Row 54 has 99999 value in 1 cell and row 53 has nothing. But in any case my code can read this file as long as I check for NULL values for rows and cells it works fine. Alsoe you haev svereal Formulas Reg Expressions that POI cannot read interpret. I even try to use new Alpha version HSSFFormularEvaluator and that allways failed with Null exceptions. Igor --- "Anand,Anuj" <[EMAIL PROTECTED]> wrote: > > Actually PhysicalRowNumber returns less number of > rows in the > spreadsheet. Only 32 HSSFROW objects are created. I > can't figure out why > that is so? > The total number of rows in the spreadsheet are 54. > > -----Original Message----- > From: Igor Androsov [mailto:[EMAIL PROTECTED] > Sent: Monday, August 29, 2005 10:22 PM > To: POI Users List > Subject: RE: Problem reading Excel File > > > I took a look at your Excel file adn run through my > test POI program I think your problem is You may > have > formula that did not produce a value but as result > of > it your Sheet has 1-2 extra ending rows reserved. > HOwever, those rows are not created by Excel since > formula did not return values so the problem is > PhysicalRowNumber returns more rows then actually in > a > sheet. > You need to test your code for Row being NOT NULL > and > it will work ok or check youe formulas. > > Igor > --- "Anand,Anuj" <[EMAIL PROTECTED]> wrote: > > > > > > > Thanks for your help. An interesting aspect is > that > > if I get rid of the > > formula in the first column of the spreadsheet ,it > > is processed in > > normal fashion and gives me more than 31 rows. > > > > I will try to incorporate that jar file and check > > .We are using POI > > version 1.8.x > > > > > > > > -----Original Message----- > > From: Page, Michael A. > > [mailto:[EMAIL PROTECTED] > > Sent: Monday, August 29, 2005 4:58 PM > > To: POI Users List > > Subject: RE: Problem reading Excel File > > > > > > > > I didn't actually look at your code. I'm hoping > > what I send you > > will help > > you fix yours. > > > > The attached java source file was able to read > your > > excel > > spreadsheet. > > I copied your excel file to the root of my c > drive > > and renamed > > it HSSF.xls. > > I use eclipse 3.1 as my development package and > > have the > > poi-2.5.1-final-20040804.jar added as an external > > jar file. This jar > > file resides in the > > > > same location of the java source file. I'm not > sure > > why my code > > indicates > > more rows and columns then your data would > > indicate. Perhaps you > > have some > > hidden values floating around. > > > > Hope this helps. > > > > Mike > > > > -----Original Message----- > > From: Anand,Anuj [mailto:[EMAIL PROTECTED] > > Sent: Monday, August 29, 2005 3:25 PM > > To: POI Users List > > Subject: RE: Problem reading Excel File > > > > > > Sorry for sending out the message > > repeatedly....Attached is the > > inline > > code > > > > > > import java.io.FileInputStream; > > import java.io.FileOutputStream; > > import java.io.IOException; > > import java.io.InputStream; > > import java.util.Calendar; > > import java.util.Date; > > > > > > import org.apache.poi.hssf.dev.HSSF; > > import org.apache.poi.hssf.record.Record; > > import org.apache.poi.hssf.usermodel.HSSFCell; > > import > org.apache.poi.hssf.usermodel.HSSFCellStyle; > > import > > org.apache.poi.hssf.usermodel.HSSFDataFormat; > > import > org.apache.poi.hssf.usermodel.HSSFDateUtil; > > import org.apache.poi.hssf.usermodel.HSSFFont; > > import org.apache.poi.hssf.usermodel.HSSFRow; > > import org.apache.poi.hssf.usermodel.HSSFSheet; > > import > org.apache.poi.hssf.usermodel.HSSFWorkbook; > > import org.apache.poi.hssf.util.Region; > > import > > org.apache.poi.poifs.filesystem.POIFSFileSystem; > > > > > > > > > > > > > > /** > > * File for HSSF testing/examples > > * > > * THIS IS NOT THE MAIN HSSF FILE!! This is a > util > > for testing > > functionality. > > * It does contain sample API usage that may be > > educational to > > regular > > API users. > > * > > * @see #main > > * @author Andrew Oliver (acoliver at apache dot > > org) > > */ > > > > > > public class Test > > { > > private String filename = null; > > > > > > // private POIFSFileSystem fs = > > null; > > private InputStream stream = null; > > private Record[] records = null; > > protected HSSFWorkbook hssfworkbook = null; > > static char cell_flag = 'N'; > > static char row_flag = 'N'; > > > > /** > > * Constructor HSSF - creates an HSSFStream > > from an > > InputStream. > > The HSSFStream > > * reads in the records allowing > modification. > > * > > * > > * @param filename > > * > > * @exception IOException > > * > > */ > > > > > > public Test(String filename) > > throws IOException > > { > > this.filename = filename; > > POIFSFileSystem fs = > > new POIFSFileSystem(new > > FileInputStream(filename)); > > > > > > /* POIFSFileSystem fs1 = > > new POIFSFileSystem(new > > FileInputStream(filename)); > > / p1 = new FileInputStream(*/ > > > > > > hssfworkbook = new HSSFWorkbook(fs); > > > > > > // records = > > RecordFactory.createRecords(stream); > > } > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
