123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 |
- using ExcelORM;
- namespace ExcelORMTests;
- public class DynamicReaderTests
- {
- private const string RegularFile = "testFiles/first.xlsx";
- private const string DifferentTypesFile = "testFiles/differentTypes.xlsx";
- private const string MultipleSheetsFile = "testFiles/multipleSheets.xlsx";
- private const string DifficultFile = "testFiles/dynamicDifficult.xlsx";
- [Fact]
- public void Read()
- {
- var reader = new ExcelDynamicReader(RegularFile);
- var results = reader.Read("Sheet 1").ToArray();
- Assert.NotEmpty(results);
- }
- [Fact]
- public void ReadDifferentTypes()
- {
- var reader = new ExcelDynamicReader(DifferentTypesFile);
- var results = reader.Read().ToArray();
- Assert.NotEmpty(results);
- var first = results.First();
- Assert.Equal(typeof(string), first[0].Type);
- Assert.Equal(typeof(DateTime?), first[1].Type);
- Assert.Equal(typeof(TimeSpan?), first[2].Type);
- Assert.Equal(typeof(double?), first[3].Type);
- Assert.Equal(typeof(double?), first[4].Type);
- }
- [Fact]
- public void ReadAll()
- {
- var reader = new ExcelDynamicReader(MultipleSheetsFile);
- var results = reader.ReadAll().ToArray();
- Assert.NotEmpty(results);
- }
- [Fact]
- public void ReadDifficult()
- {
- var reader = new ExcelDynamicReader(DifficultFile);
- var results = reader.Read().ToArray();
- Assert.NotEmpty(results);
- Assert.Equal(results.First().Count, results.Last().Count);
- }
- }
|