/*
* jxldemo.java
*
* Created on 2007-7-18, 10:38:43
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/
package demo;
import jxl.*;
import java.io.*;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
/**
*
* @author 蒋明原
*/
public class jxldemo {
public static void main(String [] args)throws IOException, WriteException{
WorkbookSettings ws = new WorkbookSettings();
WritableWorkbook workbook;
String filename="测试.xls";
workbook = Workbook.createWorkbook(new File("c:/"+filename), ws);//创建文件
WritableSheet sheet = workbook.createSheet("测试", 0);//创建sheet
sheet.mergeCells(0, 0, 3, 2);
jxl.write.Label lable=new jxl.write.Label(0,0,"ssss");
sheet.addCell(lable);
lable=new jxl.write.Label(0,6,"ddddd");//列、行、内容(第一列、行从0开始计数)
sheet.addCell(lable);
//合并单元格
//sheet.mergeCells(0, 0, 3, 2);
//参数:(第一列、行从0开始计数)
//第一个:左上列数
//第二个:左上行数
//第三个:右下列数
//第四个:右下行数
workbook.write();
workbook.close();
}
}
另附jxl下载地址http://sourceforge.net/project/showfiles.php?group_id=79926