Hi. I have XML data that I want to be more user-friendly when its
opened in excel. The user can create a web Query which will return the
xml to them - ( pointing to the URL with the XML information)- and
they can refresh the query each time they open the document in excel.
Unfortunately- they have to format the data in excel manually. I
wanted to associate an inline schema with the data to format the date
cells, number cells etc. but the schema is not recognised in Excel.
I have been just trying to get excel to recognise an inline schema- is
this possible in the Excel?
Any information regarding this would be very helpful as I'm trying to
research which would be the best way to implement this - and an inline
schema seems the most straightforward.