public void TestRead()
{
var parser = new ReportDtoParser();
var file = GetSampleFile("Fillreport.xlsx");
using (var stream = File.OpenRead(file)) {
var result = parser.Read(stream);
Assert.NotNull(result);
Assert.NotEmpty(result);
Assert.Equal(16, result.Count());
Assert.True(parser.ParseResult.IsValid);
}
}
public void TestTryReadSheet()
{
var parser = new ReportDtoParser();
var file = GetSampleFile("Fillreport.xlsx");
bool hasData = false;
using (var reader = ExcelReaderFactory.CreateReader(File.OpenRead(file))) {
do
{
if (parser.TryReadSheet(reader, out var values))
{
Assert.NotEmpty(values);
hasData = true;
}
} while (reader.NextResult());
}
Assert.True(hasData);
}