Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort by color: Is there an easy way to sort columns or rows in EX | Excel Worksheet Functions | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Sort from SQL view does not sort in EXCEL | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |