![]() |
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, |
Excel XML Sort by Col
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/ "Brent E" wrote: 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, |
All times are GMT +1. The time now is 09:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com