public void SH002_SheetNames(string name, int numberOfSheets)
{
FileInfo sourceXlsx = new FileInfo(Path.Combine(TestUtil.SourceDir.FullName, name));
using (SpreadsheetDocument sDoc = SpreadsheetDocument.Open(sourceXlsx.FullName, true))
{
var sheetNames = SmlDataRetriever.SheetNames(sDoc);
Assert.Equal(numberOfSheets, sheetNames.Length);
}
}
public void SH002_SheetNames(string name, int numberOfSheets)
{
var sourceDir = new DirectoryInfo("../../../../TestFiles/");
var sourceXlsx = new FileInfo(Path.Combine(sourceDir.FullName, name));
using var sDoc = SpreadsheetDocument.Open(sourceXlsx.FullName, false);
var sheetNames = SmlDataRetriever.SheetNames(sDoc);
Assert.Equal(numberOfSheets, sheetNames.Length);
}
public string[] GetSheetNames(string filePath)
{
var sheets = SmlDataRetriever.SheetNames(filePath);
return(sheets);
}