关于POI，怎么实现行颜色不同
我想用POI生成一个EXCEL表，但是要求每个Sheet里每一行的行颜色不一样。
请问怎么实现
[解决办法]
用HSSFCellStyle
[解决办法]
cell.setCellStyle(new CellStyle() {
public void setWrapText(boolean arg0) {
// TODO Auto-generated method stub
}
public void setVerticalAlignment(short arg0) {
// TODO Auto-generated method stub
}
public void setTopBorderColor(short arg0) {
// TODO Auto-generated method stub
}
public void setRotation(short arg0) {
// TODO Auto-generated method stub
}
public void setRightBorderColor(short arg0) {
// TODO Auto-generated method stub
}
public void setLocked(boolean arg0) {
// TODO Auto-generated method stub
}
public void setLeftBorderColor(short arg0) {
// TODO Auto-generated method stub
}
public void setIndention(short arg0) {
// TODO Auto-generated method stub
}
public void setHidden(boolean arg0) {
// TODO Auto-generated method stub
}
public void setFont(Font arg0) {
// TODO Auto-generated method stub
}
public void setFillPattern(short arg0) {
// TODO Auto-generated method stub
}
public void setFillForegroundColor(short arg0) {
// TODO Auto-generated method stub
}
public void setFillBackgroundColor(short arg0) {
// TODO Auto-generated method stub
}
public void setDataFormat(short arg0) {
// TODO Auto-generated method stub
}
public void setBottomBorderColor(short arg0) {
// TODO Auto-generated method stub
}
public void setBorderTop(short arg0) {
// TODO Auto-generated method stub
}
public void setBorderRight(short arg0) {
// TODO Auto-generated method stub
}
public void setBorderLeft(short arg0) {
// TODO Auto-generated method stub
}
public void setBorderBottom(short arg0) {
// TODO Auto-generated method stub
}
public void setAlignment(short arg0) {
// TODO Auto-generated method stub
}
public boolean getWrapText() {
// TODO Auto-generated method stub
return false;
}
public short getVerticalAlignment() {
// TODO Auto-generated method stub
return 0;
}
public short getTopBorderColor() {
// TODO Auto-generated method stub
return 0;
}
public short getRotation() {
// TODO Auto-generated method stub
return 0;
}
public short getRightBorderColor() {
// TODO Auto-generated method stub
return 0;
}
public boolean getLocked() {
// TODO Auto-generated method stub
return false;
}
public short getLeftBorderColor() {
// TODO Auto-generated method stub
return 0;
}
public short getIndex() {
// TODO Auto-generated method stub
return 0;
}
public short getIndention() {
// TODO Auto-generated method stub
return 0;
}
public boolean getHidden() {
// TODO Auto-generated method stub
return false;
}
public short getFontIndex() {
// TODO Auto-generated method stub
return 0;
}
public short getFillPattern() {
// TODO Auto-generated method stub
return 0;
}
public Color getFillForegroundColorColor() {
// TODO Auto-generated method stub
return null;
}
public short getFillForegroundColor() {
// TODO Auto-generated method stub
return 0;
}
public Color getFillBackgroundColorColor() {
// TODO Auto-generated method stub
return null;
}
public short getFillBackgroundColor() {
// TODO Auto-generated method stub
return 0;
}
public String getDataFormatString() {
// TODO Auto-generated method stub
return null;
}
public short getDataFormat() {
// TODO Auto-generated method stub
return 0;
}
public short getBottomBorderColor() {
// TODO Auto-generated method stub
return 0;
}
public short getBorderTop() {
// TODO Auto-generated method stub
return 0;
}
public short getBorderRight() {
// TODO Auto-generated method stub
return 0;
}
public short getBorderLeft() {
// TODO Auto-generated method stub
return 0;
}
public short getBorderBottom() {
// TODO Auto-generated method stub
return 0;
}
public short getAlignment() {
// TODO Auto-generated method stub
return 0;
}
public void cloneStyleFrom(CellStyle arg0) {
// TODO Auto-generated method stub
}
});
