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); }