POI 边角料

sheet.setColumnHidden(*,true);隐藏列
row.setZeroHeight(true);隐藏行

隐藏行
CellReference cellReference = new CellReference(name.getRefersToFormula());
int rowNo = cellReference.getRow();
org.apache.poi.ss.usermodel.Row row = sheet.getRow(rowNo);
row.setZeroHeight(true);

原文地址:https://www.cnblogs.com/rattersnake/p/3158022.html