readexcel.java

数据库课程lab。通过java下的xmlAPI实现xml文件数据库到oracle数据的迁移。

package logic;

import java.io.*;
import jxl.*;

public class ReadExcel {

	public String[][] readExcel(String fileName) {
		String[][] strTemp = null;
		try {
			// 构建Workbook对象, 只读Workbook对象
			// 直接从本地文件创建Workbook
			// 从输入流创建Workbook

			InputStream is = new FileInputStream(fileName);
			jxl.Workbook rwb = Workbook.getWorkbook(is);
			Sheet rs = rwb.getSheet(0);
			int rows = rs.getRows();
			int cols = rs.getColumns();
			
			strTemp = new String[rows][cols];
			for (int i = 0; i < rows; i++) {
				for (int j = 0; j < cols; j++) {
					Cell ctemp = rs.getCell(j, i);
					strTemp[i][j] = ctemp.getContents();
				}
			}
			rwb.close();
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return strTemp;
	}
}