POI3.9操作Excel (一)

来源：互联网发布：编程学校多少钱编辑：程序博客网时间：2024/06/18 18:24

从http://poi.apache.org/download.html网符合下载jar，环境配置省略

说明：

鉴于Excel版本2003，2007，2010的后缀名不一样，POI提供的两种方式，首先理解几个概念：

1. WORKBOOK

2. SHEET

3. ROW

4. CELL

不解释了，直接开始

入门示例

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();}}

待续....