View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brent E Brent E is offline
external usenet poster
 
Posts: 74
Default Excel XML Sort by Col

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,