?? xlsrw.java
字號:
package com.corba.mnq.xls;
import java.io.File;
import common.Logger;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class XlsRw {
private static Logger logger = Logger.getLogger(XlsRw.class);
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try{
File input=new File("d:\\TestSpec.xls");
File output=new File("d:\\output.xls");
logger.setSuppressWarnings(Boolean.getBoolean("jxl.nowarnings"));
Workbook book1=Workbook.getWorkbook(input);
WritableWorkbook book2=Workbook.createWorkbook(output,book1);
WritableSheet sheet=book2.getSheet("TestSpec");
WritableSheet sheet1=book2.getSheet("TestReport");
for( int i=1;i<9;i++){
for( int j=2;j<8;j++){
Number n = (Number) sheet1.getWritableCell(j,i);
n.setValue(0);
}
}
for( int i=1;i<8; i++){
Label lb;
if( i<10 ){
sheet.removeRow(1);
/*
lb=new Label(0,i,""+i);
sheet.addCell(lb);
lb=new Label(1,i,"xxxxxxx");
sheet.addCell(lb);
lb=new Label(2,i,"File");
sheet.addCell(lb);
lb=new Label(3,i,"M");
sheet.addCell(lb);
lb=new Label(4,i,"UnTested");
sheet.addCell(lb);
*/
} else if( i<20 ){
lb=new Label(0,i,""+i);
sheet.addCell(lb);
lb=new Label(1,i,"xxxxxxx");
sheet.addCell(lb);
lb=new Label(2,i,"Module");
sheet.addCell(lb);
lb=new Label(3,i,"M");
sheet.addCell(lb);
lb=new Label(4,i,"UnTested");
sheet.addCell(lb);
} else if( i<30 ){
lb=new Label(0,i,""+i);
sheet.addCell(lb);
lb=new Label(1,i,"xxxxxxx");
sheet.addCell(lb);
lb=new Label(2,i,"Interface");
sheet.addCell(lb);
lb=new Label(3,i,"M");
sheet.addCell(lb);
lb=new Label(4,i,"UnTested");
sheet.addCell(lb);
} else if( i<40 ){
lb=new Label(0,i,""+i);
sheet.addCell(lb);
lb=new Label(1,i,"xxxxxxx");
sheet.addCell(lb);
lb=new Label(2,i,"Operation");
sheet.addCell(lb);
lb=new Label(3,i,"M");
sheet.addCell(lb);
lb=new Label(4,i,"UnTested");
sheet.addCell(lb);
} else {
lb=new Label(0,i,""+i);
sheet.addCell(lb);
lb=new Label(1,i,"xxxxxxx");
sheet.addCell(lb);
lb=new Label(2,i,"Parameter");
sheet.addCell(lb);
lb=new Label(3,i,"M");
sheet.addCell(lb);
lb=new Label(4,i,"UnTested");
sheet.addCell(lb);
}
}
book2.write();
book2.close();
}catch(Exception ex){
ex.printStackTrace();
return;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -