Project DescriptionA command line utility for refreshing Excel data, as well as a Windows service which monitors and periodically refreshes a folder of Excel files.
This project was created to help businesses that primarily use Excel for reporting, but are not yet ready to adopt SharePoint. It provides a Windows service which will periodically refresh the data connections in one or more Excel files.
Command Line Highlights:
- Support for PowerPivot cubes, OLEDB and ODBC data connections.
- Support for saving workbooks using date-naming conventions (i.e. creating archives)
Service Highlights:
- Supports parallel, prioritized refreshing of reports, with automatic archiving.
- Support for PowerPivot cubes, OLEDB and ODBC data connections.
- Supports a variety of reporting schedules (hourly, daily, day-of-week, weekly, monthy).
- Automatically bypasses Excel files that are locked (i.e. being viewed by someone) .
- Simple management console for administering the service.
For an installation and configuration guide,
click here.
For help with configuration,
click here.