private XlsSheetData ReadSheet(IExcelDataReader reader)
{
var cols = new List <XlsColumnData>();
var rows = new List <XlsRowData>();
var sheet = new XlsSheetData()
{
SheetName = reader.Name,
Columns = cols,
Rows = rows
};
//var header = reader.HeaderFooter;
var count = reader.FieldCount;
for (var col = 0; col < count; col++)
{
var data = typeof(object);
var name = col.ToString();
cols.Add(new XlsColumnData()
{
Name = name,
DataType = data
});
}
while (reader.Read())
{
var row = new XlsRowData();
var cells = new object[count];
for (var col = 0; col < count; col++)
{
cells[col] = reader.GetValue(col);
}
row.Cells = cells;
rows.Add(row);
}
return(sheet);
}
public CartoPlaceSheetData(XlsSheetData sheet)
{
_sheet = sheet;
IndexColumns();
}
public bool IsSelected(XlsSheetData sheet)
{
return(String.Compare(sheet.SheetName, SelectedSheet, true) == 0);
}
