使用 jxl.jar 架包生成 Excel文件

package com.util;

import java.io.File;
import java.io.IOException;
import java.io.OutputStream;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.esri.arcgis.display.NewTextBezierCurveFeedback;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.format.Pattern;
import jxl.write.Label;
import jxl.write.VerticalAlignment;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.biff.RowsExceededException;

@SuppressWarnings({ "unused", "deprecation" })
public class WorkBookFactory {
/**
 * 获取一个工作薄实例
 */

@SuppressWarnings({ "unused", "rawtypes" })
public static  WritableWorkbook getWritableWorkbookInstance(OutputStream outputstream,String sheetTile,int columnCount,List list){
WritableWorkbook workBook = null;
try {

  workBook = Workbook.createWorkbook(outputstream);
  WritableSheet sheet = workBook.createSheet(sheetTile, 0);
//设置列宽
for(int i= 0;i<columnCount;i++)
{
sheet.setRowView(0, (short)(1.7*256)); // 设置行的高度  
sheet.setColumnView(i, 20); // 默认列的宽度  
sheet.setColumnView(0, 30); // 设置列的宽度  
}
WritableFont titlefontStyle = new WritableFont(WritableFont.createFont("微软雅黑"), 14);   
titlefontStyle.setBoldStyle(WritableFont.BOLD);//设置字体加粗
WritableCellFormat titleFormate = new WritableCellFormat(titlefontStyle);//生成一个单元格样式控制对象
//titleFormate.setBackground(Colour.BLUE_GREY, Pattern.SOLID);
//titleFormate.setBackground(Colour.DARK_BLUE2, Pattern.SOLID);//这个深蓝底
//titleFormate.setBackground(Colour.OCEAN_BLUE, Pattern.SOLID);//海蓝底背景
titleFormate.setBackground(Colour.DARK_TEAL, Pattern.SOLID);//这个黑蓝底
titleFormate.setAlignment(Alignment.CENTRE); // 设置为右对齐  
titleFormate.setVerticalAlignment(VerticalAlignment.CENTRE);//设置垂直居中
titleFormate.setBorder(Border.ALL, BorderLineStyle.HAIR); // 添加边框  
titlefontStyle.setColour(Colour.WHITE);
String[]  title = {"时间","时间","时间","时间","时间","时间","时间"};
for(int i= 0 ;i<columnCount;i++)
{
Label label = new Label(i,0,title[i],titleFormate);//参数含义 Label(column，row，content,style)
sheet.addCell(label);
}
//*********************以下为内容样式****************************
 WritableFont fontStyle = new WritableFont(WritableFont.createFont("宋体"), 12);   
         fontStyle.setColour(Colour.BLACK);//字体颜色
         WritableCellFormat cellFormat = new WritableCellFormat(fontStyle);  
         cellFormat.setBackground(Colour.WHITE, Pattern.SOLID);// 设置单元格的背景颜色  
//         cellFormat.setAlignment(Alignment.JUSTIFY); //自动调整 单元格内容，设置这个跟设置左右对齐会冲突，只能应用其中一个样式
         cellFormat.setAlignment(Alignment.CENTRE); // 设置为右对齐  
         cellFormat.setVerticalAlignment(VerticalAlignment.CENTRE);//设置垂直居中
         //设置边框xian
//         cellFormat.setBorder(Border.ALL, BorderLineStyle.MEDIUM); // 中等细黑边框
         cellFormat.setBorder(Border.ALL, BorderLineStyle.getStyle(1)); // 这个方法可以设置边框线条粗细
         //填充数据进入  Excel
         for(int i = 0 ;i <list.size();i++){
         sheet.setRowView(i+1, (short)(1.6*256)); // 设置行的高度  
         Map map = (Map)list.get(i);
         Object[] objects={map.get("a"),map.get("b"),map.get("c"),map.get("d")};
         for(int j= 0;j<columnCount;j++)
         {
         Label label = new Label(j,(i+1),objects[j].toString(),cellFormat);//Label(column，row，content,style)
         sheet.addCell(label);
         }
         }
} catch (Exception e) {
e.printStackTrace();
} 

return workBook;
}

}