Java Web利用POI导出Excel的示例（不在数据库取数据，Map类型的数据）

最新推荐文章于 2022-01-14 15:49:10 发布

后会无期_hlx

最新推荐文章于 2022-01-14 15:49:10 发布

阅读量554

点赞数

前台的js代码如下：

    Javascript代码   
    
  
 <script>  
 function exportExcel(){  
      location.href="excel/export";  
      <!--这里不能用ajax请求，ajax请求无法弹出下载保存对话框-->  
  }  
 </script>  

Controller层代码如下

package com.terry.action;

/*** import begin ***/

import java.io.IOException;
import java.io.OutputStream;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.terry.data.dao.oracle.RepLddxDao;
import com.terry.lc.Fxrb;
import com.terry.lc.Lddx;
import com.terry.util.DateUtil;
import com.terry.util.Tools;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ExportExcelAction extends SuperAction {

	/*** import end ***/

	/*** property begin ***/
	private static final Log	log	= LogFactory.getLog(ExportExcelAction.class);

	/*** property end ***/

	/*** function begin ***/

	/*** function end ***/

	/*** getset begin ***/

	/*** getset end 
	 * @throws IOException ***/

	public String exportExcel() throws IOException{
	  
        List
    
    
     
     > list = new ArrayList
     
     
      
      
       
       >(); 
        
        Map
       
       
         m1 = new HashMap<>(); Map 
        
          m2 = new HashMap<>(); m1.put("name", "xiaozhang"); m1.put("age", "1"); m2.put("name", "xiaowang"); m2.put("age", "2"); list.add(m1); list.add(m2); String[] excelHeader = { "Name", "Age"}; HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("Student"); HSSFRow row = sheet.createRow((int) 0); HSSFCellStyle style = wb.createCellStyle(); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); for (int i = 0; i < excelHeader.length; i++) { HSSFCell cell = row.createCell(i); cell.setCellValue(excelHeader[i]); cell.setCellStyle(style); sheet.autoSizeColumn(i); } for (int i = 0; i < list.size(); i++) { row = sheet.createRow(i + 1); Map 
         
           map = list.get(i); row.createCell(0).setCellValue(map.get("name")); row.createCell(1).setCellValue(map.get("age")); } response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-disposition", "attachment;filename=student.xls"); OutputStream ouputStream = response.getOutputStream(); wb.write(ouputStream); ouputStream.flush(); ouputStream.close(); return SUCCESS; } }

HSSFSheet sheet = wb.createSheet("Student");

这句话声明了创建的表的名称，建议可以加一个当前的时间类，以区别导出的报表的名称

后会无期_hlx

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Java Web利用POI导出Excel的示例（不在数据库取数据，Map类型的数据）

前台的js代码如下： Javascript代码 function exportExcel(){ location.href="excel/export"; } Controller层代码如下 package com.terry.action;/*** import be
复制链接

扫一扫