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); }