Excel XML Sort by Col

[Brent E]

Good day,

I saved an Excel file as an html page and desire to be able to sort the
columns by clicking on the col headers. The headers are in row9 and data
begins in row 10 columns B:F.

When saving the Excel file as an html file, Excel generates a complex XML
file. I have a fair knowledge of html, but the XML appears difficult to weed
through.

Does anybody know what XML code to use and where to place that in order to
set sortability to each of the col headings?

Thanks,

 

[Brent E]

I found a resource that may assist those looking for similar type items
regarding XML and Excel or Access at the following links:

http://www.meadinkent.co.uk/xl_xml1.htm

http://www.w3schools.com/