java实现下载excle工具类

最新推荐文章于 2024-02-28 15:59:47 发布
最新推荐文章于 2024-02-28 15:59:47 发布
阅读量377 收藏 1
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/superPojo/article/details/106789079
版权

具体封装了一个下载utils类，让下载excle代码更加简洁，使用更加方便(用的是poi，不要忘了pom引入)，看一下这个工具类：

import java.beans.IntrospectionException;
import java.beans.PropertyDescriptor;
import java.io.OutputStream;
import java.io.Serializable;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.lang.reflect.Type;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Set;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.util.CellRangeAddress;
import org.springframework.util.CollectionUtils;

import com.ihwdz.core.DateUtils;
import com.ihwdz.core.StringUtils;

public class DownExcelUtils
{
	
	public static final DownExcelUtils INSTANCE = new DownExcelUtils();
	private final RecordProduces RECORD_PRODUCES = new RecordProduces();
	
	public  HttpServletResponse export(HttpServletResponse response , RecordProduces recordProduces) throws Exception{
		
		OutputStream os = null;  
        
        try {
    		response.addHeader("Content-Disposition", "attachment;filename="+new String(recordProduces.getFileName().getBytes("gb2312"), "ISO8859-1" )+".xls");
    		os = response.getOutputStream();
    		HSSFWorkbook wb = new HSSFWorkbook();
    		
    		if(!CollectionUtils.isEmpty(recordProduces.getRecords())){
    			boolean upOrLeft = (recordProduces.getAlignLeft() == null ? false : (!recordProduces.getAlignLeft()));
    			
    			if(recordProduces.getRecords().size() == 1){
    				
    				Record record = recordProduces.getRecords().get(0);
					HSSFSheet sheet = wb.createSheet(getSheetName(wb,record.getSheetName()));
					insetTitle(wb,sheet,record,0,0,upOrLeft);
					insertData(wb, sheet,record,0,0,upOrLeft);
    				
    			}else{
    				Integer [] area = {0,0};
    				
    				if((recordProduces.getMutilSheet() == null) || recordProduces.getMutilSheet() == true){
    					
    					for(int i = 0; i< recordProduces.getRecords().size(); i++ ){
        				
        					Record record = recordProduces.getRecords().get(i);
        					HSSFSheet sheet = wb.createSheet(getSheetName(wb,record.getSheetName()));

        					insetTitle(wb,sheet,record,area[0],area[1],upOrLeft);
        					insertData(wb, sheet, record , area[0],area[1],upOrLeft);
    					}
    				}else{
    					
    					
    					HSSFSheet sheet = wb.createSheet(getSheetName(wb, recordProduces.getFileName()));
    					
    					for(int i = 0; i< recordProduces.getRecords().size(); i++ ){
    						Record record = recordProduces.getRecords().get(i);
    						
    						insetTitle(wb,sheet,record,area[0],area[1],upOrLeft);		
    						area = insertData(wb, sheet, record , area[0],area[1],upOrLeft);
    					}
    					
    				}
    			}
    		}
    		
            wb.write(os);      
        	
            os.flush();
			os.close();
  		
		} catch (Exception e) {
			e.printStackTrace();
			os.flush();
			os.close();
		}
		finally{
			os.flush();
			os.close();
		} 
        
		return  response;
	}
	
	public RecordProduces getRecordProduces(){
		return RECORD_PRODUCES;
	}
	
	public Record getRecordInstance()
	{
		return DownExcelUtils.INSTANCE.new Record();
	} 
	
	public LinkedHashMap<String,ParamType> getLinkedHashMapInstance()
	{
		return new LinkedHashMap<String,ParamType>();
	}
	
	public List<Record> getRecordList()
	{
		return new ArrayList<Record>();
	}
	
	public LinkedHashMap<String,ParamType> addParamType(LinkedHashMap<String,ParamType> linkedHashMap ,  String paramKey , String paramTitle ,Class<?> TypeClass){
		
		if(linkedHashMap == null ){
			linkedHashMap = getLinkedHashMapInstance();
		}
		
		linkedHashMap.put(paramKey, new ParamType(paramKey , paramTitle , TypeClass));
		
		return linkedHashMap;
	}
	
	public LinkedHashMap<String,ParamType> addParamType(LinkedHashMap<String,ParamType> linkedHashMap ,  String paramKey , String paramTitle){
		
		if(linkedHashMap == null ){
			linkedHashMap = getLinkedHashMapInstance();
		}
		
		linkedHashMap.put(paramKey, new ParamType(paramKey , paramTitle));
		
		return linkedHashMap;
	}
	
	private void insetTitle(HSSFWorkbook wb , HSSFSheet sheet ,Record record ,int height , int width , boolean upOrLeft)
	{
		
		HSSFRow titleRow = null;
		
		if(upOrLeft){
			titleRow = sheet.createRow(height);
		}else{
			titleRow = sheet.getRow(0);
			
			if(titleRow == null){
				titleRow = sheet.createRow(0);
			}
		}
		
        HSSFCellStyle style = wb.createCellStyle();  
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER); 
        
        HSSFFont font = wb.createFont();
        font.setFontName("黑体");
        font.setFontHeightInPoints((short) 16);//设置字体大小
        style.setFont(font);
        
        HSSFCell cell = titleRow.createCell(upOrLeft == true ? 0 : width);
        cell.setCellStyle(style);
        
        if(StringUtils.isNotEmpty(record.getTitle())){
        	 cell.setCellValue(record.getTitle()); 	
        }
        
	}
	
	
	 /**
	     * 导入数据到表格中
	     * @param wb execl文件
	     * @param sheet 表格
	     * @param row 表格行
	     * @param record 要导出的数据
	     * @param out 输出流
	     */

	
	
	private Integer[] insertData(HSSFWorkbook wb, HSSFSheet sheet, Record recordColection , int height , int width , boolean upOrLeft ){
		
		HSSFDataFormat format = wb.createDataFormat();	
		HSSFCellStyle style = wb.createCellStyle();
		
		   Integer[] area = new Integer[2];
		   
		   LinkedHashMap<String,ParamType> param = recordColection.getParam();
		   List<?> record = recordColection.getRecord();
		   
	       String title[]  = new String[param.size()];
		   param.keySet().toArray(title);
		   
		   HSSFRow row = null;

		   if(upOrLeft){
			  row = sheet.createRow(height + 1);					///title
		   
		   }else{
			   row = sheet.getRow(1);
			   if(row == null){
				   row = sheet.createRow(1);
			   }
		   }
		   
		   for(int i = 0; i < title.length; i++){
	           row.createCell( (upOrLeft == true ? i : width + i) ).setCellValue(param.get(title[i]).getParamTitle());
	       }
		   
	       for(int i = 0 ; i < record.size(); i++ ){											 data

	    	   if(upOrLeft){
	    		   row = sheet.createRow( height + i+2);
	    	   }else{
	    		   
	    		   row = sheet.getRow(i+2);
	    		   
	    		   if(row == null){
	    			 row = sheet.createRow(i+2);
	    		   }
	    	   }

	    	   for(int j = 0; j < title.length; j++){
		    	   
	    		   ParamType paramType = param.get(title[j]);
		           MethodVO methodVO = getObjectValue(record.get(i),paramType.getParamKey());
		           
		           if(methodVO.getObj() == null){
		        	   row.createCell( upOrLeft == true ? j : width + j ).setCellValue("");   
		           }else{
		        	   
		        	   if( recordColection.getIsRealType() == null || recordColection.getIsRealType() == false){
		        		
		        		   row.createCell(upOrLeft == true ? j : width + j).setCellValue(String.valueOf(methodVO.getObj()));
		        	  
		        	   }else{
		        		   row = fillRealType(row,upOrLeft == true ? j : width + j , methodVO, paramType.getTypeClass(), format, style);
		        	   }
		           }
		       }
	       }

	      if(upOrLeft){
	    	   CellRangeAddress region = new CellRangeAddress(height,height, 0,title.length-1);
	    	   sheet.addMergedRegion(region);
	       }else{
	    	   
	    	  CellRangeAddress region = new CellRangeAddress(0,0, width, width + title.length-1);
	    	  sheet.addMergedRegion(region);
	       }
	        
	      if(upOrLeft){
	    	  area[0] = height + record.size() + 3;
		      area[1] = (width + title.length + 1);
	      }else{
	    	  area[0] = record.size() + 3;
		      area[1] = (width + title.length + 1);
	      }
	      
	      return area;
	   }
	
	
	/**
	 * 
	* @description: 获取实体的 filed值
	* @param obj
	* @param filed
	* @return
	 */
	private  MethodVO getObjectValue(Object obj, String filed)
	{  
	    
		MethodVO result = new MethodVO();
		
		try {  
	        Class<? extends Object> clazz = obj.getClass();  
	        PropertyDescriptor pd = new PropertyDescriptor(filed, clazz);  
	        Method method = pd.getReadMethod();		//获得get方法  
	        
	        if (pd != null) {  
	           
	        	result.setObj(method.invoke(obj));
	        	result.setMethod(method);
	        }
	        
	    } catch (SecurityException e) {  
	        e.printStackTrace();  
	    } catch (IllegalArgumentException e) {  
	        e.printStackTrace();  
	    } catch (IntrospectionException e) {  
	        e.printStackTrace();  
	    } catch (IllegalAccessException e) {  
	        e.printStackTrace();  
	    } catch (InvocationTargetException e) {  
	        e.printStackTrace();  
	    }  
		
		return result;
	}  
	
	//填充真实的类型
	private HSSFRow fillRealType(HSSFRow row, int j, MethodVO methodVO , Class<?> realClass , HSSFDataFormat format,HSSFCellStyle style ){
			
			Method method = methodVO.getMethod();
			
			Object obj = methodVO.getObj();
			Type type = method.getGenericReturnType();
			
			if(StringUtils.isTrimEmpty(String.valueOf(obj))){
				
				row.createCell(j).setCellValue(String.valueOf(obj));
				return row;
			}
			
			try
			{
				if(realClass != null){
					
					if(realClass.equals(String.class)){
						
						row.createCell(j).setCellValue(String.valueOf(obj));  

					}else if(realClass.equals(Integer.class)|| realClass.equals(int.class)){
					
						row.createCell(j).setCellValue(Integer.valueOf(String.valueOf(obj)));
					
					}else if(realClass.equals(Double.class)||realClass.equals(double.class)){
						
						row.createCell(j).setCellValue(Double.valueOf(String.valueOf(obj)));  
					
					}else if(realClass.equals(Float.class)|| realClass.equals(float.class)){
						
						row.createCell(j).setCellValue(		new Float(String.valueOf(obj)));  

					}else if(realClass.equals(Date.class)){
						
						style.setDataFormat(format.getFormat(getDateTag(obj)));
						
						if(type.equals(Date.class)){
							
							row.createCell(j).setCellValue(
									DateUtils.getJustDate((((Date)obj).getTime())));
							row.getCell(j).setCellStyle(style);
							
						}else{
							row.createCell(j).setCellValue(
									DateUtils.getDate(String.valueOf(obj),getDateSourceTag(obj)));
							
							row.getCell(j).setCellStyle(style);
						}
					}else{
						row.createCell(j).setCellValue(String.valueOf(obj));
					}
					
				}else{
					
					if(type.equals(String.class)){
						
						row.createCell(j).setCellValue(String.valueOf(obj));  

					}else if(type.equals(Integer.class)|| type.equals(int.class)){
					
						row.createCell(j).setCellValue(Integer.valueOf(String.valueOf(obj)));
					
					}else if(type.equals(Double.class)||type.equals(double.class)){
						
						row.createCell(j).setCellValue(Double.valueOf(String.valueOf(obj)));  
					
					}else if(type.equals(Float.class)|| type.equals(float.class)){
						
						row.createCell(j).setCellValue(Float.valueOf(String.valueOf(obj)));  
					
					}else if(type.equals(Date.class)){
						
						style.setDataFormat(format.getFormat(getDateTag(obj)));
						
						row.createCell(j).setCellValue(
								DateUtils.getJustDate((((Date)obj).getTime())));
						
						row.getCell(j).setCellStyle(style);
						
					}else{
						row.createCell(j).setCellValue(String.valueOf(obj));
					}
				}
			}
			catch (Exception e){
				row.createCell(j);
			}

			return row;
	}
	
	private String getDateTag(Object obj){
		
		if(obj.equals(Date.class)){
		
			return  "yyyy/M/d";
		
		}else{
			
			String tag = "yyyy/M/d";
			String dateTagArr[] = String.valueOf(obj).split("-");
			
			if(dateTagArr.length == 2){
				tag = "yyyy/M";

			}else if(dateTagArr.length == 1){
			
				tag = "yyyy";
				
			}else{
				tag = "yyyy/M/d";
			}
			
			return tag;
		}
	}
	
	private String getDateSourceTag(Object obj){
		
		if(obj.equals(Date.class)){
		
			return  "yyyy-MM-dd";
		
		}else{
			
			String tag = "yyyy-MM-dd";
			String dateTagArr[] = String.valueOf(obj).split("-");
			
			if(dateTagArr.length == 2){
				tag = "yyyy-MM";

			}else if(dateTagArr.length == 1){
			
				tag = "yyyy";
				
			}else{
				tag = "yyyy-MM-dd";
			}
			
			return tag;
		}
	}
	
	private Set<String> getAllSheetName(HSSFWorkbook workbook){
		
		Set<String> set = new HashSet<String>();
		
		if(workbook.getNumberOfSheets() > 0 ){
			for(int i= 0; i < workbook.getNumberOfSheets(); i++){
				set.add(workbook.getSheetAt(i).getSheetName());
			}
		}
		
		return set;
	}
	
	/**
	 * 
	* @description: 获取sheet 的名称
	* @param records
	* @return
	 */
	private String getSheetName(HSSFWorkbook wb, String sheetName){

		if(StringUtils.isNotEmpty(sheetName)){
			
			HSSFSheet sheet = wb.getSheet(sheetName);
			
			if(sheet == null){
				return sheetName;
			}else{
				return getDefaultSheetName(wb,sheetName);
			}
			
		}else{
			return getDefaultSheetName(wb,"Sheet");
		}
	}
	
	private String getDefaultSheetName(HSSFWorkbook wb,String preName){
		
		Set<String> allName = getAllSheetName(wb);
		String defaultName = "";
		
		int i = 1;
		
		while(true){
			defaultName = preName+"副本"+(i++);
			if(!allName.contains(defaultName)){break;}
		}
		
		return defaultName;
	}
	
	private class MethodVO implements Serializable
	{
		private static final long serialVersionUID = 1L;
		
		private Object obj;
		private Method method;
		
		public Object getObj()
		{
			return obj;
		}
		public void setObj(Object obj)
		{
			this.obj = obj;
		}
		public Method getMethod()
		{
			return method;
		}
		public void setMethod(Method method)
		{
			this.method = method;
		}
	}
	
	public class ParamType implements Serializable
	{
		/**
		 * 
		 */
		private static final long serialVersionUID = -3672552185769409063L;
		
		String paramKey;
		String paramTitle;
		Class<?> TypeClass;
		
		public ParamType(String paramKey, String paramTitle, Class<?> typeClass)
		{
			this.paramKey = paramKey;
			this.paramTitle = paramTitle;
			TypeClass = typeClass;
		}
		
		public ParamType(String paramKey, String paramTitle)
		{
			this.paramKey = paramKey;
			this.paramTitle = paramTitle;
		}
		
		
		public String getParamKey()
		{
			return paramKey;
		}
		public void setParamKey(String paramKey)
		{
			this.paramKey = paramKey;
		}
		public String getParamTitle()
		{
			return paramTitle;
		}
		public void setParamTitle(String paramTitle)
		{
			this.paramTitle = paramTitle;
		}
		public Class<?> getTypeClass()
		{
			return TypeClass;
		}
		public void setTypeClass(Class<?> typeClass)
		{
			TypeClass = typeClass;
		}
	}
	
	public class Record implements Serializable
	{
		private static final long serialVersionUID = 383811221104753903L;
		
		private String title;
		private String sheetName;
		private Boolean isRealType;			//默认是使用
		private List<?> record;
		private LinkedHashMap<String,ParamType> param;
		
		public String getSheetName()
		{
			return sheetName;
		}
		public void setSheetName(String sheetName)
		{
			this.sheetName = sheetName;
		}
		public List<?> getRecord()
		{
			return record;
		}
		public void setRecord(List<?> record)
		{
			this.record = record;
		}
		
		public LinkedHashMap<String, ParamType> getParam()
		{
			return param;
		}
		public void setParam(LinkedHashMap<String, ParamType> param)
		{
			this.param = param;
		}
		public String getTitle()
		{
			return title;
		}
		public void setTitle(String title)
		{
			this.title = title;
		}
		public Boolean getIsRealType()
		{
			return isRealType;
		}
		public void setIsRealType(Boolean isRealType)
		{
			this.isRealType = isRealType;
		}
		
	}
	
	public class RecordProduces implements Serializable
	{
		private static final long serialVersionUID = 383811221104753903L;
		
		private String fileName;
		private List<Record> records;
		private Boolean mutilSheet;		//多个 Record 时候, 是否使用 多个 sheet 表单 装载   , true 多个表单， false 单个
		private Boolean alignLeft;		//多个 Record 时候 , 只使用一个 sheet 表单  是从上往下排列数据还是从左往右排列数据 true 左右, false 上下
		
		public String getFileName()
		{
			return fileName;
		}
		public void setFileName(String fileName)
		{
			this.fileName = fileName;
		}
		public List<Record> getRecords()
		{
			return records;
		}
		public void setRecords(List<Record> records)
		{
			this.records = records;
		}
		public Boolean getMutilSheet()
		{
			return mutilSheet;
		}
		public void setMutilSheet(Boolean mutilSheet)
		{
			this.mutilSheet = mutilSheet;
		}
		public Boolean getAlignLeft()
		{
			return alignLeft;
		}
		public void setAlignLeft(Boolean alignLeft)
		{
			this.alignLeft = alignLeft;
		}
		
	}
	
	/**
	 * 
	* @description: 导出单个记录
	* @param request
	* @param response
	* @param entityList 记录
	* @param column   对象列描述Map
	* @param title    标题
	* @param fileName 文件名
	 */
	public static void export(HttpServletRequest request,HttpServletResponse response , List<?> entityList, LinkedHashMap<String,String> column ,String title, String fileName ){
		
		if(!CollectionUtils.isEmpty(entityList)){
			
			DownExcelUtils instance = DownExcelUtils.INSTANCE; 
			RecordProduces recordProduces = instance.getRecordProduces();
			List<Record> records = instance.getRecordList();
				
			LinkedHashMap<String,ParamType>  param =  new LinkedHashMap<String,ParamType>(); 
			
			for (String key : column.keySet()) { 
				instance.addParamType(param, key, column.get(key));
			} 
			
			Record record = instance.getRecordInstance();
			record.setParam(param);
			record.setRecord(entityList);
			record.setTitle(title);
			records.add(record);

			recordProduces.setMutilSheet(false);
            recordProduces.setFileName(fileName);
            recordProduces.setRecords(records);
			
			try
			{
				instance.export(response, recordProduces);
			} 
			catch (Exception e)
			{
				e.printStackTrace();
			}
		}
	}
	
	
	public static void exportWithParamType(HttpServletRequest request,HttpServletResponse response , List<?> entityList, LinkedHashMap<String,ParamType> param ,String title, String fileName ){
		
		if(!CollectionUtils.isEmpty(entityList)){
			
			DownExcelUtils instance = DownExcelUtils.INSTANCE; 
			RecordProduces recordProduces = instance.getRecordProduces();
			List<Record> records = instance.getRecordList();
			
			Record record = instance.getRecordInstance();
			record.setParam(param);
			record.setRecord(entityList);
			record.setTitle(title);
			record.setIsRealType(false);
			records.add(record);

			recordProduces.setMutilSheet(false);
            recordProduces.setFileName(fileName);
            recordProduces.setRecords(records);

            try
			{
				instance.export(response, recordProduces);
			} 
			catch (Exception e)
			{
				e.printStackTrace();
			}
		}
	}

	/**
	 * 
	* @description: 装载 record
	* @param entityList
	* @param column
	* @param title
	* @return
	 */
	public static Record loadRecord(List<?> entityList,LinkedHashMap<String,String> column ,String title){
		
		DownExcelUtils instance = DownExcelUtils.INSTANCE; 

		LinkedHashMap<String,ParamType>  param =  new LinkedHashMap<String,ParamType>(); 
			
		for (String key : column.keySet()) { 
			instance.addParamType(param, key, column.get(key));
		} 
			
		Record record = instance.getRecordInstance();
		record.setParam(param);
		record.setRecord(entityList);
		record.setTitle(title);
		
		return record;
	}
	
	public static Record loadRecordWithParamType(List<?> entityList,LinkedHashMap<String,ParamType> param ,String title){
		
		DownExcelUtils instance = DownExcelUtils.INSTANCE; 
			
		Record record = instance.getRecordInstance();
		record.setParam(param);
		record.setRecord(entityList);
		record.setTitle(title);
		record.setIsRealType(false);
		return record;
	}





}

具体使用方法：

        
         // 对象数据集合
         ArrayList<Object> list = new ArrayList<Object>();
		
		DownExcelUtils instance = DownExcelUtils.INSTANCE;
			
		LinkedHashMap<String,ParamType>  column =  new LinkedHashMap<String,ParamType>(); 
		// orderSn --是对象的字段，“订单号” -- excle 表头的名字
        // 以此类推，添加对象字段和excle表头
        instance.addParamType(column, "orderSn","订单号");
		instance.addParamType(column, "orderSn","订单号");
		instance.addParamType(column, "orderSn","订单号");
		
	
		RecordProduces recordProduces = instance.getRecordProduces();
	
		List<Record> records = instance.getRecordList();
        // 将单个list 封装成Record对象，
		Record record = DownExcelUtils.loadRecordWithParamType(list, column, "excle名");
	    /**
          *  可以添加多个list 数据一起导出  
          */  
		//Record record = DownExcelUtils.loadRecordWithParamType(list, column, "excle名");
        // 加入
		records.add(record);
		//records.add(record);如果多个
        

		recordProduces.setMutilSheet(false);//多个 Record 时候, 是否使用 多个 sheet 表单 装载   , true 多个表单， false 单个
		// recordProduces.setAlignLeft(true);多个 Record 时候 , 只使用一个 sheet 表单  是从        
        //上往下排列数据还是从左往右排列数据 true 左右, false 上下
        recordProduces.setFileName("excle名");
        recordProduces.setRecords(records);

        try
		{
			// 导出
            instance.export(response, recordProduces);
		} 
		catch (Exception e)
		{
			e.printStackTrace();
		}

 

All In丶
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Java导出到excel的工具类
05-01
NULL 博文链接：https://liushuoa.iteye.com/blog/2376548
【JAVA下载excel工具类】
m0_49229693的博客
07-13 429
java下载excel工具类
Java生成Excel工具类 文件下载工具类
ZksLoveLy的博客
05-02 517
  public static String NO_DEFINE = "no_define";//未定义的字段    public static String DEFAULT_DATE_PATTERN="yyyy年MM月dd日";//默认日期格式    public static int DEFAULT_COLOUMN_WIDTH = 17;   /**     * 导出Excel 97(.xls...
java Excel工具类
最新发布
1853
02-28 508
java Excel工具类。
java项目中Excel文件的导入导出
weixin_30847939的博客
08-31 198
package poi.excel; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.lang.reflect.Field; import java.lang.reflect.Method; import ...
java写的excel万能工具类
08-18
在Java编写Excel工具类时，通常会依赖Apache POI来实现对Excel文件的操作。 2. **工作簿（Workbook）和工作表（Sheet）对象**：Apache POI提供了`Workbook`和`Sheet`接口，分别代表Excel文件和其中的一个工作表。...
java实现的导出Excel工具类实例
08-29
Java实现的导出Excel工具类实例主要介绍了Java实现的导出Excel工具类，结合具体实例形式分析了Java导出Excel导出并生成Excel表格相关操作技巧与注意事项。该工具类提供了一个可复用的解决方案，用于将数据导出到...
Java使用excel工具类导出对象功能示例
08-28
Java使用excel工具类导出对象功能示例 本文主要介绍了Java使用excel...本文提供了一個完整的Java excel工具类导出对象功能的实现步骤和相关操作技巧，旨在帮助读者快速掌握Java excel工具类导出对象功能的使用方法。
java使用POI导出 Excel工具类
08-14
java使用POI导出 Excel+图片工具类 ，里面含有poi jar包，只调用接口即可直接保存Excel。使用的时候需先把数据封装，具体包装需根据实际导出数据进行处理。文件demo中只提供包装格式。
java实现excel导入数据的工具类
09-04
本文将详细介绍一个基于Java实现的Excel导入数据的工具类，它使用了jxl库来读取Excel文件，并提供了简单易用的API接口。 首先，我们要了解jxl库，这是一个Java API，用于读写Microsoft Excel格式的文件。它支持读取...
Excel工具类
01-16
配合它 使用：https://blog.csdn.net/youngyouth/article/details/86510724 竟然不能免费下载，LJ CSDN
java操作excel工具类
11-15
java操作excel工具类java操作excel工具类java操作excel工具类java操作excel工具类
java生成并下载excel
09-07
java下载包含数据和多张网络图片的。
java上传并读取excel工具类
01-17
java上传并读取excel工具类 涉及到MultiFile转FIle 以及多个sheet页
java 导入导出excel文件(工具类)
07-15
用于java导入导出excel文件,集成工具类,示例
JAVA 下载EXCEL
qq_28461661的博客
12-27 670
1.在指定的目录下创建excel 2.不需要知道传来的是什么类，利用传来的List获取对象并利用反射得到每个类的get方法，并给每个EXCEL的每个列赋值 3.表头是根据数据库中的字典表获取的每个表的中文字符。 package com.example.demo.util; import com.example.demo.domain.User; import org.apache.poi.h...
Java项目中Excel下载工具类与注意事项
热门推荐
weixin_55229531的博客
02-03 1万+
Java项目中Excel下载工具类与注意事项
基于java实现下载excel
speciallove的博客
03-19 1511
excel生成并下载 注意事项 ajax请求的数据类型不能以二进制流形式返回，所以建议以 表单形式提交，附带参数可以以隐藏域传值或者url后拼接。 使用window.location.href。 在前端拿到二进制流在处理等等。 前台代码 html 代码 <!-- 前端form表单代码 --> <form id="userExport" action='...
JAVA导出Excel的工具类
灵魂和肉体总要有一个在路上
09-20 1466
JAVA导出Excel的工具类 /** *标记的步骤一到十二是主要要用的方法，我是将自己写需求时的代码直接复制过来的，所以当中会穿插 *一些我自己的需求方面的代码，做此博文，是方便以后自己用 * * */ import com.qf.entity.Hosregister; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apac...
Java实现Excel导入导出工具类示例
本文主要介绍了如何在Java中实现导入导出功能，特别是在处理Excel文件时。作者通过一个简短的背景故事引入，描述了一个程序员接到紧急的导入导出任务，并利用现有的工具类来快速完成工作的情境。文章提供了相关的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值