poi实现java编写excel文件和读取excel文件内容学习：
package com.sky.itext; import java.io.FileInputStream; 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 FirstExcel{ public static String xlsFile = "E:/study/firstExcel.xls"; public static void main(String[] args){ //内容写入EXCEL中 HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet(); workbook.setSheetName(0, "firstSheet"); HSSFRow rows = sheet.createRow(0); HSSFCell cell = rows.createCell(0); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue("牧牛遛马"); try { FileOutputStream fos = new FileOutputStream(xlsFile); workbook.write(fos); fos.flush(); fos.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } //读取Excel文件内容 try { FileInputStream fis = new FileInputStream(xlsFile); HSSFWorkbook readWorkbook = new HSSFWorkbook(fis); HSSFSheet readSheet = readWorkbook.getSheetAt(0); HSSFRow readRow = readSheet.getRow(0); HSSFCell readCell = readRow.getCell(0); System.out.println("第一个单元格的内容是"+readCell.getStringCellValue()); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }