Dynamically Update Xcelsius Dashboard from Excel Data

I am designing an Xcelsius dashboard that will开发者_如何转开发 need to be updated once a week with data that only exists in an Excel Pivot table. I have been able to create dynamic dashboards in the past by tying the dashboard to an XML file or database. I am looking for suggestion on how to dynamically read an Excel File from and Xcelsius dashboard.

Try Centigon Solutions CSV Connector.

Actually your best bet is to save the Excel file as XML and read it back using the XML features via Xcelsius and Excel. If you need some help there are a number of videos that can walk you through the process at both MyXcelsius and Datapig Technologies.

You can make a macro in the Excel File that automatically creates the xml file an saves it in the path where the Xcelsisus File reads it from. You will have to program it once and never worry for it again, and its reausable for every dashboard you make.