package com.yeshi.fanli.util;
|
|
import java.io.File;
|
import java.io.IOException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import jxl.Cell;
|
import jxl.Sheet;
|
import jxl.Workbook;
|
import jxl.read.biff.BiffException;
|
|
public class ExcelUtil {
|
|
public static List<String> articelList(String path) {
|
List<String> list = new ArrayList<String>();
|
try {
|
File file = new File(path); // 创建文件对象
|
Workbook wb = Workbook.getWorkbook(file); // 从文件流中获取Excel工作区对象（WorkBook
|
Sheet sheet = wb.getSheet(0); // 从工作区中取得页（Sheet
|
|
for (int i = 0; i < sheet.getRows(); i++) { // 循环打印Excel表中的内
|
Cell cell = sheet.getCell(1, i);
|
if (!StringUtil.isNullOrEmpty(cell.getContents()))
|
list.add((cell.getContents() + "").trim());
|
}
|
} catch (BiffException e) {
|
e.printStackTrace();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
|
public static void updateExcel() {
|
|
}
|
|
}
|
