poi导出excel2003.docxVIP

package com.excel;import java.io.IOException;import java.io.OutputStream;import java.util.ArrayList;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.hssf.usermodel.HSSFFont;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.util.HSSFColor;import org.apache.poi.hssf.util.Region;import org.apache.struts2.ServletActionContext;public class TestExportExcel {public static void testExport() throws IOException {HttpServletRequest request = ServletActionContext.getRequest(); HttpServletResponse response = ServletActionContext.getResponse(); OutputStream os = response.getOutputStream();// 取得输出流response.reset();// 清空输出流String FName = getExcelFilename(request);response.setHeader(Content-disposition,attachment; filename=+ new String(FName.getBytes(),iso-8859-1) + .xls);// 设定输出文件头response.setContentType(application/msexcel);// 定义输出类型ListString[] list1 =getExcelDataList(request);//获取数据集合ListString list2 = getColoumNameList(request);//获取列明集合 list2=new ArrayListString(list2); String[] FNameArray = FName.split(_); String SheetName =FNameArray[0];//获取标题名称createXLSfromArrayList(os, list1, list2, SheetName);//生成Excelos.flush();os.close();}private static ListString getColoumNameList(HttpServletRequest request) {// TODO Auto-generated method stub ListString list =new ArrayList();String[] filed = new String[] {ID,时间,sada,2322,2-20-2,1.234};list = java.util.Arrays.asList(filed);// 字符数组转listreturn list;}private static ListString[] getExcelDataList(HttpServletRequest request) {// TODO Auto-generated method stub ListString[] list =new ArrayList(); String[] array1={1,2,3,4,5,6}; String[] array2={哈哈,类名,33,44,ajdlja,6-0999}; String[] array3={1.123,0.2,3ads,asd4,5在哪呢？,6时刻}; String[] array4={1、2,2/2,3