| | |
|---|
| | | //定义一个工作簿
|
|---|
| | | 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(exp_page_names[i]);
|
|---|
| | | 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);
|
|---|
| | |
|
|---|
| | |
|---|
| | | cell.setCellValue(text);
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | } |
|---|
| | | |
|---|
| | | }
|
|---|
| | | |
|---|
| | | // 转码防止乱码
|
|---|
| | | resp.addHeader("Content-Disposition", "attachment;filename="
|
|---|
| | | + new String(excelName.getBytes("gb2312"), "ISO8859-1")
|
|---|
