public List <SetOptionsEntry[]> GetSetOptionsEntryList(bool AllowBinary)
{
List <SetOptionsEntry[]> SetOptionsEntries = new List <SetOptionsEntry[]>();
foreach (ISheet TempSheet in Workbook)
{
// Get the headers and first record.
if (TempSheet.FirstRowNum >= 0)
{
IRow HeaderRow = TempSheet.GetRow(TempSheet.FirstRowNum);
IRow RecordRow = TempSheet.GetRow(TempSheet.FirstRowNum + 1);
if (HeaderRow != null && RecordRow != null)
{
SetOptionsEntries.Add(new SetOptionsEntry[HeaderRow.LastCellNum - HeaderRow.FirstCellNum]);
int y = HeaderRow.LastCellNum - HeaderRow.FirstCellNum;
for (int x = 0; x < y; x++)
{
ICell TempHeaderCell = HeaderRow.GetCell(HeaderRow.FirstCellNum + x);
ICell TempRecordCell = RecordRow.GetCell(RecordRow.FirstCellNum + x);
string HeaderName = (TempHeaderCell == null ? "" : TempHeaderCell.StringCellValue);
JB64Value Result;
if (TempRecordCell == null)
{
Result = new JB64Value("");
}
else if (TempRecordCell.CellType == CellType.Boolean)
{
Result = new JB64Value(TempRecordCell.BooleanCellValue);
}
else if (TempRecordCell.CellType == CellType.Numeric)
{
Result = new JB64Value(TempRecordCell.NumericCellValue);
}
else
{
Result = new JB64Value(TempRecordCell.StringCellValue);
}
SetOptionsEntries[SetOptionsEntries.Count - 1][x] = new SetOptionsEntry(HeaderName, Result.Type, Result, true);
}
}
}
}
return(SetOptionsEntries);
}
public System.Collections.Specialized.StringCollection GetSheetNames()
{
System.Collections.Specialized.StringCollection Result = new System.Collections.Specialized.StringCollection();
foreach (ISheet TempSheet in Workbook)
{
if (TempSheet.FirstRowNum >= 0)
{
IRow HeaderRow = TempSheet.GetRow(TempSheet.FirstRowNum);
IRow RecordRow = TempSheet.GetRow(TempSheet.FirstRowNum + 1);
if (HeaderRow != null && RecordRow != null)
{
Result.Add(TempSheet.SheetName);
}
}
}
return(Result);
}