wangguanquan / eec Goto Github PK
View Code? Open in Web Editor NEWA fast and lower memory excel write/read tool.一个非POI底层,支持流式处理的高效且超低内存的Excel读写工具
Home Page: https://github.com/wangguanquan/eec/wiki
License: Apache License 2.0
A fast and lower memory excel write/read tool.一个非POI底层,支持流式处理的高效且超低内存的Excel读写工具
Home Page: https://github.com/wangguanquan/eec/wiki
License: Apache License 2.0
class A extends B {
}
如上代码,最终excel里只包含A类字段
RT
如下代码设置无效
@ExcelColumn(share = false)
private String name;
由cn.ttzero改为org.ttzero
RT
保持代码统一
建议删除
ListSheet传 入一个Arrays.List或者Collections.singletonList会抛UOE,错误信息如下:
java.lang.UnsupportedOperationException
at java.util.AbstractList.remove(AbstractList.java:161)
at java.util.AbstractList$Itr.remove(AbstractList.java:374)
at java.util.AbstractList.removeRange(AbstractList.java:571)
at java.util.AbstractList.clear(AbstractList.java:234)
at org.ttzero.excel.entity.ListSheet.close(ListSheet.java:211)
at org.ttzero.excel.entity.e7.XMLWorkbookWriter.createTemp(XMLWorkbookWriter.java:451)
at org.ttzero.excel.entity.e7.XMLWorkbookWriter.writeTo(XMLWorkbookWriter.java:115)
at org.ttzero.excel.entity.Workbook.writeTo(Workbook.java:811)
at cn.colvin.service.ExcelThreadTest.escapeTest(ExcelThreadTest.java:506)
测试代码如下:
new Workbook("0")
.addSheet(Collections.singletonList(s))
.writeTo(defaultPath.resolve("escape"));
java.lang.IndexOutOfBoundsException: Index: 12, Size: 1
at org.ttzero.excel.reader.SharedStrings.checkBound(SharedStrings.java:355)
at org.ttzero.excel.reader.SharedStrings.get(SharedStrings.java:268)
at org.ttzero.excel.reader.Row.toString(Row.java:1040)
ExcelReader 针对sheet中row, 怎样获取行中的cell总数的方法
feature_支持通过row获取cell的datatype否?
大数据量导出时如果字段加上@ExcelColumn(share = true)
注解使用内存飙高,希望可以改进
java.lang.NumberFormatException: For input string: "2.737661105078712E+17"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Long.parseLong(Long.java:589)
at java.lang.Long.parseLong(Long.java:631)
at org.ttzero.excel.reader.Row.getLong(Row.java:479)
at org.ttzero.excel.reader.Row.getLong(Row.java:440)
at org.ttzero.excel.reader.HeaderRow.methodPut(HeaderRow.java:399)
at org.ttzero.excel.reader.HeaderRow.put(HeaderRow.java:359)
at org.ttzero.excel.reader.Row.too(Row.java:1000)
ExcelReader 中sheet,迭代一次后,能否再次从头读取
单元格格式为Time类型
org.ttzero.excel.reader.UncheckedTypeException: ConstantNumber 0.08702546296296296 can't convert to java.util.Date
at org.ttzero.excel.util.DateUtil.toTimestamp(DateUtil.java:214)
at org.ttzero.excel.reader.Row.toString(Row.java:1024)
at java.lang.String.valueOf(String.java:2994)
at java.io.PrintStream.println(PrintStream.java:821)
at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
at java.util.Iterator.forEachRemaining(Iterator.java:116)
at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
at java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:270)
at java.util.Iterator.forEachRemaining(Iterator.java:116)
at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
使用slf4j统一日志接口,不强制用户使用log4j
sharedStrings.xml如下
<si>
<r>
<rPr>
<sz val="11"/>
<color rgb="FF191F25"/>
<rFont val="宋体"/>
<family val="3"/>
<charset val="134"/>
</rPr>
<t>感应器</t>
</r>
<r>
<rPr>
<sz val="11"/>
<color rgb="FF191F25"/>
<rFont val="Segoe UI"/>
<family val="2"/>
</rPr>
<t>,</t>
</r>
<r>
<rPr>
<sz val="11"/>
<color rgb="FF191F25"/>
<rFont val="宋体"/>
<family val="3"/>
<charset val="134"/>
</rPr>
<t>感应开关</t>
</r>
<r>
<rPr>
<sz val="11"/>
<color rgb="FF191F25"/>
<rFont val="Segoe UI"/>
<family val="2"/>
</rPr>
<t xml:space="preserve"></t>
</r>
<phoneticPr fontId="1" type="noConversion"/>
</si>
java.lang.IllegalArgumentException
at sun.nio.ch.FileChannelImpl.position(FileChannelImpl.java:277)
at sun.nio.ch.FileChannelImpl.position(FileChannelImpl.java:49)
at org.ttzero.excel.reader.XMLSheet.parseDimension(XMLSheet.java:498)
at org.ttzero.excel.reader.XMLMergeSheet.load(XMLSheet.java:751)
at org.ttzero.excel.reader.XMLMergeSheet.load(XMLSheet.java:726)
at org.ttzero.excel.reader.ExcelReader$1.next(ExcelReader.java:264)
at org.ttzero.excel.reader.ExcelReader$1.next(ExcelReader.java:252)
Mybatis使用动态sql来完成sql处理
‘mdyydmyy’字符串程序判断为日期类型,其实并不是
目前worksheet仅提供getSize方法返回最大行数(有时返回-1),需求精准的提供最大行最大列信息
不需要重新解析头部信息
导出数据比正常数据少
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.