Apache POI
adware2008
这个作者很懒,什么都没留下…
展开
-
POI 创建单元格 并给值
Workbook wb = new HSSFWorkbook()//.xls //Workbook wb = new XSSFWorkbook();//.xlsx CreationHelper createHelper = wb.getCreationHelper(); Sheet sheet = wb.createSheet("new sheet");原创 2010-01-13 16:59:00 · 971 阅读 · 0 评论 -
POI 迭代单元格
使用迭代器 迭代单元格值 Sheet sheet = wb.getSheetAt(0);//获取第一个表单 for (Iterator rit = sheet.rowIterator(); rit.hasNext(); ) {//使用 Iterator 迭代器进行迭代 Row row = (Row)rit.next();//迭代到行记录原创 2010-01-13 17:08:00 · 894 阅读 · 0 评论 -
创建一个工作表
Workbook wb = new HSSFWorkbook();//97-2000 可以使用 FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut); fileOut.close(); Workbook wb = new XSSFW原创 2010-01-13 16:50:00 · 233 阅读 · 0 评论 -
POI 获取单元格 内容
Sheet sheet1 = wb.getSheetAt(0);for (Row row : sheet1) { for (Cell cell : row) { CellReference cellRef = new CellReference(row.getRowNum(), cell.getCellNum()); System.out.print(cellRef.forma原创 2010-01-13 17:15:00 · 1315 阅读 · 0 评论 -
POI 创建一个 Sheet 表单
Workbook wb = new HSSFWorkbook(); //Workbook wb = new XSSFWorkbook(); Sheet sheet1 = wb.createSheet("new sheet"); Sheet sheet2 = wb.createSheet("second sheet");原创 2010-01-13 16:58:00 · 638 阅读 · 0 评论 -
POI 创建日期格式单元格
Workbook wb = new HSSFWorkbook();xxx.xls 文件可用此操作 //Workbook wb = new XSSFWorkbook();xxx.xlsx 文件需要用到 xssfworkbook CreationHelper createHelper = wb.getCreationHelper(); Sheet sheet = wb.c原创 2010-01-13 17:03:00 · 1066 阅读 · 0 评论