1
2
3
4
5
6
7
8
9
10

//取得row0 和CellStyle
HSSFRow r0 = sheet1.getRow(0);
HSSFCell c1 = r0.getCell((short)0);
HSSFCellStyle style = c1.getCellStyle();  
 
//新增row 設定CellStyle
HSSFRow newRow = sheet1.createRow(rownum);
HSSFCell newCell = newRow.createCell((short)0);
newCell.setCellStyle(style); 
newCell.setCellValue("test");

1

sheet1.setColumnBreak((short)1);//錯誤行