package jxl;
import java.io.File;
import java.io.IOException;
import jxl.read.biff.BiffException;
import jxl.write.Boolean;
import jxl.write.DateFormat;
import jxl.write.DateTime;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.NumberFormat;
import jxl.write.WritableCell;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
* 2011-4-26
* jxl 操作 Excel 文档(读,写,改)
* @author Administrator
*
*/
public class JxlTest {
//写入 xls 文件
public void writeXls(String fileName){
try {
File file=new File(fileName);
//打开文件
WritableWorkbook book=Workbook.createWorkbook(file);
//生成名为"第一页"的工作表,参数 0 表示这是第一页
WritableSheet sheet=book.createSheet("first", 0);
//1.在 Label 对象的构造子中指明单元格位置是第一列第一行(0,0)
Label label=new Label(0,0,"dwc");
//将定义好的单元格添加到工资表中
sheet.addCell(label);
//添加带有字型 Formatting 的对象
WritableFont wf=new
WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true);
WritableCellFormat wcff=new WritableCellFormat(wf);
Label labelCf=new Label(1,0,"你好,中国",wcff);
sheet.addCell(labelCf);
/*2.生成一个保存数字的单元格
必须使用 Number 的完整包路径,否则有语法歧义