/*
* 主要操作的類有:
* Workbook,WritableWorkbook 工作薄,可寫工作薄
* Sheet,WritableSheet :工作表,可寫工作表
* Cell,Image等,還有其他形式格子 :格子
* 輔助操作的類有:
* 對格子操作的:WritableFont(字體設置) WritableCellFormat(格子格式化,設置格子的各種樣式)
* 對格子中內容格式化:Datetime DateFormat
* Number NumberFormat
* Label
*
*
* 創建工作薄的方式:
* 1.只讀工作薄
* File file = new File("fileName");
* InputStream in = new InputStream(file);
* Workbook workBook = nulll;
* //通過流讀取文件
* workBook = new Workbook(in);
* //WorkbookSetting:以指定格式设定创建文件
* workBook = new Workbook(in,workbookSetting);
* //通過文件讀取文件
* workBook = new Workbook(file);
* workBook = new Workbook(file,workbookSetting);
* 2.只寫工作薄
* OutputStream out = new OutputStream(file);
* //通過輸出流創建工作薄
* WritableWorkbook writeWorkbook = Workbook.createWorkbook(out);
* //通過文件創建工作薄
* writeWorkbook = Workbook.createWorkbook(file);
* //以指定文件為模板創建工作薄
* writeWorkbook = Workbook.createWorkbook(out,workbook);
* writeWorkbook = Workbook.createWorkbook(file,workbook);
* //已制定格式設定 創建工作薄 在上面的創建方法后,在加一個WorkbookSetting參數
* eg:writeWorkbook = Workbook.createWorkbook(file,workbook,workbookSetting);
写xls文件:
OutputStream out = new OutputStream(new File("d://a.xls"));
//通過輸出流創建工作薄
WritableWorkbook writeWorkbook = Workbook.createWorkbook(out);
//通過文件創建工作薄
writeWorkbook = Workbook.createWorkbook(file);
WriteSheet writeSheet=writeWorkbook.createSheet("test",0);
for(int i=0;i<10;i++){
for(int j=0;j<10;j++){
String value=sheet.getCell(j, i).getContents();//這一條記錄沒有錯
//System.out.print("("+i+","+j+")"+value);
writeSheet.addCell(new Label(j,i,"("+i+","+j+")"));
}
System.out.println();
}
writeWorkbook.write();
out.close();
读xls文件:
File file = new File("fileName");
InputStream in = new InputStream(file);
//通過流讀取文件
Workbook workBook = new Workbook(in);
Sheet sheet=workBook.getShett();
int row=sheet.getRows();
int col=shett.getColumns();
for(int i=0;i<row;i++){
for(int j=0;j<rol;j++){
System.out.println(sheet.getCell(j,i).getContext());
}
}
workbook.close();
in.close();