使用POI组件操作Excel文档

由于使用的是第三方组件所以需要引用jar包：

实现文件的写入：

import java.io.FileOutputStream;import java.io.IOException;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 WriteExcel {    public static void main(String[] args) throws Exception {        WriteExcel w = new WriteExcel();        w.writeExcel("1.xlsx");    }    public void writeExcel(String filename)throws IOException{        //创建一个新的Excel工作簿        HSSFWorkbook workbook = new HSSFWorkbook();        //在Excel表中新建一个工作表起名为java        HSSFSheet sheet = workbook.createSheet("java");        //创建第一行        HSSFRow row = sheet.createRow(0);        //创建第一列        HSSFCell cell = row.createCell((short)0);        //定义单元格为字符串类型        cell.setCellType(HSSFCell.CELL_TYPE_STRING);        //在单元格中输入内容        cell.setCellValue("作者");        //创建第二列        cell = row.createCell((short)1);        //定义单元格为字符串类型        cell.setCellType(HSSFCell.CELL_TYPE_STRING);        //在单元格中输入内容        cell.setCellValue("编辑");        //新建输出流        FileOutputStream fos = new FileOutputStream(filename);        //保存        workbook.write(fos);        //刷新        fos.flush();        //结束关闭        fos.close();    }}

实现文件的读出：

import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;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 ReadExcel {    public static void main(String[] args) throws Exception {        ReadExcel r = new ReadExcel();        r.readExcel("1.xlsx");    }    public void readExcel(String fileName) throws FileNotFoundException, IOException{        HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileName));        //按照名字引用Excel表        HSSFSheet sheet = workbook.getSheet("java");        //也可以用以下方法获取Excel工作表，采用工作表的索引值        //HSSFSheet sheet = workbook.getSheetAt(0);        HSSFRow row = sheet.getRow(0);        HSSFCell cell = row.getCell((short)0);        //打印读取值        System.out.println(cell.getStringCellValue());        cell = row.getCell((short)1);        System.out.println(cell.getStringCellValue());    }}

实验结果：