xls.java

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

package org.excel.model;

import java.io.File;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class Xls {
	public  static File excelfile         = null;
	public  static WritableWorkbook book  = null;
	public  static WritableSheet    sheet = null;
	public WritableSheet CreateSheet(String sheetname,int sheetnumber){
		
		try {
			 //创建工作表
			 sheet = book.createSheet(sheetname, sheetnumber);
			 
		} catch (Exception e) {
			System.out.println(e);
		}
		return sheet;
	}
	public  WritableWorkbook CreateBook(String xlsname){
		
		
		try {
			//创建xls文件
			 excelfile = new File(xlsname);
			 book = Workbook.createWorkbook(excelfile);
			 
			
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return book;
	}
	public Label CreateStringContent(StringContent c){
		Label label = new Label(c.getLine(),c.getRow(),c.getScontent());
		return label;
	}
	public Number CreateNumberContent(NumberContent c){
		Number number = new Number(c.getLine(),c.getRow(),c.getDcontent());
		return number;
	}
	public void bclose(){
		try {
			book.close();
		} catch (Exception e) {
			System.out.println(e);
		}
	}
}