要导入一个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();
}
}}