
使用 jxl 把Excel讀取到java
上一篇 把資料寫入到Excel 這篇就順便將讀取到java補上了
說明都打在註解上了!!就不在多做說明了
java
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
package excel; import java.io.File; import java.io.IOException; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; public class { public static void main(String[] args) { try { Workbook workbook = Workbook.getWorkbook(new File("C:/jxl_test.xls")); Sheet sheet = workbook.getSheet(0); for (int i = 0; i < sheet.getRows(); i++) { for (int j = 0; j < sheet.getColumns(); j++) { Cell cell= sheet.getCell(j,i); System.out.print(cell.getContents()+" "); } System.out.println(); } workbook.close(); } catch (Exception e) { e.printStackTrace(); } } }
|
效果

近期评论