poi操作excel行自適應(yīng)高度

1、import java.text.SimpleDateFormat;import java.util.Date;import mons.lang3.StringUtils;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFDataFormat;import org.apache.poi.hssf.usermodel.HSSFDateUtil;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi

2、.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.util.CellRangeAddress;excel行自適應(yīng)高度author lwversion 2019 年8月 27 日 下午 1:59:27*/public class AutoRowHeightUtil自適應(yīng)excel行高author lwdate 2019 年8月 27 日 上午 10:27:33para

3、mcell歹！Jparammargin字體邊距public static void autoRowHeight(HSSFCell cell/*/shortmargin ) if (cell = null ) return ;String cellVal = getStringCellValue (cell ); if (StringUtils. isBlank (cellVal )return)HSSFRow row = cell .getRow();HSSFWorkbook workbook =row .getSheet().getWorkbook();short charHeight =c

4、ell .getCellStyle().getFont( workbook ).getFontHeightInPoi nts();float charPx = charHeight / (float )72 * (float )96; / 字體像素float cellWidthPx = getCellWidth (cell ); / 寬度像素 int charLength = cellVal .length(); /字符長(zhǎng)度int charInCell = ( int )( cellWidthPx / charPx ); / 每 個(gè)列(包括合并的列)的字?jǐn)?shù)/在指定寬度的列中的字符展示行數(shù)int

5、 rowNum= charLength / charInCell + (charLength % charInCell 0 ? 1 : 0);/自適應(yīng)之后的行高點(diǎn)數(shù)short cellHeightPx = ( short ) ( short ) rowNum) * (charHeight + margin );row .setHeightInPoints( cellHeightPx );)/*自適應(yīng)excel行高author lwdate 2019 年8月 27 日 上午 10:27:33*/paramcell歹！Jprivate static String getStringCellValu

6、e(Cellcell )(switch ( cell .getCellType()(case HSSFCell. CELL_TYPE_FORMULAif (cell .getCellStyle().getDataFormat()HSSFDataFormat. getBuiltinFormat (yyyy-MM-dd) (SimpleDateFormatSimpleDateFormat( yyyy-MM-dd);sdf = newreturnsdf .format(HSSFDateUtil. getJavaDate (cell .getNumericCellV alue();returncell

7、 .getCellFormula();case HSSFCell. CELL_TYPE_STRING returncell .getStringCellValue();case HSSFCell. CELL_TYPE_NUMERI:Cif(HSSFDateUtil. isCellDateFormatted ( cell ) StringdateStr =;int style = cell .getCellStyle().getDataFormat();Datedate = cell .getDateCellValue();/對(duì)不同格式的日期類型做不同的輸出，與單 元格格式保持一致switch

8、( style ) case 178: dateStr = new SimpleDateFormat( yyyy 年M月d日).format( date ); break ;case 14:dateStr = new SimpleDateFormat( yyyy-MM-dd ).format( date );break ; case 179:dateStr = newSimpleDateFormat( yyyy/MM/dd HH:mm ).format( date ); break ;case 181: dateStr = newSimpleDateFormat(yyyy/MM/dd HH:m

9、m a ).format( date );break ;case 22:dateStr = new SimpleDateFormat( yyyy/MM/dd HH:mm:ss ).format( date );break ;default : break ;return dateStr ;elsecell .setCellType(Cell. CELL_TYPE_STRING return cell .getStringCellValue();case HSSFCell. CELL_TYPE_BOOLEANreturn cell .getBooleanCellValue() ? TRUE: F

10、ALSE; default :return ;/*/獲取單元格及合并單元格的寬度author lwdate 2019 年6月 28 日 下午 1:58:42paramcell 單元格private staticfloat getCellWidth(HSSFCellcell )return單元格及合并單元格的寬度（像素）)=cell .getSheet();sheetif (cell = null return 0; HSSFSheetint rowindex = cell .getRowIndex();int columnindex = cell .getColumnindex(); floa

11、t width =sheet .getColumnWidthinPixels( columnindex );boolean isPartOfRegion = false ;intfirstColumn= 0;intlastColumn = 0;int firstRow = 0;int lastRow = 0;int sheetMergeCount = sheet .getNumMergedRegions();for ( int i = 0; i sheetMergeCount ; i +)(CellRangeAddressca =sheet .getMergedRegion( i );firstColumn = ca.getFirstColumn();lastColumn = ca.getLastColumn();firstRow = ca.getFirstRow();lastRow = ca.getLastRow();if (rowindex = firstRow & rowindex = lastRow ) (if ( columnindex = firstColumn & columnindex = la