ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting Columns on HTML file created in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/57873-sorting-columns-html-file-created-excel.html)

Terri and Rob

Sorting Columns on HTML file created in Excel
 
Hi.. I'm not sure if I'm just searching for the wrong words, but can't
find the answer to this..

I've created an excel file, about 15 columns.. In excel, I can sort the
columns easily, but, I've saved the file as HTML now. How can I make it
that those columns can still be sortable on the internet? Is there
special code I need to put somewhere? I've seen javascript codes that
can do this, but I would like to do it all via excel if possible.
Any help appreciated!

Thanks,
--
Rob

David McRitchie

Sorting Columns on HTML file created in Excel
 
Hi Terri and Rob,
You could include the JavaScript (Bookmarklet) within your HTML code,
keep in mind that it will be a text only sort..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Terri and Rob" wrote ...
Hi.. I'm not sure if I'm just searching for the wrong words, but can't
find the answer to this..

I've created an excel file, about 15 columns.. In excel, I can sort the
columns easily, but, I've saved the file as HTML now. How can I make it
that those columns can still be sortable on the internet? Is there
special code I need to put somewhere? I've seen javascript codes that
can do this, but I would like to do it all via excel if possible.
Any help appreciated!

Thanks,
--
Rob




David McRitchie

Sorting Columns on HTML file created in Excel
 
an example of the sort used within a webpage can be seen in
Bookmarklets (JavaScript Favelets)
http://www.mvps.org/dmcritchie/ie/bookmarklets.htm
as noted it would not work from Internet Explorer except as included in the HTML.
In Firefox you can use a bookmarklet as a bookmark or as included in the HTML.




All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com