public void ColumnCountTime()
{
var wb = new XLWorkbook();
IXLWorksheet ws = wb.Worksheets.Add("Sheet1");
DateTime start = DateTime.Now;
ws.ColumnCount();
DateTime end = DateTime.Now;
Assert.IsTrue((end - start).TotalMilliseconds < 500);
}
private ExcelXmlConverterWorksheet LoadWorksheet(IXLWorksheet xlWorksheet)
{
var worksheet = new ExcelXmlConverterWorksheet();
var columNames = new List <string>();
for (var i = 0; i < xlWorksheet.ColumnCount(); i++)
{
columNames.Add(xlWorksheet.Rows().ElementAt(0).Cells().ElementAt(i).GetString());
}
for (var i = 1; i < xlWorksheet.RowCount(); i++)
{
worksheet.Rows.Add(LoadRow(columNames, xlWorksheet.Rows().ElementAt(i)));
}
return(worksheet);
}
