Java POI的自适应列宽度

https://blog.csdn.net/earandear/article/details/94601016

https://blog.csdn.net/dragon9a/article/details/72818740

		int maxColumn = sheet.getRow(0).getPhysicalNumberOfCells();
		for(int i = 0; i < maxColumn; i++){
			sheet.autoSizeColumn(i);
		}
		for(int columnNum = 0; columnNum <= maxColumn; columnNum++){
			int columnWidth = sheet.getColumnWidth(columnNum) / 256;
			for(int rowNum = 0; rowNum <= sheet.getLastRowNum(); rowNum++){
				Row currentRow;
				if(sheet.getRow(rowNum) == null){
					currentRow = sheet.createRow(rowNum);
				}else{
					currentRow = sheet.getRow(rowNum);
				}
				
				if(currentRow.getCell(columnNum) != null){
					Cell currentCell = currentRow.getCell(columnNum);
					try {
						int length = currentCell.toString().getBytes("GBK").length;
						if(columnWidth < length + 1){
							columnWidth = length + 8;
						}
					} catch (UnsupportedEncodingException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
			}
			sheet.setColumnWidth(columnNum, columnWidth * 256);
		}