[Announce] Apache POI 3.1 BETA1 Released

Hi All, The POI team is pleased to announce the release of 3.1 BETA1 which is one of the final steps before 3.1 FINAL. Apache POI is well-known in the Java field as a library for reading and writing OLE2 office file formats, such as Excel, PowerPoint, Visio and Word. The status of this release

Re: Numeric Cell value like zip code

Thanks for the information. That does explain a lot. For my users, I might have to have them take more responsibility for what is in the Excel file and making sure the data is correct. Or, is there a way to use POI to programmatically convert the xls file to a csv file? Then everything wou

How dose POI [h]:mm:ss dataformat work?

I was trying to read some data like "27:10:11" from a file and put into a cell, I set the cell type to HSSFCell.CELL_TYPE_NUMERIC and cell style to [h]:mm:ss But it didn't work, in the Excel I got "613683:10:11". code: HSSFCellStyle style = wb.createCellStyle(); style.setDataFormat(HSSFDataForma

Re[2]: How to write rows into an existing power point table using hslf

> Is there any way by which I can make a table report, say I'm reading the > data from > Database and create the records. Is it possible to get the Anchor of the > header and > Replicate the same below. Not yet, although it seems to be a good improvement. I will see if I can include it in the u

RE: How to write rows into an existing power point table using hslf

Is there any way by which I can make a table report, say I'm reading the data from Database and create the records. Is it possible to get the Anchor of the header and Replicate the same below. Thanks Shine -Original Message- From: Yegor Kozlov [mailto:[EMAIL PROTECTED] Sent: Tuesday,

Re: How to write rows into an existing power point table using hslf

No, tables in HSLF are immutable. You can't modify the number of columns/rows in existing tables. Yegor > Hi > I have a power point slide containing a Table. > I can read the table headings columns by iterating over the ShapeGroup > object. > Does POI - HSLF provide any mechanism to write recor

How to write rows into an existing power point table using hslf

Hi I have a power point slide containing a Table. I can read the table headings columns by iterating over the ShapeGroup object. Does POI - HSLF provide any mechanism to write records into that table. Thanks Shine

RE: Outofmemory Exception when the no of rows > 20000.

Please Increase JVM memory. Thanks Ravendra -Original Message- From: Nisanth Sivaraman [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 29, 2008 2:15 PM To: [EMAIL PROTECTED] Subject: Outofmemory Exception when the no of rows > 2. Hi , I am using POI for excel uploading. But I a

Re: Outofmemory Exception when the no of rows > 20000.

On Tue, 29 Apr 2008, Nisanth Sivaraman wrote: > I am using POI for excel uploading. > > But I am getting Outofmemory Exception when the no of rows > 2. Just increase the amount of memory you give to your JVM. The default is rather small compared to machines these days Nick -

Outofmemory Exception when the no of rows > 20000.

Hi , I am using POI for excel uploading. But I am getting Outofmemory Exception when the no of rows > 2. Please suggest some solution. Thanks, Nis

Re: Numeric Cell value like zip code

On Mon, 28 Apr 2008, Tom Holmes Jr. wrote: > However, columns like zip code and phone numbers are coming back with a > numeric value as a double. This indicates that excel is really storing them as a number, and not as a string. If you want to force excel to store them as a number, prefix them wit