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);