public static IEnumerable <string> GetSheetNames(this Stream stream)
{
var archive = new ExcelOpenXmlZip(stream);
foreach (var item in ExcelOpenXmlSheetReader.GetWorkbookRels(archive.Entries))
{
yield return(item.Name);
}
}
public static List <string> GetSheetNames(this Stream stream)
{
var archive = new ExcelOpenXmlZip(stream);
return(ExcelOpenXmlSheetReader.GetWorkbookRels(archive.Entries).Select(s => s.Name).ToList());
}