java代码取excel中的数据
直接进入正题
需要导入必须的jar包
这是.xls类型的excel文件,且此方法只支持次类型文件
然后这是调用的工具类
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 ReadExcelService {
// 去读Excel的方法readExcel,该方法的入口参数为一个File对象
public List readExcel(File file) throws BiffException, IOException {
// 创建输入流,读取Excel
InputStream is=null;
try {
is = new FileInputStream(file.getAbsolutePath());
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// jxl提供的Workbook类
Workbook wb = Workbook.getWorkbook(is);
// Excel的页签数量
int sheet_size = wb.getNumberOfSheets();
List innerList=null;
List<List> outerList=null;
for (int index = 0; index < sheet_size; index++) {
outerList = new ArrayList<List>();
// 每个页签创建一个Sheet对象
Sheet sheet = wb.getSheet(index);
// sheet.getRows()返回该页的总行数
System.out.println(sheet.getRows()+"==="+sheet.getColumns());
for (int i = 0; i < sheet.getRows(); i++) {
innerList = new ArrayList();
// sheet.getColumns()返回该页的总列数
for (int j = 0; j < sheet.getColumns(); j++) {
String cellinfo = sheet.getCell(j, i).getContents();
System.out.println("cellinfo=="+cellinfo);
if (cellinfo.isEmpty()) {
continue;
}
innerList.add(cellinfo);
}
outerList.add(innerList);
}
return outerList;
}
return null;
}
}
这是main方法调用
public static void main(String[] args) {
ReadExcelService obj = new ReadExcelService();
// 此处为我创建Excel路径
File file = new File("C:/Users/Administrator/Desktop/test.xls");
List excelList=null;
try {
excelList = obj.readExcel(file);
System.out.println("list中的数据打印出来"+excelList);
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();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}