private object[] RowValues(int rowNum, int startCol, int numberOfCols)
{
if (mSheet == null)
return null;
if (numberOfCols == 1) {
IRow row = mSheet.GetRow(rowNum);
ICell cell = HSSFCellUtil.GetCell(row, startCol);
return new object[] {NPOIUtils.GetCellValue(cell)};
}
else {
CellRangeAddress range = new CellRangeAddress(rowNum, rowNum, startCol, startCol + numberOfCols - 1);
CellWalk cw = new CellWalk(mSheet, range);
cw.SetTraverseEmptyCells(true);
CellExtractor ce = new CellExtractor();
cw.Traverse(ce);
return ce.CellValues;
}
}