공유자료방

https://hengs.tistory.com/5 https://hengs.tistory.com/5

https://helpcentral.componentone.com/NetHelp/SpreadNet8/ASP2/spweb-HeaderMulti.html

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