Intro
An example of a report created with ExcelWriter that compares previous year and year-to-date sales data for a sales team.The source Workbook contains a listing of Employees for the fictional company AdventureWorks. The actual data is marked with two Named Ranges, "EmployeesHeadings" and "EmployeesData", which will make it easier to import using ExcelWriter. This data is then used to populate a DataGrid, which will be displayed below.
Code
Downloads
- Template file - SalesCommission.xlsx
- Output file for YTD - SalesCommissionReport-YTD.xlsx
- Output file for Last Year - SalesCommissionReport-LastYear.xlsx