linux导出Excel The maximum column width for an individual cell is 255 characters

时间:2017-08-18 10:21:51   收藏:0   阅读:1968

linux环境到处Excel报错: The maximum column width for an individual cell is 255 characters

 

解决方案:

for (int i = 0; i < headerList.size(); i++) {  
            int colWidth = sheet.getColumnWidth(i)*2;
            if(colWidth<255*256){
                sheet.setColumnWidth(i, colWidth < 3000 ? 3000 : colWidth);    
            }else{
                sheet.setColumnWidth(i,6000 );
            }
        }

 

原文:http://www.cnblogs.com/frank-quan/p/7387936.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!