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.
Insert code from sample stored in SVN here |
SalesCommissionReport-YTD.xlsx
SalesCommissionReport-LastYear.xlsx