Skip to Content

Hi All,

There is no standard functionality available for importing excel in the dashboard at preview time. So I have done some workaround for the same. Hope you like it.

Please follow the steps to achieve this thing.

Step : 1 – Create your excel file

/wp-content/uploads/2015/01/1_617743.jpg

Step : 2 – Now convert your excel file into XML, as we have to use XML connection in Dashboard.

     –     You can achieve this by 2 methods.

          a) From any online editor which can covert your excel into XML

          b) You can create macro and convert your excel into XML

2.JPG

Step : 3 – Open Dashboard / Xcelsius, add XML data connection – enable load, give the name as sheet name (in our example – abc)  and define range in embedded excel of Xcelsius. The range is dependent on the no of records of imported excel.

/wp-content/uploads/2015/01/3_617751.jpg

Step: 4 – Add one textbox to give the path of the XML file

/wp-content/uploads/2015/01/4_617752.jpg

Step: 5 – Add one push button in dashboard – Upload

/wp-content/uploads/2015/01/5_617753.jpg

Step: 6 – Refresh the XML connection on trigger cell of destination of push button

/wp-content/uploads/2015/01/6_617754.jpg

Step: 7 – Run the dashboard and import the url of your xml file and click on upload button. You can see the Excel’s data in the dashboard.

/wp-content/uploads/2015/01/7_617755.jpg

Step:8 – Now, whenever you want any changes in the Excel, do the changes in XML itself,if format will remain same or do the changes in Excel, convert it in XML and upload the same like mentioned in Step:7. For example I have changed abc’s values to 30 in XML and you can see the updated changes in the dashboard instantly.

8.JPG

So by this approach, you can do the changes in the data source (Excel) and see the changes instantly. Here for example purpose only, I have used spreadsheet. But for better analysis, you can create a dashboard on static excel and same excel can change the in future so one can directly upload the same file in dashboard and see the changes.

I hope you like this blog. Please share your comments.

Regards,

Niket Talati

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply