表格通用导出修复

LiJun

2018-10-22 d61326581ec74e17bff7d7a71c0137e6693a0fc3

表格通用导出修复

 gx_tieta/src/com/fgkj/servlets/ExportTableServlet.java

@@ -136,8 +136,8 @@
        String exp_thead_str = req.getParameter("exp_thead");

        String exp_tbody_str = req.getParameter("exp_tbody");

        

        String exp_page_break = req.getParameter("exp_page_break");

        String exp_data_break = req.getParameter("exp_data_break");

        String exp_page_break = "\\"+req.getParameter("exp_page_break");

        String exp_data_break = "\\"+req.getParameter("exp_data_break");

        

        String exp_page_names_str =  req.getParameter("exp_page_names");

        

@@ -160,18 +160,20 @@
                exp_page_names = exp_page_names_str.split(exp_page_break);            //分割工作簿的名称

                

                String[] exp_thead_sheets = exp_thead_str.split(exp_page_break);

                String[] exp_tbody_sheets = exp_tbody_str.split(exp_page_break);		
                String[] exp_tbody_sheets = exp_tbody_str.split(exp_page_break);	
				
                

                for (int i = 0; i < exp_page_names.length && exp_page_names.length >= exp_thead_sheets.length; i++) {

                    HSSFSheet sheet = workbook.createSheet(excelTitle);

                    HSSFSheet sheet = workbook.createSheet(exp_page_names[i]);

                    String[] exp_thead = exp_thead_sheets[i].split(exp_data_break);

                    String[] exp_tbody = exp_tbody_sheets[i].split(exp_data_break);

                    

                    int maxColNum = exp_thead.length;            //最大列数

                    int nowRowNum = 0;                            //当前行

                    int nowColNum = 0;                            //当前列

                    HSSFRow row = null;

                    for(int j=0;j <= exp_tbody.length;j++){

                        HSSFRow row = null;

                        //System.out.println("j="+j+"\t nowRowNum="+nowRowNum);

                        if(j == 0){

                            row = sheet.createRow(nowRowNum++); 

                            for(int k=0;k<exp_thead.length;k++){    

@@ -187,6 +189,7 @@
                        }

                        HSSFCell cell = row.createCell(nowColNum++);

                        HSSFRichTextString text = new HSSFRichTextString(exp_tbody[j-1]);

                        //HSSFRichTextString text = new HSSFRichTextString("*****");

                        //System.out.print(text+"\t");

                        cell.setCellValue(text);                        

                    }                    

@@ -197,6 +200,8 @@
                    + new String(excelName.getBytes("gb2312"), "ISO8859-1")

                    + ".xls");

            OutputStream out = resp.getOutputStream();

            workbook.write(out);

            out.close();

        } catch (UnsupportedEncodingException e) {

            e.printStackTrace();

        } catch (IOException e) {

@@ -418,5 +423,10 @@
       

    }

    

	
    public static void main(String[] args) {

        String ths = "h1&h2&h3&h4$xh1&xh2&xh3&xh4";

        System.out.println(ths.indexOf("$"));

        String[] sheets = ths.split("\\&");

        System.out.println(sheets.length);

    }

}