Re: help:about excel cell's style?

Use this: HSSFCellStyle.setFillPattern(short fp); and consider the following constants for fp's value: HSSFCellStyle.THICK_BACKWARD_DIAG HSSFCellStyle.THICK_FORWARD_DIAG HSSFCellStyle.THIN_BACKWARD_DIAG HSSFCellStyle.THIN_FORWARD_DIAG Let me know if it works, Rgrds, Xuemin Guan yinzhiyuan wr

help:about excel cell's style?

Help, help,help please! Who can tell me how to set excel cell border style. POI has provided "setBorderBottom(),setBorderTop(),setBorderLeft(),setBorderRight()", but what I need is set "Diagonal Down" and "Diagonal Up" in a cell. Pls tell me how to resovel it. Thank you very much!!

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

Hello, I am using POI 2.0 Pre3 and the associated contrib file. In my Java application I create a report file from data that was just loaded into the system. I get the results of two SQL queries and I output them to the separate sheets. The first sheet has just a couple of fields and displays s

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

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: How to create MS-Excel which contain Japanese strings encoded in Shift JIS encoding.

I suspect that it would be related to just the default encodings of Solaris (EUC_JP). Have you ever experienced such a transformation? (EUC_JP => Shift_JIS / vice versa) I suspect that it is not related to POI itself. (Not sure. I do not have Solaris environment) Make sure the CodePage, also. -

Re: Excel Crashes

Yeah sure, I appreciate the data could be confidential. The problem is, its quite impossible to debug a situation like this unless both the code and data are available .. so all we can do is provide pointers... In many such bugs have been fixed recently, but its of course impossible to prove th

Re: question about single cell named ranges

This might be a bug.. i'll check. On Tue, 2003-10-21 at 01:46, Michael Hollander wrote: > hi -- > > i would like to create name in the spreadsheet that only spans a single cell, such > as Sheet0!$A$1. > > String sheetName = "Sheet0"; > HSSFName name = book.createName(); >

Re: How to create MS-Excel which contain Japanese strings encoded in Shift JIS encoding.

Some general thoughts on your requirements 1. People do use POI to read and write sheets with Japanese/Chinese/Korean/Russian... etc characters in them ... you'll find that if you search the mailing list. 2. In the same vein, many bugs have been reported in the use of POI with multibyte characte

Re: Excel pictures & text boxes

I tend to say that a lot too :) Can you pop that into bugzilla (if not already there) as an enhancement request so if somebody feels inspired they'll do it? Will Glass-Husain wrote: Thanks, We'll see how important this capability is. For the records (and the archives) I checked a few commerci

How to create MS-Excel which contain Japanese strings encoded in Shift JIS encoding.

    Hi All,   We are planning to use POI for creating an XLS file from a J2EE based application.   The application server is WebLogic 8.1, OS is Solaris 8.   However, the XLS to be created will contain Japanese strings encoded in Shift JIS encoding.   After checking the POI API, w

Re: Excel pictures & text boxes

Thanks, We'll see how important this capability is. For the records (and the archives) I checked a few commercial tools. ExtenXLS does not support this. Formula One e.Spreadsheet does. Not sure if this is worth the license fees to my client; I'd rather stick with POI. WILL - Original Mes

Mail

Hi , I just want to confirm whether i have been added to poi mail lists. so that i can ask queries related to that regards Mudit Gupta Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com B