Apache POI —— HSSF / XSSF（1）

新建工作薄（NewWorkbook）

 

Workbook wb =new HSSFWorkbook();

FileOutputStream fileOut =new FileOutputStream("workbook.xls");

wb.write(fileOut);

fileOut.close();

 

Workbook wb =new XSSFWorkbook();

FileOutputStream fileOut =new FileOutputStream("workbook.xlsx");

wb.write(fileOut);

fileOut.close();

 

新建工作表（New Sheet）

Workbook wb =new HSSFWorkbook();// or new XSSFWorkbook();

Sheet sheet1 = wb.createSheet("new sheet");

Sheet sheet2 = wb.createSheet("second sheet");

//请注意，Excel工作表名称不得超过31个字符

//且不能包含任何如下字符：

// 0x0000

// 0x0003

//冒号colon (:)

//反斜杠backslash (\)

//星号asterisk (*)

//问号question mark (?)

//斜杠forward slash (/)

//打开方括号opening square bracket ([)

//关闭方括号closing square bracket (])

 

//可以使用org.apache.poi.ss.util.WorkbookUtil#createSafeSheetName(String nameProposal)}

//一个安全的方式用来创建工作表名,它将用空格（''）替换无效字符

String safeName = WorkbookUtil.createSafeSheetName("[O'Brien's sales*?]"); // returns " O'Brien's sales  "

Sheet sheet3 = wb.createSheet(safeName);

 

FileOutputStream fileOut =new FileOutputStream("workbook.xls");

wb.write(fileOut);

fileOut.close();

 

 

创建列（Creating Cells）

Workbook wb =new HSSFWorkbook();

// Workbook wb = new XSSFWorkbook();

CreationHelper createHelper = wb.getCreationHelper();

Sheet sheet = wb.createSheet("new sheet");

 

//创建一行,行号从0开始

Row row = sheet.createRow(0);

//创建一列并设置值

Cell cell = row.createCell(0);

cell.setCellValue(1);

 

//或使用一行完成

row.createCell(1).setCellValue(1.2);

row.createCell(2).setCellValue(createHelper.createRichTextString("This is a string"));

row.createCell(3).setCellValue(true);

 

//输出到一个文件

FileOutputStream fileOut =new FileOutputStream("workbook.xls");

wb.write(fileOut);

fileOut.close();

创建列数据（CreatingDate Cells）

Workbook wb =new HSSFWorkbook();

// Workbook wb = new XSSFWorkbook();

CreationHelper createHelper = wb.getCreationHelper();

Sheet sheet = wb.createSheet("new sheet");

 

//创建一行

Row row = sheet.createRow(0);

 

//创建一列并设置一个日期值,这一个列是没有样式的

Cell cell = row.createCell(0);

cell.setCellValue(new Date());

 

//为第二列指定列样式 

CellStyle cellStyle = wb.createCellStyle();

cellStyle.setDataFormat(createHelper.createDataFormat().getFormat("m/d/yy h:mm"));

cell = row.createCell(1);

cell.setCellValue(new Date());

cell.setCellStyle(cellStyle);

 

//还可以使用java.util.Calendar设置日期

cell = row.createCell(2);

cell.setCellValue(Calendar.getInstance());

cell.setCellStyle(cellStyle);

 

//输出到文件

FileOutputStream fileOut =new FileOutputStream("workbook.xls");

wb.write(fileOut);

fileOut.close();