利用jxls操作excel模板文件

最新推荐文章于 2024-04-22 21:43:09 发布

清晨鸿雁

最新推荐文章于 2024-04-22 21:43:09 发布

阅读量744

点赞数

文章标签：利用jxls操作excel模板文件 java

本文链接：https://blog.csdn.net/shiyuhong_112233/article/details/48241361

版权

第一步：新建一个java工程，导入jxls对应的jar包（主要包jxls-core-1.0.jar，jxls-reader-1.0.jar）；

第一步：新建一个类，代码如下：

package com.jo.work.attachment.action;
import java.io.File;
import java.io.IOException;
import java.util.HashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

import net.sf.jxls.exception.ParsePropertyException;
import net.sf.jxls.transformer.XLSTransformer;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

public class LoadExcelFileAction {
	private static final long serialVersionUID = 1L;
	
	public static void main(String[] args){
		
        Map<String, Object> beanParams = new HashMap<String, Object>();		
		List<Map<String, Object>> params = new LinkedList<Map<String, Object>>();		
		Map<String, Object> param = new HashMap<String, Object>();		
		param.put("quotaId", "PX-1");		
		param.put("quotaName", "分类一");		
		param.put("quotaUnit", "基");
		param.put("num", 2);
		param.put("material", "名称1");
		param.put("basePrice", 200.2);
		param.put("manMadeFee", 90.5);
		params.add(param);
		
		Map<String, Object> param1 = new HashMap<String, Object>();		
		param1.put("quotaId", "PX-2");		
		param1.put("quotaName", "分类一");		
		param1.put("quotaUnit", "基");
		param1.put("num", 4);
		param1.put("material", "名称2");
		param1.put("basePrice", 250.2);
		param1.put("manMadeFee", 120.5);	
		params.add(param1);
		
		Map<String, Object> param2 = new HashMap<String, Object>();		
		param2.put("quotaId", "PX-3");		
		param2.put("quotaName", "分类三");		
		param2.put("quotaUnit", "组");
		param2.put("num", 24);
		param2.put("material", "名称3");
		param2.put("basePrice", 50);
		param2.put("manMadeFee", 20.5);	
		params.add(param2);
		beanParams.put("params", params);
		exportExcel(beanParams);
	}

	public static void exportExcel(Map<String, Object> beanParams){		
		//读取模板
		String srcFilePath = "D:/file/template.xls";
		//输出文件ַ
		String destFilePath = "D:/file";
		
		new File(destFilePath).mkdirs();			
		XLSTransformer transformer = new XLSTransformer();		
		try {			
			transformer.transformXLS(srcFilePath, beanParams,destFilePath+"/text2.xls");						
		} catch (ParsePropertyException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InvalidFormatException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			
			
		}
		
	}
}

第三步：定义excel模板template.xls

结束。