jxl的实例
来源:互联网 发布:mac preview 编辑图片 编辑:程序博客网 时间:2024/05/14 06:06
package com.excel;
import jxl.*;
import jxl.write.*;
import java.io.*;
import java.io.File.*;
import java.util.*;
public class excel {
public static void main(String[] args){
String targetfile = "c:/out.xls";// 输出的excel文件名
String worksheet = "List";// 输出的excel文件工作表名
String[] title = {"ID","NAME","DESCRIB"};// excel工作表的标题
WritableWorkbook workbook;
try
{
// 创建可写入的Excel工作薄,运行生成的文件在tomcat/bin下
// workbook = Workbook.createWorkbook(new File("output.xls"));
System.out.println("begin");
OutputStream os=new FileOutputStream(targetfile);
workbook=Workbook.createWorkbook(os);
WritableSheet sheet = workbook.createSheet(worksheet, 0); // 添加第一个工作表
// WritableSheet sheet1 = workbook.createSheet("MySheet1", 1); //可添加第二个工作
/*
* *jxl.write.Label label = new jxl.write.Label(0, 2, "A label record");
*//put a label in cell A3, Label (column,row)
*// sheet.addCell(label);
*/
jxl.write.Label label;
for (int i=0; i<title.length; i++)
{
// Label(列号,行号 ,内容 )
label = new jxl.write.Label(i, 0, title[i]); // put the title in row1
sheet.addCell(label);