| | |
|---|
| | | 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");
|
|---|
| | |
|
|---|
| | |
|---|
| | | //定义一个工作簿
|
|---|
| | | HSSFWorkbook workbook = new HSSFWorkbook();
|
|---|
| | |
|
|---|
| | | |
|---|
| | | if(!ServletUtils.isNotNull(exp_page_names_str)){
|
|---|
| | | return;
|
|---|
| | | //exp_page_names[0] = "sheet1";
|
|---|
| | | }else{
|
|---|
| | | if(ServletUtils.isNotNull(exp_thead_str)){
|
|---|
| | | 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); |
|---|
| | | |
|---|
| | | for (int i = 0; i < exp_page_names.length && exp_page_names.length >= exp_thead_sheets.length; i++) {
|
|---|
| | | HSSFSheet sheet = workbook.createSheet(excelTitle);
|
|---|
| | | String[] exp_tbody_sheets = exp_tbody_str.split(exp_page_break); |
|---|
| | | if(!ServletUtils.isNotNull(exp_page_names_str)){
|
|---|
| | | exp_page_names = new String[]{};
|
|---|
| | | for(int s=0;s<exp_tbody_sheets.length;s++){
|
|---|
| | | exp_page_names[s] = "sheet"+s;
|
|---|
| | | }
|
|---|
| | | } |
|---|
| | | |
|---|
| | | for (int i = 0; i < exp_thead_sheets.length; i++) {
|
|---|
| | | HSSFSheet sheet = i<exp_page_names.length?workbook.createSheet(exp_page_names[i]):workbook.createSheet();
|
|---|
| | | 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++){
|
|---|
| | |
|---|
| | | }
|
|---|
| | | 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);
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | } |
|---|
| | | |
|---|
| | | }
|
|---|
| | | |
|---|
| | | // 转码防止乱码
|
|---|
| | | resp.addHeader("Content-Disposition", "attachment;filename="
|
|---|
| | | + 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) {
|
|---|
| | |
|---|
| | |
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | |
|---|
| | | 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);
|
|---|
| | | }
|
|---|
| | | }
|
|---|
