/** * 获取或创建某一行的样式,返回样式后可以设置样式内容 * * @param y Y坐标,从0计数,既行号 * @return {@link CellStyle} * @since 4.1.4 */ public CellStyle getOrCreateRowStyle(int y) { final Row row = getOrCreateRow(y); CellStyle rowStyle = row.getRowStyle(); if (null == rowStyle) { rowStyle = this.workbook.createCellStyle(); row.setRowStyle(rowStyle); } return rowStyle; }
/** * 获取或创建某一行的样式,返回样式后可以设置样式内容 * * @param y Y坐标,从0计数,既行号 * @return {@link CellStyle} * @since 4.1.4 */ public CellStyle getOrCreateRowStyle(int y) { final Row row = getOrCreateRow(y); CellStyle rowStyle = row.getRowStyle(); if (null == rowStyle) { rowStyle = this.workbook.createCellStyle(); row.setRowStyle(rowStyle); } return rowStyle; }
headerRow.setRowStyle(headerSyle);
row.setRowStyle(newStyle);
while (rows.hasNext()){ Row row1 = rows.next (); row1.setRowStyle(hiddenstyle); }
HSSFWorkbook wb=new HSSFWorkbook(); Row headerRow =sheet.createRow(1); headerRow.setRowStyle(getCellStyleForColor(wb,new Color(20,20,20)); .....
CreationHelper createHelper = wb.getCreationHelper(); Sheet sheet = wb.createSheet("new sheet"); Row r = sheet.createRow(0); r.setRowStyle(rowStyle); Cell c1 = r.createCell(0); c1.setCellValue("Test 1"); c1.setCellStyle(rowStyle);
/** * 获取或创建某一行的样式,返回样式后可以设置样式内容 * * @param y Y坐标,从0计数,既行号 * @return {@link CellStyle} * @since 4.1.4 */ public CellStyle getOrCreateRowStyle(int y) { final Row row = getOrCreateRow(y); CellStyle rowStyle = row.getRowStyle(); if (null == rowStyle) { rowStyle = this.workbook.createCellStyle(); row.setRowStyle(rowStyle); } return rowStyle; }
public static void main(String[] args) throws JDOMException, IOException { File excelFile = new File("C:/temp/test.xls"); HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("sheetname"); Row r = null; CellStyle cellStyle = workbook.createCellStyle(); // CreationHelper createHelper = workbook.getCreationHelper(); cellStyle.setDataFormat(workbook.createDataFormat().getFormat("yyyy-MM-dd")); for (int i = 0; i < 2; i++) { switch (i) { case 0: r = sheet.createRow(0); r.setRowStyle(cellStyle); break; case 1: r = sheet.createRow(1); r.setRowStyle(cellStyle); break; default: break; } } try (FileOutputStream out = new FileOutputStream(excelFile)) { workbook.write(out); } Desktop.getDesktop().open(excelFile); }
target.setRowStyle(src.getRowStyle());
style.setShrinkToFit(true); style.setWrapText(true); newRow.setRowStyle(style);
CellStyle cellStyle = sm.getStyle(style); if (cellStyle != null){ row.setRowStyle(cellStyle);
row.setHeight(templateRow.getHeight()); row.setHeightInPoints(templateRow.getHeightInPoints()); row.setRowStyle(templateRow.getRowStyle()); row.setZeroHeight(templateRow.isZeroHeight());