读书人

关于POI如何实现行颜色不同

发布时间: 2013-06-19 10:26:41 作者: rapoo

关于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

}
});

读书人网 >Java相关

热点推荐