Dynamically Update Xcelsius Dashboard from Excel Data

Question

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.

Answer 1

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.