private static int GetExcelCols(ES.ExcelService es, string sessionId, int startRow, string sheetName, ES.Status[] outStatus)
{
int row = startRow;
int col = defaultCols;
while (es.GetCell(sessionId, sheetName, row, col, false, out outStatus) != null) {
col += defaultCols;
}
return col;
}
private static int GetExcelRows(ES.ExcelService es, string sessionId,string primaryKeyValue, string sheetName, ES.Status[] outStatus)
{
int row = defaultRows;
int col = ToIndex(primaryKeyValue);
while (es.GetCell(sessionId, sheetName, row, col, false, out outStatus) != null)
{
row += defaultRows;
}
return row;
}