随笔分类 - POI
摘要：WorkBook workbook = new WorkBook(); Sheet sheet = workbook.creatSheet("sheet1"); String[] types = {"1","2","3"} //设置行列范围(资源类型) CellRangeAddressList ad
阅读全文
摘要：pom.xml依赖 <!--poi文档处理--> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.17</version> </dependency> <dependency
阅读全文
摘要：org.apache.poi 读excel空列跳过的问题 用org.apache.poi的包做excel导入，无意间发现如果excel文件中有空列，空列后面的数据全部读不到。查来查去原来是HSSFRow提供两个方法：getPhysicalNumberOfCells和getLastCellNum。ge
阅读全文
摘要：07版读取数据 public readExecl() { //输入流 path:文件地址 InputStream is = new FileInputStream(path); //创建工作簿 WorkBook workBook = new WorkBook(is); //得到工作表1 Sheet
阅读全文
