public void Test1()
{
const string sheetName = "Data Dictionary";
const string filename =
//@"C:\local\documents\OneDrive - Knex\MortgageDataPointsStructuresEventsAndMilestones.xlsx";
@"worksheet.xlsx";
using (var stream = File.Open(filename, FileMode.Open, FileAccess.Read))
{
using (var effectiveBook = EffectiveWorkbook.Open(stream))
{
var sheets = effectiveBook.Sheets;
Assert.NotNull(sheets);
Assert.True(sheets.Count() > 1);
var dataDictionarySheet = sheets[sheetName];
Assert.NotNull(dataDictionarySheet);
Assert.Equal(3u, ((IIndexedSpreadsheet)dataDictionarySheet).Index);
var firstSheet = sheets.ElementAt(0);
Assert.NotNull(firstSheet);
Assert.Equal("Sheet1", firstSheet.Name);
var topLeftCell = dataDictionarySheet.Cells["A1"];
//Assert.NotNull(topLeftCell);
//Assert.Equal("Unique ID", topLeftCell.ValueText);
foreach (var sheet in sheets)
{
var rows = sheet.Rows;
Assert.NotNull(rows);
if (rows.Any())
{
var firstRow = rows.First();
Assert.NotNull(firstRow);
Assert.NotEmpty(firstRow);
}
foreach (var row in rows)
{
foreach (var cell in row)
{
Assert.NotNull(cell);
string message = $"{sheet.Name} {cell.ValueText}";
//Debug.WriteLine(message);
}
}
}
}
}
}
public void TestOpen()
{
const string filename =
//@"C:\local\documents\OneDrive - Knex\MortgageDataPointsStructuresEventsAndMilestones.xlsx";
@"worksheet.xlsx";
using (var workbook = new EffectiveWorkbook(filename))
{
Assert.NotNull(workbook);
Assert.NotNull(workbook.Sheets);
}
}
