excel-plus

excel-plus copied to clipboard

commit info 支持多个sheet Writer

1

由于业务需要继而并补充多个sheet的Writer 会慢慢完善

jetlaglyy

How to export multi sheet?

hoaronal

导入excel报错：Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data.

1

Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data. This may indicate that the file is used to...

yangkebiao

请问两百万条数据怎么分表插入呢？因为Excel单表最高只能接收一百万左右的数据，超过的需要分表，而在Excel-plus的API中没有看到有分表的方法，那是不是需要自己写判断来分表呢？

MrSongPing

kamyam

Problem with export

2

Hi everyone; When i want to export a simple excel file I get this error: `java.lang.NoClassDefFoundError: Failed resolution of: Ljavax/xml/stream/XMLStreamReader; at org.apache.xmlbeans.XmlBeans.buildStreamToNodeMethod(XmlBeans.java:247) at org.apache.xmlbeans.XmlBeans.(XmlBeans.java:134) at org.apache.xmlbeans.XmlBeans.typeLoaderForClassLoader(XmlBeans.java:715) at org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook$Factory.getTypeLoader(Unknown Source:25) at...

maysamrasoli

场景，Excel列数不固定的时候，无法去定义一个实体对象，建议添加对Map类型的读取和写出

xkcoding

测试代码： **测试导出，模拟测试数据** ```java @Test public void testWriter() throws WriterException { String fileName = "/Users/yangkai.shen/Desktop/模板.xlsx"; List rows = Lists.newArrayList(new TalendModel("1","1","1","1","1",true,"1","1"),new TalendModel("1","1","1","1","1",false,"1","1"),new TalendModel("1","1","1","1","1",null,"1","1")); Writer.create(ExcelType.XLSX).withRows(rows).headerStyle((book, style) -> { style.setFillBackgroundColor(HSSFColor.HSSFColorPredefined.ORANGE.getIndex()); return style; }).to(new File(fileName));...

xkcoding

rylf-li

source: https://www.hacking8.com/bug-product/Apache-POI/CVE-2019-12415-Apache-POI-_=-4.1.0-XXE%E6%BC%8F%E6%B4%9E.html

zmingchun