poi导出excel2003.docx

.excel;
import ;
import ;
import ;
import ;
import ;
import ;
.;
.;
.;
.;
.;
.;
.;
.;
.;
public class TestExportExcel {


public static void testExport() throws IOException {

HttpServletRequest request = ();
HttpServletResponse response = ();
OutputStream os = ();// 取得输出流
();// 清空输出流

String FName = getExcelFilename(request);

("Content-disposition","attachment; filename="+ new String((),"iso-8859-1") + ".xls");// 设定输出文件头
("application/msexcel");// 定义输出类型


List<String[]> list1 =getExcelDataList(request);//获取数据集合

List<String> list2 = getColoumNameList(request);//获取列明集合

list2=new ArrayList<String>(list2);
String[] FNameArray = ("_");

String SheetName =FNameArray[0];//获取标题名称

createXLSfromArrayList(os,