https://blog.kkomzi.net/210/page/4?et_blog
/// <summary>
/// 스프레드 컬럼별 너비를 자동조절(헤더 라벨 고려)
/// 2010-11-12 By KKOMZI : Multi Row Header 고려
/// </summary>
/// <param name="fpSheet"></param>
/// <param name="pExtWidth">추가로 확장시킬 너비</param>
public static void SetResizeColALL(SheetView fpSheet, int pExtWidth = 10)
{
int _headerRowCount = fpSheet.ColumnHeader.RowCount;
fpSheet.RowCount += _headerRowCount;
int _tmpIndex = 0;
for (int rowIdx = 0; rowIdx < _headerRowCount; rowIdx++)
{
_tmpIndex = fpSheet.RowCount - rowIdx - 1;
fpSheet.Rows[_tmpIndex].CellType = new GeneralCellType();
for (int colIdx = 0; colIdx < fpSheet.ColumnCount; colIdx++)
{
// fpSheet.SetValue(_tmpIndex, colIdx, fpSheet.Columns[colIdx].Label);
fpSheet.SetValue(_tmpIndex, colIdx, fpSheet.ColumnHeader.Cells.Get(rowIdx, colIdx).Value);
}
}
for (int k = 0; k < fpSheet.Columns.Count; k++)
{
fpSheet.Columns[k].Width = 0;
fpSheet.Columns[k].Width = Math.Max(fpSheet.ColumnHeader.Columns[k].GetPreferredWidth(), fpSheet.Columns[k].GetPreferredWidth()) + pExtWidth;
// fpSheet.Columns[k].ColWidth = fpSheet.GetPreferredColumnWidth(k, true, true, true);
}
fpSheet.RowCount -= _headerRowCount;
}