JXLS Demo

最新推荐文章于 2024-02-09 18:03:54 发布

原创最新推荐文章于 2024-02-09 18:03:54 发布 · 281 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #人工智能

工具专栏收录该内容

10 篇文章

订阅专栏

JxlsUtil.java


package template;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.HashMap;
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;
import org.apache.poi.ss.usermodel.Workbook;

public class JxlsUtil {

	/**
	 * 导出excel
	 * @param templateFile - excel模版名称
	 * @param beans - 模版中填充的数据
	 * @param os - 生成模版输出流
	 */
	public static void exportExcel(String templateFile,Map<String,Object> beans,OutputStream os) {
	     XLSTransformer transformer = new XLSTransformer();
	     InputStream is=JxlsUtil.class.getClassLoader().getResourceAsStream(templateFile);
	     try {
			Workbook workbook=transformer.transformXLS(is,beans);
			workbook.write(os);
		} catch (Exception e) {
			throw new RuntimeException("导出excel错误!");
		} 
	}

	public static void main(String[] args) throws ParsePropertyException, InvalidFormatException, IOException {
		OutputStream os=new FileOutputStream("new.xls");
		String templateFile="template/jxls_template.xls";
		Map<String, Object> beans=new HashMap<String, Object>();

		// fruits
		List<Map<String,String>> fruitList=new ArrayList<Map<String,String>>();

		Map<String,String> fruit=null;
		fruit=new HashMap<String, String>();
		fruit.put("name", "苹果");
		fruit.put("price", "100");
		fruitList.add(fruit);

		fruit=new HashMap<String, String>();
		fruit.put("name", "香蕉");
		fruit.put("price", "200");
		fruitList.add(fruit);

		beans.put("fruits",fruitList);
		exportExcel(templateFile, beans, os);
	}
}

template/jxls_template.xls
[img]http://dl.iteye.com/upload/attachment/0069/3315/29a2a324-97f2-3bd2-839e-26a96cab51d8.bmp[/img]

在使用<jx:forEach>做循环时，如果<jx:forEach>和</jx:forEach> 在同一行就可以做横向循环