Quick BI自助取数执行失败报错："The maximum length of cell contents (text) is 32,767 characters"

问题描述

Quick BI自助取数执行失败报错："The maximum length of cell contents (text) is 32,767 characters"。

022-03-11 10:25:31,676 ERROR [com.alibaba.yunbi.v2.xengine.executor.ThreadPoolManager-4-thread-45801] [QueryOfflineTaskEngineImpl.java:447] [c456e521-ba44-4092-99f9-b046457f33bb] - downloadId[448894b9-efe2-482d-889f-3cdff6497534] write file error :
java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters
 at org.apache.poi.xssf.streaming.SXSSFCell.setCellValue(SXSSFCell.java:325)
 at com.alibaba.yunbi.executor.task.queryoffline.QueryOfflineTaskEngineImpl.writeExcelFile(QueryOfflineTaskEngineImpl.java:435)
 at com.alibaba.yunbi.executor.task.queryoffline.QueryOfflineTaskEngineImpl.executeWithStream(QueryOfflineTaskEngineImpl.java:225)
 at com.alibaba.yunbi.executor.task.queryoffline.QueryOfflineTaskEngineImpl.lambda$executeTask$0(QueryOfflineTaskEngineImpl.java:152)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:877)

问题原因

由于一个单元格的数据太大了，超出了Excel的限制，导致导出Excel 失败。

解决方案

不导出该字段或者将数据保持在32767以内即可。

适用于

• Quick BI