Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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,
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 74
Default 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,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort by color: Is there an easy way to sort columns or rows in EX MGP Excel Worksheet Functions 5 August 16th 08 11:28 AM
sort function for dates does not sort properly in Office 2007 Exc. Rosalie Excel Worksheet Functions 1 November 22nd 07 10:25 PM
Sort from SQL view does not sort in EXCEL Pat M - City of Reno Excel Discussion (Misc queries) 0 August 31st 07 07:38 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"