public void GetIndexFromColumnNameTest() { var streamFile = TestsHelper.GetAssemblyFile("Budget Cashflow.xlsx"); using (var cashflowExcelPkg = new ExcelPackage(streamFile)) { var expensesWSheet = cashflowExcelPkg.Workbook.Worksheets["Expenses details"]; var table = expensesWSheet.Tables["Year_budget"]; var noko = ExcelHelpers.GetAdressFromColumnName(table, "Bil"); } }