Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terri and Rob
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default 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.


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
Insert & link a graphic file in Excel 2003 -- updatable pictures! ODI Excel Discussion (Misc queries) 7 November 14th 05 02:36 PM
Reflecting info between an excel file and a word one or two excel file. Starriol Excel Worksheet Functions 0 November 3rd 05 01:49 PM
Reflecting info between an excel file and a word one or two excel file. Starriol Links and Linking in Excel 0 November 3rd 05 01:49 PM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 July 1st 05 03:04 AM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM


All times are GMT +1. The time now is 08:09 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"