{"action":"opened","issue":{"url":"https://api.github.com/repos/alibaba/easyexcel/issues/612","repository_url":"https://api.github.com/repos/alibaba/easyexcel","labels_url":"https://api.github.com/repos/alibaba/easyexcel/issues/612/labels{/name}","comments_url":"https://api.github.com/repos/alibaba/easyexcel/issues/612/comments","events_url":"https://api.github.com/repos/alibaba/easyexcel/issues/612/events","html_url":"https://github.com/alibaba/easyexcel/issues/612","id":496222694,"node_id":"MDU6SXNzdWU0OTYyMjI2OTQ=","number":612,"title":"web中写文件，使用动态表头的写法，文件无法打开，提示错误","user":{"login":"netyjq","id":13848223,"node_id":"MDQ6VXNlcjEzODQ4MjIz","avatar_url":"https://avatars1.githubusercontent.com/u/13848223?v=4","gravatar_id":"","url":"https://api.github.com/users/netyjq","html_url":"https://github.com/netyjq","followers_url":"https://api.github.com/users/netyjq/followers","following_url":"https://api.github.com/users/netyjq/following{/other_user}","gists_url":"https://api.github.com/users/netyjq/gists{/gist_id}","starred_url":"https://api.github.com/users/netyjq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/netyjq/subscriptions","organizations_url":"https://api.github.com/users/netyjq/orgs","repos_url":"https://api.github.com/users/netyjq/repos","events_url":"https://api.github.com/users/netyjq/events{/privacy}","received_events_url":"https://api.github.com/users/netyjq/received_events","type":"User","site_admin":false},"labels":[{"id":828210584,"node_id":"MDU6TGFiZWw4MjgyMTA1ODQ=","url":"https://api.github.com/repos/alibaba/easyexcel/labels/bug","name":"bug","color":"d73a4a","default":true}],"state":"open","locked":false,"assignee":{"login":"zhuangjiaju","id":18475586,"node_id":"MDQ6VXNlcjE4NDc1NTg2","avatar_url":"https://avatars3.githubusercontent.com/u/18475586?v=4","gravatar_id":"","url":"https://api.github.com/users/zhuangjiaju","html_url":"https://github.com/zhuangjiaju","followers_url":"https://api.github.com/users/zhuangjiaju/followers","following_url":"https://api.github.com/users/zhuangjiaju/following{/other_user}","gists_url":"https://api.github.com/users/zhuangjiaju/gists{/gist_id}","starred_url":"https://api.github.com/users/zhuangjiaju/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhuangjiaju/subscriptions","organizations_url":"https://api.github.com/users/zhuangjiaju/orgs","repos_url":"https://api.github.com/users/zhuangjiaju/repos","events_url":"https://api.github.com/users/zhuangjiaju/events{/privacy}","received_events_url":"https://api.github.com/users/zhuangjiaju/received_events","type":"User","site_admin":false},"assignees":[{"login":"zhuangjiaju","id":18475586,"node_id":"MDQ6VXNlcjE4NDc1NTg2","avatar_url":"https://avatars3.githubusercontent.com/u/18475586?v=4","gravatar_id":"","url":"https://api.github.com/users/zhuangjiaju","html_url":"https://github.com/zhuangjiaju","followers_url":"https://api.github.com/users/zhuangjiaju/followers","following_url":"https://api.github.com/users/zhuangjiaju/following{/other_user}","gists_url":"https://api.github.com/users/zhuangjiaju/gists{/gist_id}","starred_url":"https://api.github.com/users/zhuangjiaju/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhuangjiaju/subscriptions","organizations_url":"https://api.github.com/users/zhuangjiaju/orgs","repos_url":"https://api.github.com/users/zhuangjiaju/repos","events_url":"https://api.github.com/users/zhuangjiaju/events{/privacy}","received_events_url":"https://api.github.com/users/zhuangjiaju/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2019-09-20T08:37:46Z","updated_at":"2019-09-20T08:37:46Z","closed_at":null,"author_association":"NONE","body":"**触发场景描述**\r\nweb中写文件，使用动态表头的写法，用文档软件无法打开文件，提示遇到错误\r\n**触发Bug的代码**\r\n```java\r\n  EasyExcel.write(response.getOutputStream())\r\n                    .head(getHead())\r\n                    .sheet(\"数据明细\")\r\n                    .table()\r\n                    .head(SmsEffectExportVO.class)\r\n                    .needHead(false)\r\n                    .doWrite(exportVOList);\r\n\r\nprivate List<List<String>> getHead() {\r\n        List<String> headList = Arrays.asList(\"日期\", \"退款客户数(人)\", \"退款金额(元)\", \"客单价(元)\", \"退款订单数(笔)\", \"平均退款宝贝数(件)\", \"退款率(%)\");\r\n        List<String> head0 = Collections.singletonList(headList.get(0));\r\n        List<String> head1 = Collections.singletonList(headList.get(1));\r\n        List<String> head2 = Collections.singletonList(headList.get(2));\r\n        List<String> head3 = Collections.singletonList(headList.get(3));\r\n        List<String> head4 = Collections.singletonList(headList.get(4));\r\n        List<String> head5 = Collections.singletonList(headList.get(5));\r\n        List<String> head6 = Collections.singletonList(headList.get(6));\r\n        return Arrays.asList(head0, head1, head2, head3, head4, head5, head6);\r\n    }\r\n\r\n\r\n@Data\r\npublic class SmsEffectExportVO extends BaseRowModel {\r\n    private String date;\r\n    private long customerCount;\r\n    private String amount;\r\n    private String unitPrice;\r\n    private long orderCount;\r\n    private long itemCount;\r\n    private String avgItemNum;\r\n    private String rate;\r\n}\r\n```\r\n**提示的异常或者没有达到的效果**\r\n无异常信息。\r\n"}}
{"actor":{"display_login":"netyjq"}}