private void WriteRowValues(object[] values, int rowNum, int startCol)
{
if (mSheet == null)
{
return;
}
var row = mSheet.GetRow(rowNum);
if (row == null)
{
row = mSheet.CreateRow(rowNum);
}
for (int i = 0; i <= startCol + values.Length; i++)
{
var cell = row.GetCell(i);
if (cell == null)
{
row.CreateCell(i);
}
}
CellRangeAddress range = new CellRangeAddress(rowNum, rowNum, startCol, startCol + values.Length - 1);
CellWalk cw = new CellWalk(mSheet, range);
cw.SetTraverseEmptyCells(true);
CellInserter ci = new CellInserter(new List <object>(values));
cw.Traverse(ci);
}
private void WriteRowValues(object[] values, int rowNum, int startCol)
{
if (mSheet == null)
{
return;
}
CellRangeAddress range = new CellRangeAddress(rowNum, rowNum, startCol, startCol + values.Length - 1);
CellWalk cw = new CellWalk(mSheet, range);
cw.SetTraverseEmptyCells(true);
CellInserter ci = new CellInserter(new List <object>(values));
cw.Traverse(ci);
}
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);
}
}
private void WriteRowValues( object[] values, int rowNum, int startCol )
{
if( mSheet == null )
return;
CellRangeAddress range = new CellRangeAddress( rowNum, rowNum, startCol, startCol + values.Length - 1 );
CellWalk cw = new CellWalk( mSheet, range );
cw.SetTraverseEmptyCells( true );
CellInserter ci = new CellInserter( new List<object>( values ) );
cw.Traverse( ci );
}
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);
}
}
private void WriteRowValues(object[] values, int rowNum, int startCol)
{
if (mSheet == null)
return;
if (ColumnsHeaders.Count != 0)
{
rowNum++;
}
var row = mSheet.GetRow(rowNum);
if (row == null)
row = mSheet.CreateRow(rowNum);
for (int i = 0; i <= startCol + values.Length; i++) {
var cell = row.GetCell(i);
if (cell == null)
row.CreateCell(i);
}
CellRangeAddress range = new CellRangeAddress(rowNum, rowNum, startCol, startCol + values.Length - 1);
CellWalk cw = new CellWalk(mSheet, range);
cw.SetTraverseEmptyCells(true);
CellInserter ci = new CellInserter(new List<object>(values));
cw.Traverse(ci);
}