I am sorry to tell you that it does not work. The method just fill the background with 
diagnal line.
thank you so!
yzy
----- Original Message ----- 
From: "Xuemin Guan" <[EMAIL PROTECTED]>
To: "POI Users List" <[EMAIL PROTECTED]>
Sent: Thursday, October 23, 2003 3:00 PM
Subject: 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 wrote:
> >    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!!
> > 
> >    
> > 
> >   
> > 我现在需要设置execl单元格的输出格式,在poi里面已经提供了设置上下左右四个边的格式,但是我还需要设置斜线,如何处理。谢谢大家。
> > 
> > [EMAIL PROTECTED]
> >  
> > 
> > 
> > ------------------------------------------------------------------------
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 

Reply via email to