自用

package com.his.tree.excel;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import java.io.FileWriter;import java.io.IOException;import java.io.PrintWriter;/** * Created by IntelliJ IDEA. * User: Swing * Date: 11-11-15 * Time: 下午9:45 * To change this template use File | Settings | File Templates. */public class Test { public static void main(String[] args) { String file = "D:/tstt.xlsx"; Test test = new Test(); test.readExcel(file); } public void readExcel(String path) { XSSFSheet xssfSheet = null; try { XSSFWorkbook hssfWorkbook = new XSSFWorkbook(path); xssfSheet = hssfWorkbook.getSheetAt(0); } catch (IOException e) { } XSSFRow row; String cell = null; // 循环输出表格中的内容 FileWriter fw = null; PrintWriter pw = null; for (int i = xssfSheet.getFirstRowNum(); i < xssfSheet.getPhysicalNumberOfRows(); i++) { row = xssfSheet.getRow(i); System.out.println(row); cell = "insert into " ; for (int j = row.getFirstCellNum(); j < row.getPhysicalNumberOfCells(); j++) { // 通过 row.getCell(j).toString() 获取单元格内容， cell += row.getCell(j) + " "; } cell.concat("\n"); try { fw = new FileWriter("C:\\Log.txt", true); } catch (IOException e) { } pw = new PrintWriter(fw); pw.println(cell); pw.flush(); } try { fw.close(); pw.close(); } catch (IOException e) { } }}

 

所需jar 包 ：poi-3.6

 

poi-3.6-20091214.jar

poi-contrib-3.6-20091214.jar

poi-scratch.6-20091214.jar

geronimo-stax-api_1.0_spec-1.0.jar

xmlbeans-2.3.0.jar