创建sheet
HSSFSheet sheet = workbook.createSheet("测试名称");
设置sheet名称
workbook.setSheetName(0, "testname");
设置单元格内容
cell.setCellValue("单元格内容");
获取sheet数目
workbook.getNumberOfSheets()
根据index取得sheet对象
HSSFSheet sheet = wb.getSheetAt(0);
取得有效行数
int rowCount = sheet.getLastRowNum();
设置单元格格式
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
读取数值类型的单元格内容
cell.getNumericCellValue();
设置列宽、行高
sheet.setColumnWidth((short)column,(short)width);
row.setHeight((short)height);
添加区域,合并单元格
CellRangeAddress cellRangeAddress = new CellRangeAddress(0, 0, 0, 3);
sheet.addMergedRegion(cellRangeAddress);
HSSFRow mergedRow = sheet.createRow(0);
HSSFCell mergedCell = mergedRow.createCell(0);
mergedCell.setCellValue("表格标题行");