java导出Excel...............

首先必须下载Jxl.jar

//传进去的str 为json数据

package com.runlin.analysis.util;


import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;


import javax.servlet.http.HttpServletResponse;


import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;


public class ExcelWriter {


WritableWorkbook wwb = null;
WritableSheet ws = null;
WritableCellFormat cellFormat = null;
String Path = "d:\\";
String fileName;


public ExcelWriter() {


fileName = System.currentTimeMillis() + ".xls";


try {
// 首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象
wwb = Workbook.createWorkbook(new File(Path + fileName));
} catch (IOException e) {
e.printStackTrace();
}
if (wwb != null) {
// 创建一个可写入的工作表
// Workbook的createSheet方法有两个参数，第一个是工作表的名称，第二个是工作表在工作薄中的位置
ws = wwb.createSheet("sheet1", 0);
}


cellFormat = new WritableCellFormat();
try {
cellFormat.setAlignment(jxl.format.Alignment.CENTRE);
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


/**
* 合并单元格并添加内容
* 
* @param arg0
* @param arg1
* @param arg2
* @param arg3
* @param str
* @throws RowsExceededException
* @throws WriteException
*/
public void combine(int arg0, int arg1, int arg2, int arg3, String str)
throws RowsExceededException, WriteException {

              //合并单元格方法
ws.mergeCells(arg0, arg1, arg2, arg3);
addLabel(arg0, arg1, str);
}


/**
* 添加一个单元格
* 
* @param column
* @param row
* @param str
*/
public void addLabel(int column, int row, Object str) {
if (str == null) {
str = "";
}
try {
ws.addCell(new Label(column, row, str.toString(), cellFormat));
} catch (RowsExceededException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


/**
* 添加一个数字
* 
* @param column
* @param row
* @param str
*/
public void addNumberLabel(int column, int row, Object str) {
if (str == null) {
str = "0";
}
try {
ws.addCell(new Label(column, row, str.toString(), cellFormat));
} catch (RowsExceededException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


public void addNumberLabel(int column, int row, int i) {


try {
ws.addCell(new Label(column, row, i + "", cellFormat));
} catch (RowsExceededException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


/**
* 添加一行,row为行号 str为逗号分隔的字符串
* 
* @param row
* @param str
*/
public void addRow(int row, String str) {
String[] strArray = str.split(",");
for (int i = 0; i < strArray.length; i++) {
addLabel(i, row, strArray[i]);
}
}


/**
* 保存
* 
* @throws IOException
*/
public void commit() throws IOException {
try {
// 从内存中写入文件中
wwb.write();
// 关闭资源，释放内存
wwb.close();
} catch (IOException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
}



}

}

//创建方法   如下

 try {


// 创建Excel文件
ExcelWriter excel = new ExcelWriter();


//月份数和选择的字段
int month = 12;
String select[] = "buynum,retail,dealerstock".split(",");
String selectCn[] = "进货,零售,库存".split(",");


// 打印第一行表头
excel.combine(0, 0, 1, 0, "产品");

for (int i = 0; i < month; i++) {
excel.combine(2+(i*select.length), 0, (2-1)+(i*select.length)+select.length, 0,
(i + 1) + "");


}


// 打印第二行表头
excel.addRow(1, "品牌,车系");


for (int i = 0; i < month; i++)
for (int j = 0; j < select.length; j++) {
excel.addLabel(2+(i*select.length)+j, 1, selectCn[j]);
}


// 遍历结果集
for (int i = 0; i < result.size(); i++) {
// 产品
excel.addLabel(0, 2 + i, result.get(i).get("brand"));
excel.addLabel(1, 2 + i, result.get(i).get("carseries"));


//内容
for (int j = 0; j < month; j++)
for (int k = 0; k < select.length; k++) {
excel.addNumberLabel((2+(j*select.length)+k), 2 + i, result.get(i).get(select[k]+(j+1)));

}
}
   excel.commit();
   String filename=excel.getFilename();
json1.put("success", "true");
json1.put("filename",filename);
        } catch (Exception e) {
// TODO: handle exception
    // 出错
json1.put("success", "false");
json1.put("errmsg", "失敗" + e.getMessage());
return json1;
}

return json1;