I used 2.5 and also 3.0 Alpha versions and could read all rowswith data. Still I recieved some rows as NULLf rrom file you sent. Those rows in Excel show no visible data.
Igor --- "Anand,Anuj" <[EMAIL PROTECTED]> wrote: > > 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; > === 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/
