createxls.java

来自「java实现动态更新,可以利用javascipt和远程java的互动完成」· Java 代码 · 共 48 行

package org.excel.demo;

import java.io.File;
import java.io.IOException;



import jxl.*; 
import jxl.write.*; 
import jxl.write.Number;
import jxl.write.biff.RowsExceededException;

public class CreateXLS {
	public WritableWorkbook book = null;
	public WritableSheet sheet = null;
	public void create() throws IOException, RowsExceededException, WriteException
	{
		book = Workbook.createWorkbook(new File("test.xls"));
		sheet = book.createSheet("number1", 0);
		Label lable = new Label(1,0,"test");
		sheet.addCell(lable);
		Number number = new Number(2,0,123.456);
		sheet.addCell(number);
		book.write();
		book.close();
	}
	public static void main(String[] args) throws RowsExceededException, WriteException, IOException {
		
		CreateXLS cs = new CreateXLS();
		cs.create();
		try {
			Workbook wb = Workbook.getWorkbook(new File("test.xls"));
			cs.book = Workbook.createWorkbook(new File("test.xls"),wb);
			cs.sheet = cs.book.getSheet(0);
			Label lable = new Label(0,0,"test");
			cs.sheet.addCell(lable);
			Number number = new Number(1,0,123.456);
			cs.sheet.addCell(number);
			cs.book.write();
			cs.book.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
		
		
	}
}