RE: Java version requirement?

2004-03-26 Thread Robert Lowe
I am using POI with 1.3.1. It works fine. Best regards, Robert Lowe http://RMLowe.com/ -Original Message- From: news [mailto:[EMAIL PROTECTED] Behalf Of Jennifer Amon Sent: Saturday, March 27, 2004 4:07 AM To: [EMAIL PROTECTED] Subject: Java version requirement? Hi, everyone! Does

RE: AW: AW: AW: can't open workbook

2004-03-18 Thread Robert Lowe
b, and enter those settings in the "VM arguments" box. Best regards, Robert Lowe http://RMLowe.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: AW: AW: AW: can't open workbook

2004-03-18 Thread Robert Lowe
I think Eclipse always forks a new JVM process when you run a project, at least in 2.x. You can set the default and maximum heap size as JVM options under the "Run..." options. Best regards, Robert Lowe http://RMLowe.com/ -Original Message- From: Karl-Heinz Zengerle [mai

RE: Problem with writing big Excel file

2004-02-09 Thread Robert Lowe
You'll need to increase the max. heap size of the JVM, using a JVM argument like e.g. –Xmx256m (to make the max. heap size 256 MB). Modify the batch file (catalina.bat I think)--find the line where it invokes java and add that switch to the command line. Best regards, Robert Lowe

RE: Exception =java.lang.ArrayIndexOutOfBoundsException: 112

2004-01-21 Thread Robert Lowe
Sateesh, I think you should modify your code to show the whole stack trace. I'm sure you'll get much better help if you can provide a full stack trace. Best regards, Robert Lowe http://RMLowe.com/ -Original Message- From: Kommineni, Sateesh (GE Consumer & Industrial)

RE: Character encoding

2003-12-19 Thread Robert Lowe
You need to set UTF-16 encoding for each cell, like this: HSSFCell cell = ...; cell.setEncoding(HSSFCell.ENCODING_UTF_16); Best regards, Robert Lowe http://RMLowe.com/ -Original Message- From: T " <[EMAIL PROTECTED]> [mailto:T " <[EMAIL PROTECTED]>]

RE: OutOfMemoryError at large Excel Sheets

2003-11-17 Thread Robert Lowe
Jan, I aked basically the same question a few weeks ago: http://www.mail-archive.com/[EMAIL PROTECTED]/msg03092.html The short answer seems to be "no", because of the way records are cross-referenced in an Excel file. Best regards, Robert Lowe http://RMLowe.com/ -Origin

RE: multiple workbooks in internet explorer

2003-10-30 Thread Robert Lowe
Markus, do you mean multiple workbooks or multiple sheets? You can create multiple sheets, although I can't tell you how. Best regards, Robert Lowe http://RMLowe.com/ -Original Message- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 4:25 PM To

RE: RE: RE: Event-based API for generating Excel files?

2003-10-28 Thread Robert Lowe
r me--I want to stream directly across a network... Best regards, Robert Lowe http://RMLowe.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: RE: Event-based API for generating Excel files?

2003-10-28 Thread Robert Lowe
am; - repeat for the next row & etc. The catch, I guess, is knowing which records to put in which order. Guess I'd need to get a copy of "Microsoft Excel 97 Developer's Kit" and brush up on the Excel file format. Best regards, Robert Lowe http://RMLowe.com/

RE: russian characters

2003-10-28 Thread Robert Lowe
cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(myStringContainingRussianCharacters); Best regards, Robert Lowe http://RMLowe.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additiona

RE: Event-based API for generating Excel files?

2003-10-27 Thread Robert Lowe
> When you look through CVS, you get the Development Head by default :). Yes I understand that. What I can't figure out is which packages/classes/methods I should be looking at. Best regards, Robert Lowe http://RM

RE: Event-based API for generating Excel files?

2003-10-25 Thread Robert Lowe
I for generating Excel files? Have you checked out the HEAD? Andy put out the performance branch there that reduces memory usage as well increasing performance. It's a little broken right now but if it works for you... Cocoon uses the usermodel at the end of the day :) danny Robert

Event-based API for generating Excel files?

2003-10-24 Thread Robert Lowe
ng an event-based API, and hence avoid buffering the entire document in memory? I know there's an event-based API for reading docs, but haven't come across anyhting similar for writing. Should I be looking at Cocoon? Best regards, Robert Lowe ht

RE: HSSF 2.0 Pre3 - Large File Output, Excel reports extensive damage and loses formatting

2003-10-24 Thread Robert Lowe
Matt, You might be running up against this: http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15375 Best regards, Robert Lowe http://RMLowe.com/ -Original Message- From: Cupp, Matthew R [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 5:03 AM To: '[EMAIL PROT

RE: help:about excel cell's style?

2003-10-24 Thread Robert Lowe
At the very least, you must be able to put Java class files on the server, right? So you could put an Excel file in the classpath and load it using the Class.getResourceAsStream method. Best regards, Robert Lowe http://RMLowe.com/ -Original Message- From: yzy [mailto:[EMAIL

RE: How to create MS-Excel which contain Japanese strings encodedin Shift JIS encoding.

2003-10-22 Thread Robert Lowe
I have successfully used POI to generate Excel spreadsheets containing Japanese text. As Avik says, all I had to do was: cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(myData); Best regards, Robert Lowe http://RMLowe.com/ -Original Message- From: Avik Sengupta

RE: Setting foreground colors to cells individually failed

2003-10-12 Thread Robert Lowe
You are using the same HSSFCellStyle object for each cell--you need to create a different one for each cell: for (int i=0; ihttp://RMLowe.com/ -Original Message- From: Sergei P. Volin [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 1:37 AM To: 'POI Users List' Subject:

RE: Excel cannot open HSSF file with 30,000 rows generated by POI 2.0 pre-release 3

2003-10-10 Thread Robert Lowe
more than 32767 rows? >From: "Robert Lowe" <[EMAIL PROTECTED]> >Reply-To: "POI Users List" <[EMAIL PROTECTED]> >To: "POI Users List" <[EMAIL PROTECTED]> >Subject: RE: Excel cannot open HSSF file with 30,000 rows generated by POI >

RE: Recommended version

2003-10-09 Thread Robert Lowe
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15375 -Original Message- From: news [mailto:[EMAIL PROTECTED] Behalf Of Morten Sent: Thursday, October 09, 2003 8:52 PM To: [EMAIL PROTECTED] Subject: Recommended version Hi, Are there any reasons at all to use 1.5.1 rather than 2.0-pre

RE: Re: HSSF Workbook not opening in MS Excel

2003-10-08 Thread Robert Lowe
MS Excel > Sent: 07 Oct 2003 20:04:28 > > Guys, > > Robert Lowe and I were having the same problem. As Robert confirms below, > we narrowed it down to this: In certain cases (which are described below), > calling the overloaded String ve

RE: Excel cannot open HSSF file with 30,000 rows generated by POI 2.0 pre-release 3

2003-10-08 Thread Robert Lowe
Excel cannot open HSSF file with 30,000 rows generated by POI 2.0 pre-release 3 It's best for you to attach this to bugzilla so we dont lose track. http://nagoya.apache.org/bugzilla/buglist.cgi?product=POI Thanks for the test case, that will assist us in fixing your problem immensely. danny R

RE: Excel cannot open HSSF file with 30,000 rows generated by POI 2.0 pre-release 3

2003-10-03 Thread Robert Lowe
} finally { out.close(); } } } -Original Message- From: Robert Lowe [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 9:47 PM To: [EMAIL PROTECTED] Subject:

Excel cannot open HSSF file with 30,000 rows generated by POI 2.0 pre-release 3

2003-10-03 Thread Robert Lowe
ed, but I don't want to send it to the list as it's about 1.3 MB.) This problem does not occur on the latest stable release version, 1.5.1. Any workarounds would be greatly appreciated! (I can't go back to 1.5.1 because I need the cloneSheet() method... :-( ) Best regards,

RE: How to set different types of fomat and style to different cell

2003-10-01 Thread Robert Lowe
A cellstyle can be "shared" by many cells in a workbook. Currently you are modifying the "shared" cellstyle, and this affects all cells that use that style. Instead, try to create a new style using HSSFWorkbook.createCellStyle(), and then use cell.setCellStyle(HSSFCellStyle). In other words, repl