Apache POI HSSF and XSSF 快速指南 帮助文档 API poi-3.15

Apache POI HSSF and XSSF 快速指南帮助文档 API poi-3.15

目录

1、如何创建一个新的Workbook ................................................................................................... 3 2、如何创建一个表 ......................................................................................................................... 3 3、如何创建单元格 ......................................................................................................................... 3 4、如何创建日期单元格 ................................................................................................................. 4 5、使用不同类型的单元格 ............................................................................................................. 5 6、在行和单元格上的迭代 ............................................................................................................. 5 7、获取单元格内容 ......................................................................................................................... 6 8、文本提取..................................................................................................................................... 7 9、文件与InputStreams .................................................................................................................. 7 10、对齐单元格............................................................................................................................... 8 11、使用边界................................................................................................................................... 9 12、填充和颜色............................................................................................................................. 10 13、合并单元格............................................................................................................................. 11 14、使用字体................................................................................................................................. 11 15、自定义颜色............................................................................................................................. 13 16、读写 ........................................................................................................................................ 14 17、在单元格中使用换行符。 ..................................................................................................... 15 18、创建用户定义的数据格式 ..................................................................................................... 15 19、将单页调整为一页 ................................................................................................................. 16 20、设置工作表的打印区域 ......................................................................................................... 16 21、在工作表的页脚上设置页码 ................................................................................................. 17 22、移动行 .................................................................................................................................... 17 23、将工作表设置为选定 ............................................................................................................. 17 24、设置工作页的缩放倍率 ......................................................................................................... 18 25、创建拆分和冻结窗格 ............................................................................................................. 18 26、重复行和列............................................................................................................................. 19 27、页眉和页脚............................................................................................................................. 19 28、绘图形状................................................................................................................................. 20 29、造型形状................................................................................................................................. 21 30、形状和Graphics2d ................................................................................................................. 22 31、大纲 ........................................................................................................................................ 23 32、图片 ........................................................................................................................................ 23 33、命名范围和命名单元格 ......................................................................................................... 25 34、如何设置单元格注释 ............................................................................................................. 27 35、如何调整列宽以适合内容 ..................................................................................................... 28 36、超链接 .................................................................................................................................... 29 37、数据验证................................................................................................................................. 31 38、嵌入对象................................................................................................................................. 38 39、自动过滤器............................................................................................................................. 40

40、条件格式................................................................................................................................. 40 41、隐藏和取消隐藏行 ................................................................................................................. 41 42、设置单元格属性 ..................................................................................................................... 42 43、绘图边框................................................................................................................................. 43 44、创建数据透视表 ..................................................................................................................... 44 45、具有多种样式的单元格(富文本字符串) .............................................................................. 45 46、使用方便的函数 ..................................................................................................................... 46

Apache POI HSSF and XSSF 快速指南帮助文档 API poi-3.15

参考版本为:poi-3.15 代码测试所用软件:NetBeans IDE8.2 希望对大家有所帮助 提示:测试代码需要导入poi的全部以jar结尾的文件,导入到库中

2016/10/18 Tuesday

1、如何创建一个新的Workbook

Workbook wb = new HSSFWorkbook();

FileOutputStream fileOut = new FileOutputStream(\ wb.write(fileOut); fileOut.close();

Workbook wb = new XSSFWorkbook();

FileOutputStream fileOut = new FileOutputStream(\ wb.write(fileOut); fileOut.close();

2、如何创建一个表

Workbook wb = new HSSFWorkbook(); //or new XSSFWorkbook(); Sheet sheet1 = wb.createSheet(\ Sheet sheet2 = wb.createSheet(\ //注意Excel工作表名称不得超过31个字符 //并且不能包含以下任何字符:

//0x0000、0x0003、冒号(:)、反斜杠(\\)、星号(*)、问号(？)、正斜杠(/)、[、]

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

//为了安全地创建有效名称,此实用程序用空格('')替换无效字符

String safeName = WorkbookUtil.createSafeSheetName(\sales*?]\//returns \O'Brien's sales \

Sheet sheet3 = wb.createSheet(safeName);

FileOutputStream fileOut = new FileOutputStream(\ wb.write(fileOut); fileOut.close();

3、如何创建单元格

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

CreationHelper createHelper = wb.getCreationHelper(); Sheet sheet = wb.createSheet(\

//创建一个行并在其中放置一些单元格。行号从0开始。 Row row = sheet.createRow((short)0);

//创建一个单元格并在其中放入一个值。 Cell cell = row.createCell(0); cell.setCellValue(1);

//或在一行上。

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

createHelper.createRichTextString(\ row.createCell(3).setCellValue(true);

//将输出写入文件

FileOutputStream fileOut = new FileOutputStream(\ wb.write(fileOut); fileOut.close();

4、如何创建日期单元格

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

CreationHelper createHelper = wb.getCreationHelper(); Sheet sheet = wb.createSheet(\

//创建一个行并在其中放置一些单元格。行为0 Row row = sheet.createRow(0);

//创建一个单元格并在其中放置一个日期值。第一个单元格没有样式 //作为日期

Cell cell = row.createCell(0); cell.setCellValue(new Date());

//我们将第二个单元格设置为日期(和时间)。重要的是 //从Workbook 创建一个新的单元格样式,否则你可以结束 //修改内置样式,不仅影响这个单元格,而且影响其他单元格。 CellStyle cellStyle = wb.createCellStyle(); cellStyle.setDataFormat(

createHelper.createDataFormat().getFormat(\ cell = row.createCell(1);

cell.setCellValue(new Date()); cell.setCellStyle(cellStyle);