easyexcel icon indicating copy to clipboard operation
easyexcel copied to clipboard

读取CSV时,值内容遇到双引号会报错

Open sai129198 opened this issue 10 months ago • 2 comments

CSV文件数据行有三列: "a","b","12"ef"34"

读取时报错: java.io.UncheckedIOException: java.io.IOException: Invalid char between encapsulated token and delimiter at line: 1, position: 14 at org.apache.commons.io.function.Uncheck.wrap(Uncheck.java:339) at org.apache.commons.io.function.Uncheck.get(Uncheck.java:199) at org.apache.commons.csv.CSVParser$CSVRecordIterator.getNextRecord(CSVParser.java:149) at org.apache.commons.csv.CSVParser$CSVRecordIterator.hasNext(CSVParser.java:158) at com.alibaba.excel.analysis.csv.CsvExcelReadExecutor.execute(CsvExcelReadExecutor.java:79) at com.alibaba.excel.analysis.ExcelAnalyserImpl.analysis(ExcelAnalyserImpl.java:124) at com.alibaba.excel.ExcelReader.read(ExcelReader.java:66) at com.alibaba.excel.ExcelReader.read(ExcelReader.java:56) at com.alibaba.excel.read.builder.ExcelReaderSheetBuilder.doRead(ExcelReaderSheetBuilder.java:65)

sai129198 avatar Feb 14 '25 08:02 sai129198

请问后来解决了吗

qupei avatar Apr 15 '25 06:04 qupei

请问后来解决了吗

没有。后来使用apache-common-csv来读写CSV了

sai129198 avatar May 15 '25 09:05 sai129198