POI3.9操作Excel (一) POI

从http://poi.apache.org/download.html网符合下载jar，环境配置省略
说明：
鉴于Excel版本2003，2007，2010的后缀名不一样，POI提供的两种方式，首先理解几个概念：
1. WORKBOOK
2. SHEET
3. ROW
4. CELL
不解释了，直接开始

【POI3.9操作Excel (一)】入门示例

import java.io.FileOutputStream; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; public class ExcelTest1 { public static void main(String[] args) throws Exception{ HSSFWorkbook wb = new HSSFWorkbook(); FileOutputStream fos = new FileOutputStream("src/hssf/workbook.xls"); HSSFSheet sheet = wb.createSheet("aaa"); HSSFRow row = sheet.createRow(0); HSSFCell cell = row.createCell(0); cell.setCellValue("aaaa"); wb.write(fos); fos.close(); } }

import java.io.FileOutputStream; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; public class ExcelTest2 { public static void main(String[] args) throws Exception { XSSFWorkbook xb = new XSSFWorkbook(); FileOutputStream fos = new FileOutputStream("src/xssf/workbook.xlsx"); XSSFSheet sheet = xb.createSheet("bbb"); XSSFRow row = sheet.createRow(0); XSSFCell cell = row.createCell(0); cell.setCellValue("bbbb"); xb.write(fos); fos.close(); } }

待续....