jsp查询出来得数据导入EXCEL表中解决办法

    public static void writeCsvFile(List<FileTestCaseValidateLog> logs, File outputCvsFilePath){        WritableWorkbook book = null;        try {            book = Workbook.createWorkbook(outputCvsFilePath);            //创建sheet.                WritableSheet sheet = book.createSheet("Sheet_1", 0);            for(int i = 0; i < logs.size(); i++){                FileTestCaseValidateLog log = logs.get(i);                Label testCaseLabel = new Label(0, i, log.getTestCaseName());                Label moduleLabel = new Label(1, i, log.getModuleName());                Number number = new Number(2, i, 2);                sheet.addCell(moduleLabel);                sheet.addCell(testCaseLabel);                sheet.addCell(number);            }            book.write();            } catch (RowsExceededException e) {            e.printStackTrace();        } catch (WriteException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        } finally{            try {                if(book != null){                    book.close();                }            } catch (WriteException e) {                e.printStackTrace();            } catch (IOException e) {                e.printStackTrace();            }        }    }
------解决方案--------------------
一段完整的代码。 运用到struts.
Java code
public  static void createExcel(HttpServletRequest request, HttpServletResponse response,            String title,String[] headers,List<String[]> dataList) {        // create a new workbook        HSSFWorkbook wb = new HSSFWorkbook();        // create a new sheet        HSSFSheet s = wb.createSheet(title);                //font        HSSFFont titleFont = wb.createFont();        titleFont.setFontHeightInPoints( (short) 16);        titleFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);        titleFont.setItalic(false);            HSSFFont headFont = wb.createFont();        headFont.setFontHeightInPoints( (short) 12);        headFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);        //headFont.setColor(HSSFFont.COLOR_RED);            HSSFFont bodyFont = wb.createFont();        bodyFont.setFontHeightInPoints( (short) 10);            //CellStyle        HSSFCellStyle csTitle = wb.createCellStyle();        csTitle.setAlignment(HSSFCellStyle.ALIGN_CENTER);        csTitle.setBorderBottom(HSSFCellStyle.BORDER_THIN);        csTitle.setBorderTop(HSSFCellStyle.BORDER_THIN);        csTitle.setBorderLeft(HSSFCellStyle.BORDER_THIN);        csTitle.setBorderRight(HSSFCellStyle.BORDER_THIN);        csTitle.setFont(titleFont);            HSSFCellStyle csHeader = wb.createCellStyle();        csHeader.setFont(headFont);        csHeader.setAlignment(HSSFCellStyle.ALIGN_CENTER);        csHeader.setBorderBottom(HSSFCellStyle.BORDER_THIN);        csHeader.setBorderTop(HSSFCellStyle.BORDER_THIN);        csHeader.setBorderLeft(HSSFCellStyle.BORDER_THIN);        csHeader.setBorderRight(HSSFCellStyle.BORDER_THIN);        //csHeader.setFillBackgroundColor(HSSFColor.YELLOW.index);        // csHeader.setFillForegroundColor(HSSFColor.WHITE.index);        // csHeader.setFillPattern(HSSFCellStyle.ALIGN_CENTER);        csHeader.setLocked(false);                //列数        int  columnNum = headers.length;        short rowNum = 0;        //添加导出excel标题        HSSFRow row = s.createRow(rowNum++);        row.setHeight( (short) 500);        HSSFCell cell = row.createCell(0);        s.addMergedRegion(new CellRangeAddress(0,  0, 0,(columnNum - 1)));        //cell.setEncoding(HSSFCell.ENCODING_UTF_16);        cell.setCellValue(title);        cell.setCellStyle(csTitle);        for (int i = 1; i < columnNum; i++)        {            cell = row.createCell(i);            //cell.setEncoding(HSSFCell.ENCODING_UTF_16);                    }        //create head        row = s.createRow(rowNum++);        short shW = 0;        row.setHeight( (short) 300);        for (int i = 0; i < columnNum; i++)        {            shW = (short) (4500);            s.setColumnWidth(i, shW);                        cell = row.createCell(i);            //cell.setEncoding(HSSFCell.ENCODING_UTF_16);            cell.setCellStyle(csHeader);            cell.setCellValue(headers[i]);        }        //create body                for( int j = 0 ; j < dataList.size(); j++)         {            String[] cellValues = dataList.get(j);            row = s.createRow(rowNum++);            for (int i = 0; i < columnNum; i++)            {                cell = row.createCell(i);                //cell.setEncoding(HSSFCell.ENCODING_UTF_16);                cell.setCellValue(cellValues[i]);            }        }                //下载文件        String fileName = title+".xls";        boolean isIE=false;//检查是否是ie浏览器，；        String agent = request.getHeader("USER-AGENT");        if (null != agent && agent.indexOf("MSIE")!=-1) {                    isIE=true;        }        try {            if(isIE){//如果是ie浏览器，就用这种方式编码文件名；                fileName=URLEncoder.encode(fileName, "UTF-8");            }else{                fileName=new String(fileName.getBytes("UTF-8"),"ISO-8859-1");            }        } catch (UnsupportedEncodingException e) {            e.printStackTrace();        }         response.setContentType("application/vnd.ms-excel;charset=UTF-8");         response.setContentType("application/x-msdownload");         response.addHeader("Content-Disposition","attachment;filename="+fileName);         try {            OutputStream out2 = response.getOutputStream();            wb.write(out2);            out2.flush();            out2.close();        } catch (IOException e) {            e.printStackTrace();        }    }