java导入excel数据_请问在java中如何读取Excel的数据

代码如下：

package com.zccs.controller;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.List;

import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;

public class ReadExcel {

public static void main(String[] args) {

ReadExcel obj = new ReadExcel();

// 此处为我创建Excel路径

File file = new File("D:/_20161128092000-20161128141827d28U2.xls");

List excelList = obj.readExcel(file);

System.out.println("list中的数据打印出来");

for (int i = 0; i < excelList.size(); i++) {

List list = (List) excelList.get(i);

for (int j = 0; j < list.size(); j++) {

System.out.print(list.get(j));

}

System.out.println();

}

}

// 去读Excel的方法readExcel，该方法的入口参数为一个File对象

public List readExcel(File file) {

try {

// 创建输入流，读取Excel

InputStream is = new FileInputStream(file.getAbsolutePath());

// jxl提供的Workbook类

Workbook wb = Workbook.getWorkbook(is);

// Excel的页签数量

int sheet_size = wb.getNumberOfSheets();

for (int index = 0; index < sheet_size; index++) {

List outerList = new ArrayList();

// 每个页签创建一个Sheet对象

Sheet sheet = wb.getSheet(index);

// sheet.getRows()返回该页的总行数

for (int i = 0; i < sheet.getRows(); i++) {

List innerList = new ArrayList();

// sheet.getColumns()返回该页的总列数

for (int j = 0; j < sheet.getColumns(); j++) {

String cellinfo = sheet.getCell(j, i).getContents();

if (cellinfo.isEmpty()) {

continue;

}

innerList.add(cellinfo);

// System.out.print(cellinfo);

}

outerList.add(i, innerList);

// System.out.println();

}

return outerList;

}

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (BiffException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

return null;

}

}

maven引入依赖

org.apache.poi

poi

3.16

org.apache.poi

poi-ooxml

3.14

net.sourceforge.jexcelapi

jxl

2.6.10

commons-dbcp

commons-dbcp

1.2.2