bailongming comments

Results 6 comments of


                                            bailongming

读取 poi 生成的excel报错 com.alibaba.excel.exception.ExcelAnalysisException: org.xml.sax.SAXParseException; lineNumber: 44476; columnNumber: 81; Invalid byte 2 of 4-byte UTF-8 sequence.

将多余的sheet页删除后单独跑有问题的sheet 就是ok的

读取 poi 生成的excel报错 com.alibaba.excel.exception.ExcelAnalysisException: org.xml.sax.SAXParseException; lineNumber: 44476; columnNumber: 81; Invalid byte 2 of 4-byte UTF-8 sequence.

见信好：     附件是excel，辛苦！ ------------------ 原始邮件 ------------------ 发件人: "alibaba/easyexcel" ***@***.***>; 发送时间: 2022年8月2日(星期二) 晚上9:16 ***@***.***>; ***@***.******@***.***>; 主题: Re: [alibaba/easyexcel] 读取 poi 生成的excel报错 com.alibaba.excel.exception.ExcelAnalysisException: org.xml.sax.SAXParseException; lineNumber: 44476; columnNumber: 81; Invalid byte 2 of 4-byte UTF-8 sequence....

读取 poi 生成的excel报错 com.alibaba.excel.exception.ExcelAnalysisException: org.xml.sax.SAXParseException; lineNumber: 44476; columnNumber: 81; Invalid byte 2 of 4-byte UTF-8 sequence.

@zhuangjiaju 附件比较大我用邮箱回复了 http://mail.qq.com/cgi-bin/ftnExs_download?t=exs_ftn_download&k=79336262c4156f94745c6b6d44640b4a040501535a0100501c57545503490d5700504f035a570b485301515b51500c0408015a046277392f5e513d3107015200436c3453574a4109424b625f&code=13bbbd9e

读取 poi 生成的excel报错 com.alibaba.excel.exception.ExcelAnalysisException: org.xml.sax.SAXParseException; lineNumber: 44476; columnNumber: 81; Invalid byte 2 of 4-byte UTF-8 sequence.

> 提供下excel http://mail.qq.com/cgi-bin/ftnExs_download?t=exs_ftn_download&k=79336262c4156f94745c6b6d44640b4a040501535a0100501c57545503490d5700504f035a570b485301515b51500c0408015a046277392f5e513d3107015200436c3453574a4109424b625f&code=13bbbd9e

读取 poi 生成的excel报错 com.alibaba.excel.exception.ExcelAnalysisException: org.xml.sax.SAXParseException; lineNumber: 44476; columnNumber: 81; Invalid byte 2 of 4-byte UTF-8 sequence.

@chenzhongyu11 我把poi 生成excel 的 cellStyle 设置为文本（之前都是默认常规）尝试了下发现 easyExcel 3.1.0 读取无异常了。十分费解

读取 poi 生成的excel报错 com.alibaba.excel.exception.ExcelAnalysisException: org.xml.sax.SAXParseException; lineNumber: 44476; columnNumber: 81; Invalid byte 2 of 4-byte UTF-8 sequence.

见信好：     附件是excel ，辛苦了！万分感谢 ------------------ 原始邮件 ------------------ 发件人: "alibaba/easyexcel" ***@***.***>; 发送时间: 2022年8月2日(星期二) 晚上8:21 ***@***.***>; ***@***.******@***.***>; 主题: Re: [alibaba/easyexcel] 读取 poi 生成的excel报错 com.alibaba.excel.exception.ExcelAnalysisException: org.xml.sax.SAXParseException; lineNumber: 44476; columnNumber: 81; Invalid byte 2 of 4-byte UTF-8...