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 p
Thanks for your response. I've looked at the relevant code and see that the
class HSSFCell stores the variant and various types and not all members will
be populated depending of the underlying cell data type. I would say that it
is an implementation detail that the single class HSSFCell has mem
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 Mes
Sorry for sending out the message repeatedlyAttached 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.a
Title: Problem reading Excel File
Attached is the JAVA File which tries to read the following Excel File.
<>
<>
The problem is that only the first 32 Rows are read by the Program although the Total Number of Rows are more than that number.
Any idea why this is happening?
-O
Title: FW:
-Original Message-
From: Anand,Anuj
Sent: Monday, August 29, 2005 3:27 PM
To: '[EMAIL PROTECTED]'
Subject:
I need to resolve the following spreadsheet
<>
POI is reading only the first 32 rows from it. Cna somebody help me out with that
Hi Sanjiv.
It can't work. It's a variant and the type determines which field has to
be read. So when there's a numeric value inside the content of the
string field may be arbitrary.
With formulas there are less exceptions. There you just receive an empty
value if you query with the wrong type.
R
Now i get this exception:
Exception in thread "main" java.lang.RuntimeException: Couldn't instantiate
the class for type with id 1016 on class class
org.apache.poi.hslf.record.DummyPositionSensitiveRecordWithChildren :
java.lang.reflect.InvocationTargetException
at
org.apache.poi.hslf.rec
Hi,
i want to extract the contents from PowerPoint files.
I use the hslf classes!
But i get the Exception:
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 8
at org.apache.poi.util.HexDump.toHex(HexDump.java:406)
at org.apache.poi.util.HexDump.toHex(HexDump.ja