private void AddHeaderColumns(int startCol,int rowNum)
{
if (ColumnsHeaders.Count != 0)
{
if (mSheet == null)
return;
var row = mSheet.GetRow(rowNum);
if (row == null)
row = mSheet.CreateRow(rowNum);
for (int i = 0; i <= startCol + ColumnsHeaders.ToArray().Length; i++)
{
var cell = row.GetCell(i);
if (cell == null)
row.CreateCell(i);
}
CellRangeAddress range = new CellRangeAddress(StartRow == 0
? 0
: StartRow, StartRow == 0
? 0
: StartRow, startCol, startCol + ColumnsHeaders.ToArray().Length - 1);
CellWalk cw = new CellWalk(mSheet, range);
cw.SetTraverseEmptyCells(true);
CellInserter ci = new CellInserter(new List<object>(ColumnsHeaders));
cw.Traverse(ci);
}
}