Excel读写

要导入一个HSSF包


import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;import java.io.FileInputStream;
import java.io.FileOutputStream;
public class TestReadAndWriteExcel {
public static void main(String[] args) {
  try{
   //写Excel
   FileOutputStream output =new FileOutputStream("e:\\testExcel.xls");//写文件流
   HSSFWorkbook workbook = new HSSFWorkbook();//WORKBOOK 相当于Excel对象
      HSSFSheet sheet = workbook.createSheet();//创建页对象
      workbook.setSheetName(0,"sheet1");//注意：是workbook设置sheet的名称
      HSSFRow row = sheet.createRow(0);//创建行
      HSSFCell cell = row.createCell((short) 0);//创建单元格
      cell.setCellValue("第一个单元格");//为单元格填写内容
      workbook.write(output);//用流读到文件中去
      output.close();//关闭流
      
      //读Excel
      POIFSFileSystem fs = null;//读取Excel文件时，首先生存一个POIFSFileSystem对象，由POI                                                  // FSFileSystem对象构造一个HSSFWorkbook
      HSSFWorkbook wb = null;
      
      fs = new POIFSFileSystem(new FileInputStream("e:\\testExcel.xls"));//读文件的流
      wb = new HSSFWorkbook(fs);//创建workbook
      HSSFSheet sheet1 = wb.getSheetAt(0);//获取页
      HSSFRow row1 = sheet1.getRow(0);//获取行
      HSSFCell cell1 = row1.getCell((short)0);//获取单元格
      System.out.println(cell1.getStringCellValue());//获取单元格中的内容
      
  }catch(Exception ex){
   ex.printStackTrace();
  }
}}