Feed data using XML

hi Xcelsius gurus,

I need some advice on my scenario, we are building a dashboard off the data thats in the excel embedded on the xcelsius. The data is about 2700 rows, and we have 6 tabs.

Since the client has got some database issue we are asked to pull the data manually and use that for building the dashboard. So now with so much of data and lots of formulas and components is making things difficult.

I would like to request any of you who know about XML option i.e, to convert the excel data into XML format and call this data at the runtime in order to improve the performance.

So i know how to convert the data into XML format but i need some advice how do i go about using data connection.

Any help will be much appreciated.