Automate Excel to XML process

[system]

Have a read of this post:

120×120 10.4 KB

OK, I don’t get XML… can anybody tell me in easy-to-understand terms how to accomplish this, if it’s possible at all: I have data in an excel spreadsheet that I need to display on a dashboard. The data doesn’t change very often and the users would prefer to be able to enter/change it in spreadsheet format. But I don’t want the users putting data directly into xcelsius as that would involve regenerating SWF and WAR files. So, having managed to generate XML files via aspx code for …

Contains a useful link to a web site which showed me how to create an excel map. This means that a user can update a spreadsheet as normal and save it as normal. If they also do a SAVE AS, it will send an xml version to the dashboard as well.

Debbie

---

Debbie (BOB member since 2005-03-01)