coreoz / windmill Goto Github PK

To keep excel support, a BOM might be needed for UTF-8

POI 3.17 is impacted by CVE-2019-12415. Need to upgrade to 4.1.1 or newer to resolve.

Attempting to retrieve a String value from an XLSX that has values like TRUE and FALSE throws the following:

java.lang.IllegalStateException: Cannot get a STRING value from a BOOLEAN cell

	at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:1077)
	at org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:395)
	at org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:71)
	at com.coreoz.windmill.imports.parsers.excel.ExcelCell.asString(ExcelCell.java:39)
	at com.coreoz.windmill.WindmillTest.parsingFunction(WindmillTest.java:232)
	at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
	at java.util.stream.SliceOps$1$1.accept(SliceOps.java:204)
	at java.util.stream.SliceOps$1$1.accept(SliceOps.java:204)
	at java.util.Spliterators$IteratorSpliterator.tryAdvance(Spliterators.java:1812)
	at java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:126)
	at java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:499)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:486)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)
	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)
	at com.coreoz.windmill.WindmillTest.should_export_excel_data_starting_from_a_non_origin_point(WindmillTest.java:84)

List<MyObject> test = List.of(new MyObject().setCommentary("\"test\";").setStatus("status")); Windmill .export(test) .withHeaderMapping(new ExportHeaderMapping<MyObject>() .add("comment", MyObject::getCommentary) .add("status", MyObject::getStatus) ) .asCsv(ExportCsvConfig.builder().separator(';').quoteChar('"').escapeChar('\\').charset(BomCharset.UTF_8).build()) .writeTo(outputStream); }

The expected result is ["test";] in the first cell and [status] in the second.

But the result is [\test"] and [;status"]

While exporting an excel / csv, Windmill only allows data mapping with it's own custom implementations of the ExportMapping interface.

Having a method in the ExportConfig class allowing any implementation could prove useful and represents a low load of work

Hi,

Thanks for the great library!

Are there any plans to open it for contributions? I have some ideas in the following areas:

1. Streaming write of data out to any OutputStream, by supporting SXSSFWorkbook
2. Out of the box support for annotation mapping, using https://github.com/classgraph/classgraph

I'm also interested in becoming main maintainer of the library, if you don't have time to invest in it.

hey bro.
I try to write Chinese characters to csv but csv file is ???
do you know how to solve it