答:
完整的程序如下:
package cn.hniyanzi;
import java.io.File;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class CExcel {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String
path="E:\\Excel.xls",
number[]= {"one","two"};//矩形名字
int
LeftPoint[][]= {{1,1},{2,2}},//左上角坐标
rightPoint[][]= {{3,3},{4,4}};//右下角坐标
File excelFile=new File(path);
try {
excelFile.createNewFile(); //生成文件
WritableWorkbook workbook=Workbook.createWorkbook(excelFile); //打开文件
//指定sheet的名称
WritableSheet sheet = workbook.createSheet("第一页 ", 0);
for (int i=0 ; i<number.length;i++) {
Label label = new Label(0,i,number[i]);//先列后行
// 将定义好的单元格添加到工作表中
sheet.addCell(label);
for(int j=0;j<LeftPoint[i].length;j++) {
/*
* 生成一个保存数字的单元格 必须使用Number的完整包路径,否则有语法歧义
*/
jxl.write.Number Lpoint = new jxl.write.Number(j+1,i,LeftPoint[i][j] );
sheet.addCell(Lpoint);
jxl.write.Number Rpoint = new jxl.write.Number(j+3,i,rightPoint[i][j] );
sheet.addCell(Rpoint);
}
}
// 写入数据并关闭文件
workbook.write();
workbook.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}