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