public void getSubCategoryModelFromExcel()
{
//var resourcePath = "ExcelClient.Tests.TestData.Transactions.xlxs";
var resourcePath = "ExcelClient.Tests.TestData.Categories.xlsx";
var assembly = Assembly.GetExecutingAssembly();
Stream resourceAsStream = assembly.GetManifestResourceStream(resourcePath);
//var file = "Transactions.xlxs";
var file = "Categories.xlsx";
var savedFilePath = Path.Combine(Directory.GetCurrentDirectory() + @"..\..\..\..\TestData\", file);
var name = Path.GetFileNameWithoutExtension(savedFilePath);
var fi = new FileInfo(savedFilePath);
ExcelPackage ep = new ExcelPackage(new FileInfo(savedFilePath));
ExcelPackage ep1 = new ExcelPackage(resourceAsStream);
//ExcelPackage ep = new ExcelPackage(new FileInfo(resourcePath));
ExcelWorksheet workSheet = ep.Workbook.Worksheets.FirstOrDefault();
ExcelWorksheet workSheet1 = ep1.Workbook.Worksheets.FirstOrDefault();
var json = ExcelServices.GetJsonFromTable(workSheet);
var json1 = ExcelServices.GetJsonFromTable(workSheet1);
var jarray = JArray.Parse(json1);
List <SubCategory> subcategories = new List <SubCategory>();
foreach (var subCategory in jarray)
{
subcategories.Add(JsonServices.GetSubCategory(subCategory));
}
var table = workSheet.Tables.FirstOrDefault();
json.Should().NotBeNull();
}