package test;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class main {
public static void main(String[] args) throws FileNotFoundException {
// TODO Auto-generated method stub
// ReadExcel();
// writeExcel();
}
private static void writeExcel() {
WritableWorkbook book;
try {
book = Workbook.createWorkbook(new File("F:\\test.xls"));
// 生成名为"第一页"的工作表，参数0表示这是第一页
WritableSheet sheet1 = book.createSheet("第一页", 0);
WritableSheet sheet2 = book.createSheet("第二页", 1);
// 在label对象的构造方法中指名单元格位置是第一列，第一行(0,0)
// 以及单元格内容为test
for(int i=0;i<10;i++){
for(int j=0;j<10;j++){
Label label = new Label(i, j, "("+i+","+j+")");
// 将定义好的单元格添加到工作表中
sheet1.addCell(label);
// 第二列第一行(1,0)
// jxl是从零列零行开始算的
// jxl.write.Number number = new jxl.write.Number(, 0, 888.678);
// sheet1.addCell(number);
}
}
// 写入数据并关闭文件
book.write();
book.close();
System.out.println("生成excel文件成功");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private static void ReadExcel() throws FileNotFoundException {
InputStream is = new FileInputStream("C:\\Users\\Administrator\\Desktop\\test.xls") ;
try {
Workbook wb = Workbook.getWorkbook(is);
jxl.Sheet sheet = wb.getSheet(0);
String content = null;
for (int i = 1; i < sheet.getRows(); i++) {
for (int j = 0; j < sheet.getColumns(); j++) {
content = sheet.getCell(j, i).getContents();
System.out.print(content+" ");
}
System.out.println();
}
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
