java读取xls

java读取xls

利用jsl.jar这个包，可以很容易的读取xls文件，包在下面的附件中

Java代码

1. import java.io.File;
2. import java.io.IOException;
3. import java.util.ArrayList;
4. import java.util.List;
6. import jxl.Sheet;
7. import jxl.Workbook;
8. import jxl.read.biff.BiffException;
10. public class ParseExcel {
12. static List<String[]> parse(File file) {
13. List<String[]> excelValueList = new ArrayList<String[]>();
14. if (file.exists() && file.canRead()
15. && (file.getName().lastIndexOf(".xls") >=1)) {
16. Workbook workbook = null;
17. try {
18. workbook = Workbook.getWorkbook(file);
19. Sheet sheet = workbook.getSheet(0);
20. int row = sheet.getRows();
21. int col = sheet.getColumns();
22. for (int r =0; r < row; r++) {
23. String[] rowValue = new String[col];
24. for (int c =0; c < col; c++) {
25. rowValue[c] = sheet.getCell(c, r).getContents() != null ? sheet
26. .getCell(c, r).getContents()
27. : "";
28. }
29. excelValueList.add(rowValue);
30. }
31. } catch (BiffException e) {
32. // TODO Auto-generated catch block
33. e.printStackTrace();
34. } catch (IOException e) {
35. // TODO Auto-generated catch block
36. e.printStackTrace();
37. } finally {
38. if (workbook != null) {
39. workbook.close();
40. }
41. }
42. }
43. return excelValueList;
44. }
45. public staticvoid main(String[] args) {
46. String fname = "E:\\1\\高新技术(处理后).xls";
47. File file = new File(fname);
48. List<String[]> excelValueList = new ArrayList<String[]>();
49. excelValueList = parse(file);
50. for(String[] sa:excelValueList){
51. for(String s:sa){
52. System.out.print(s+"----");
53. }
54. System.out.println();
55. }
56. }
58. }

import java.io.File;import java.io.IOException;import java.util.ArrayList;import java.util.List;import jxl.Sheet;import jxl.Workbook;import jxl.read.biff.BiffException;public class ParseExcel {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).getContents() != null ? sheet.getCell(c, r).getContents(): "";}excelValueList.add(rowValue);}} catch (BiffException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();} finally {if (workbook != null) {workbook.close();}}}return excelValueList;}public static void main(String[] args) {String fname = "E:\\1\\高新技术(处理后).xls";File file = new File(fname);List<String[]> excelValueList = new ArrayList<String[]>();excelValueList = parse(file);for(String[] sa:excelValueList){for(String s:sa){System.out.print(s+"----");}System.out.println();}}}