public string FileRead_ReadSameStringKey_Read() { var inputFile = new FileInfo(Path.Combine(ResourcesPath, "SameKey.xlsx")); using var fastExcel = new FastExcel(inputFile, true); var sheet = fastExcel.Read(1); return(sheet.Name); }
public void InputFile_ReadExcelWithNullReference_ExceptionIsNull() { var inputFilePath = Path.Combine(ResourcesPath, "RouteMaster.xlsx"); var inputFile = new FileInfo(inputFilePath); var action = new Action(() => { using (var fastExcel = new FastExcel(inputFile, true)) { var worksheet = fastExcel.Read(1, 1); } }); var exception = Record.Exception(action); Assert.Null(exception); }
private string FileRead_ReadingSpecialCharactersCore_Read(FileInfo inputFile) { inputFile.Refresh(); using var fastExcel = new FastExcel(inputFile); var worksheet = fastExcel.Read("sheet1"); var rows = worksheet.Rows; foreach (var item in rows) { foreach (var cell in item.Cells) { output.WriteLine(cell.ToString()); } } var row = rows.ToArray()[1].Cells.ToArray(); Assert.Equal(TestCellRow.StringColumn1, row[0].Value); //TODO - Add tests for data-types when implemented return("Passed"); }