1. Java读取xls文件可以利用jsl.jar包来进行解析,详细参考:http://xuexin0714.iteye.com/blog/457966。不过这个对于后缀名为xlsx的文件会出错。
public static List<String[]> parse(File file) {
List<String[]> excelValueList = new ArrayList<String[]>();
if (file.exists() && file.canRead()
&& (file.getName().lastIndexOf(".xls") >= 1)) {
Workbook workbook = null;
try {
workbook = Workbook.getWorkbook(file);
Sheet sheet = workbook.getSheet(0);
int row = sheet.getRows();
int col = sheet.getColumns();
for (int r = 0; r < row; r++) {
String[] rowValue = new String[col];
for (int c = 0; c < col; c++) {
rowValue[c] = sheet.getCell(c, r).getCon