Hi, I'm new in this list, and I've just begun to use POI too.
I'm trying to create a workbook in a servlet, to read an Excel file submitted
by a form.
This is exactly what I'm doing:
---
import org.apache.poi.hssf.usermodel.*;
...
ServletInputStream is = request.getInputStream(
There is a way to make the row height zero.
Try using row.setHeight((short) 0);
Usha Davuluri
SRA International, Inc.
Environmental & Organizational Services
Phone: (703) 292 5940
-Original Message-
From: Clint A Brubakken [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 15, 2005 3:20
I looked at the api and the examples, and I didn't see any, is there an
undocumented way?
--
Clint A Brubakken
Senior Software Developer
Computer Science Services Group
[EMAIL PROTECTED]
316-269-9090 ext 201
-
To unsubscrib
If it's a format that is in there already, then no, it will not cause
problems. Now if you did many cell styles, it would blow you up. You can
even test it by doing the getFormat with a particular format twice. It
should return the same value both times. If not, let me know and I'll fix
it.
Sh
Hi Christian.
Be careful.
If you've a lot of date cells and do workbook.createDataFormat() for any
such cell it'll result in too many data formats. Do it just once and
then refer to it when using a date format.
Regards, Karl-Heinz.
Am Di 15.11.2005 18:32 schrieb Christian Gosch <[EMAIL PROTECT
OK, I got this by myself too.
Although not being very obvious, I found by decompilation that
"HSSFDataFormat myFormat = workbook.createDataFormat()" and a successive
call to "myFormat.getFormat("DD.MM.")" creates an appropriate format, if
there is no such one in the workbook. That does the job
OK, the first step I have got now, and to be honest, I did not tell the
whole truth about my code, because I did not think of the missing part being
of special meaning :-(
In fact I "reused" _one_ HSSFCellStyle object and tried to give it another
DataFormat any time I use it. But there does not se
That's add as the data format 15 DEC is really "d-mmm-yy". Would it be
possible to attach an example sheet along with a list of a cell or two that
has that particular format.
Shawn
-Original Message-
From: Christian Gosch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 15, 2005 10:36
Hi,
I cannot successfully format a cell with "DD.MM." nor with any other
date format. All I get is "#.##0" number format for the cells. How can I
achieve "DD.MM." formatting?
POI version: 2.5.1 final (this is fairly old, but there does not seem to be
any newer "final" version :-( )
C
Hi CP.
Did you use a template? If yes then try to rebuild it from the scratch.
If no then try how the reaction is when using a template.
Regards, Karl-Heinz.
Am Di 15.11.2005 00:04 schrieb CP Agrawal <[EMAIL PROTECTED]>:
> Hi,
> I get this error when I try to open an xls file generated using P
10 matches
Mail list logo
