public void FastExcelXlsx()
{
using var fastExcel = new FastExcel.FastExcel(new FileInfo(file), true);
// Read the rows using worksheet name
var worksheet = fastExcel.Worksheets.First();
worksheet.Read();
foreach (var row in worksheet.Rows)
{
foreach (var cell in row.Cells)
{
var val = cell.Value;
}
}
}
public void RkiExport_ValidQuery_CreatesExcel()
{
var tempExcel = new FileInfo(Path.Combine(TemporaryDirectoryToStoreTestData, "LaboratoryExport.xlsx"));
var controller = CreateController();
var result = controller.RkiExport(new FromToQueryWithAdjustment {
From = DateTime.Now.AddYears(-100), To = DateTime.Now
});
var fileResult = result.Should().BeOfType <FileContentResult>().And.Subject.As <FileContentResult>();
fileResult.FileContents.Length.Should().BeGreaterOrEqualTo(10);
File.WriteAllBytes(tempExcel.FullName, fileResult.FileContents);
using (var fastExcel = new FastExcel.FastExcel(tempExcel))
{
fastExcel.Worksheets.Length.Should().Be(1);
}
}
