BaseDirectory, excelFileName); // Load the Excel workbook and worksheet containing the pivot table with named table reference var workbook = new XLWorkbook (excelFilePath); var worksheet = workbook.