使用Jxl解析xls文件
package file;import java.io.File;import java.io.IOException;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import jxl.Cell;import jxl.Sheet;import jxl.Workbook;import jxl.read.biff.BiffException;/** * xls文件解析 */public class parseXlsFile{private static int beginidx = 1;private static int idx = 1;private static final String fullname = "data" + File.separator + "title.xls";private static int startRow =2;public static void main(String[] args){readFromXls(fullname);}public static List<Map<String, String>> readFromXls(String filename){///List<Map<String, String>> datalist = new ArrayList<Map<String, String>>();//Map<String, String> dataMap = new HashMap<String, String>();File file = new File(filename);if (file == null || !file.isFile() || !file.exists()){return null;}try{Workbook workbook = Workbook.getWorkbook(file);// 获取工作簿Sheet sheet = workbook.getSheet(0);// 获取工作表int columns = sheet.getColumns();// 获取列数int rows = sheet.getRows();// 获取行数// 加载标题System.out.println("----------------标题-----------");for (int k = 0; k < columns; k++){Cell cell = sheet.getCell(k, 0);if (cell != null){String contents = cell.getContents();if (contents != null && !contents.equals("")){System.out.println(contents);}}}System.out.println("-----------------数据-----------");// 加载数据for (int i = startRow; i < rows; i++){for (int j = 0; j < columns; j++){String content = sheet.getCell(j, i).getContents();if (content != null && !content.equals("")){System.out.println(content); }}}}catch (BiffException e){e.printStackTrace();}catch (IOException e){e.printStackTrace();}return null;}}?
