只要记住Excel的组成结构就很好做了,Excel-->Sheet--->Cell
package excel;
import jxl.*;
import jxl.write.WritableWorkbook;
import jxl.write.*;
public class TestExcel {
/**
* @param args
*/
public static void main(String[] args) {
new TestExcel().getExcel();
new TestExcel().writeExcel();
}
//获取Excel
public void getExcel(){
Workbook b=null;
try {
b=Workbook.getWorkbook(new java.io.File("d:\\aa.xls"));
Sheet sheet=b.getSheet(0);
Cell[] cells=sheet.getRow(0);
String temp=cells[0].getContents();
System.out.println(temp);
} catch (Exception e) {
}
}
//生成Excel
public void writeExcel(){
WritableWorkbook wwb=null;
try {
wwb=Workbook.createWorkbook(new java.io.File("d:\\test.xls"));
WritableSheet sheet=wwb.createSheet("测试", 0);
Label l=new Label(0,0,"领用日期");
sheet.addCell(l);
wwb.write();
wwb.close();
} catch (Exception e) {
}
}
}
package excel;
import jxl.*;
import jxl.write.WritableWorkbook;
import jxl.write.*;
public class TestExcel {
/**
* @param args
*/
public static void main(String[] args) {
new TestExcel().getExcel();
new TestExcel().writeExcel();
}
//获取Excel
public void getExcel(){
Workbook b=null;
try {
b=Workbook.getWorkbook(new java.io.File("d:\\aa.xls"));
Sheet sheet=b.getSheet(0);
Cell[] cells=sheet.getRow(0);
String temp=cells[0].getContents();
System.out.println(temp);
} catch (Exception e) {
}
}
//生成Excel
public void writeExcel(){
WritableWorkbook wwb=null;
try {
wwb=Workbook.createWorkbook(new java.io.File("d:\\test.xls"));
WritableSheet sheet=wwb.createSheet("测试", 0);
Label l=new Label(0,0,"领用日期");
sheet.addCell(l);
wwb.write();
wwb.close();
} catch (Exception e) {
}
}
}