java 读取excel数据 存入数据库

[qq_25520237]

java 读取excel数据 存入数据库

[qq_19800927]

可以用POI来做

[tacos]

package cn.com.test.poiImport;

import java.io.FileInputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

/**
 * 读取Excel文件 2016-03-09
 */
public class App {

	private POIFSFileSystem fs;
	private Workbook wb;

	public void test() {
		try {
			// 获取文件
			// =========03版本===========================
			fs = new POIFSFileSystem(new FileInputStream("file/oldExcel.xls"));
			wb = new HSSFWorkbook(fs);
			// =========07版本===========================
			// wb = new XSSFWorkbook(new FileInputStream("file/newExcel.xlsx"));
		} catch (IOException e) {
			e.printStackTrace();
		}
		for (int i = 0; i <= wb.getActiveSheetIndex(); i++) {
			System.out.println("sheet" + (i + 1));
			Sheet sheet = wb.getSheetAt(i);
			for (int j = 0; j < sheet.getPhysicalNumberOfRows(); j++) {
				Row row = sheet.getRow(j);
				for (int z = 0; z < row.getPhysicalNumberOfCells(); z++) {
					System.out.print(row.getCell(z).getRichStringCellValue().getString() + "\t");
				}
				System.out.println();
			}
		}
	}

	public static void main(String[] args) {
		App app = new App();
		app.test();
	}
}

存库就不需要了吧？

[zilin110]

引用 2 楼 u010783365 的回复:

package cn.com.test.poiImport;

import java.io.FileInputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

/**
 * 读取Excel文件 2016-03-09
 */
public class App {

	private POIFSFileSystem fs;
	private Workbook wb;

	public void test() {
		try {
			// 获取文件
			// =========03版本===========================
			fs = new POIFSFileSystem(new FileInputStream("file/oldExcel.xls"));
			wb = new HSSFWorkbook(fs);
			// =========07版本===========================
			// wb = new XSSFWorkbook(new FileInputStream("file/newExcel.xlsx"));
		} catch (IOException e) {
			e.printStackTrace();
		}
		for (int i = 0; i <= wb.getActiveSheetIndex(); i++) {
			System.out.println("sheet" + (i + 1));
			Sheet sheet = wb.getSheetAt(i);
			for (int j = 0; j < sheet.getPhysicalNumberOfRows(); j++) {
				Row row = sheet.getRow(j);
				for (int z = 0; z < row.getPhysicalNumberOfCells(); z++) {
					System.out.print(row.getCell(z).getRichStringCellValue().getString() + "\t");
				}
				System.out.println();
			}
		}
	}

	public static void main(String[] args) {
		App app = new App();
		app.test();
	}
}

存库就不需要了吧？

楼上正解. 但是要注意单元格的格式. 全部都设置成文本格式. 时间格式除外.