With this fix, POI can support Japanese

Hi, Andy and POI contributors, Although using POI I can read Japanese spreadsheets, I wasn't able to write them. Since it would be great that a great library -- POI -- can be greater :) and supporting Japanese is critical to our product :( our architect looked into HSSF codes and added some codes

Re: Does POI support updating the XLS file which has macro?

Not currently. It would be simple to add. You just need to modify HSSF to maintain other "files" in the underlying OLE 2 Compound Document (POIFS) file. For example, HSSF primarily concerns itself with the "Workbook" "file" in the OLE2CDF file. (Think of an XLS as an archive). I plan to wor

Does POI support updating the XLS file which has macro?

Hi, I want to update the excel file which has macros on it( update only worksheets ). Does current version of POI support this kind of operation on xls file? -Sathiyan -- To unsubscribe, e-mail: For additional commands, e-mail:

Re: Anyone have performance problems?

Okay, lets start from the top: 1. Do you have logging on -- POI's logging facillities are intended only for autopsies? 2. What is your VM memory set at? 3. Are you sure you're not running in swap memory? For reference, I ran: http://jakarta.apache.org/poi/javadocs/javasrc/org/apache/poi/hssf/d

Re: Anyone successful in writing XLS file on WAS3.5.3?

Check these: 1. How big is the file (in bytes)? -- how big is whatever is in the inputstream? 2. Try using a buffer input stream If you're using "getRealPath" anywhere, do note that its behavior cannot be depended upon! Torbert Brian IT56 wrote: >Im not sure if this will help in tracking do

RE: Anyone have performance problems?

Thats how I started out. I began drilling in with more timers to see where the trouble areas were. I have found some rather strange results in my tests this morning. They are totally inconsistent. I will run the same export over and over and get different results each time. It speeds

RE: Anyone have performance problems?

Something else to try is to time how long the whole loop runs instead of each iteration. This way the timing code makes less of an impact. You can then take the time for the whole loop and divide it by the iterations to get the time for each iteration. Shawn Laubach SAIC - Web Developer B-1B Sy

RE: Anyone have performance problems?

Thanks. Yes that definitly needs to be out of there. It did not change my performance results however but was bad coding practice none the less. Appreciate you looking at it. -Original Message- From: Jeff Fisher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 9:52 AM To: 'POI Us

Re: Formulas with 'IF' or cross worksheet formulas

Logical operators and formulas are not supported yet. Check the formula docs on the poi site (under hssf) Sheet reference support is not there in 1.7.0, since we wanted to get a milestone release before starting the next round of experiments. It has just been checked in today. Writing sheet f

Re: Formulas with 'IF' or cross worksheet formulas

Logical operators and formulas are not supported yet. Check the formula docs on the poi site (under hssf) Sheet reference support is not there in 1.7.0, since we wanted to get a milestone release before starting the next round of experiments. It has just been checked in today. Writing sheet f

RE: Anyone have performance problems?

Not sure if this will make a difference but I would pull this line out of the for loop: String[] s = table.getColumnHeaderCodes(); There is no point re-assigning this every loop iteration. If for some reason the array is actually being coppied, then that's expensive. -Original Message

RE: Anyone have performance problems?

int nextCellNumber = 0; // Create first row and put some cells in it. Rows are 0 based. HSSFRow row = sheet.createRow((short)0); //Display the header columns for (int i=0; i I am using poi 1.5.0 and running the code on a Pentium 3 500mhz w512mb RAM. This is just a testing server our product

Formulas with 'IF' or cross worksheet formulas

I tried using the HSSFCell method 'setCellFormula' on POI dev version 1.6.0 and 1.7.0 where my formula contained an 'IF' statement and also where the formula contained a reference to a cell in another worksheet and it failed. Is there a different way to achieve this, or is it just not supported ye