如何设置以英寸为单位的固定列宽值。阿帕奇波伊

Answer 1

在sheet.setColumnWidth中，这里的度量单位是字符宽度的1/256。还会告诉您Excel是如何精确计算的。

因此，如果希望Excel将列宽显示为10，使用默认字体Calibri 11，那么Width256必须计算为(int)Math.round((10*units.default_character_width+5f)/units.default_character_width*256f)。

如果需要以英寸为单位设置列宽，那么首先应该将英寸转换为像素，然后必须将width256计算为(int)Math.round(widthpx/units.default_character_width*256f)。

import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.util.Units;

class ExcelSetColumnWidth {

 public static void main(String[] args) throws Exception {

  try (Workbook workbook = new XSSFWorkbook(); 
       FileOutputStream fileout = new FileOutputStream("Excel.xlsx") ) {
   Sheet sheet = workbook.createSheet();
   int widthExcel = 10;
   int width256 = (int)Math.round((widthExcel*Units.DEFAULT_CHARACTER_WIDTH+5f)/Units.DEFAULT_CHARACTER_WIDTH*256f);
   System.out.println(width256);
   sheet.setColumnWidth(0, width256);
   sheet.createRow(0).createCell(0).setCellValue("1234567890"); // Excel shows column width as 10 using default font Calibri 11

   float widthInch = 1f;
   float widthPx = widthInch * Units.PIXEL_DPI;
   width256 = (int)Math.round(widthPx/Units.DEFAULT_CHARACTER_WIDTH*256f);
   System.out.println(width256);
   sheet.setColumnWidth(1, width256);
   System.out.println(sheet.getColumnWidthInPixels(1)); // should be round 96 pixels for an inch
   sheet.createRow(1).createCell(1).setCellValue("1 inch width"); // column is 1 inch width

   workbook.write(fileout);
  }

 }
}