×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Searching HTML created from Excel

Searching HTML created from Excel

Searching HTML created from Excel

(OP)

I have a client who wants to put their stock catalog on-line - although they don't plan on selling the items online.

They currently have an in-house system which stores their stock - which can export the database to excel, if they need to send an updated stock list to a client.

At present this excel spreadsheet has been converted into an HTML document and sits on the page within an iframe.

However they would like people to be able to search this document - although they are not happy with telling people to use the browser ctrl-f functionality -

Is there another way around this?

Although Excel is a drag to work with - in terms of going forward anything else for the client would create a duplication of work for them.

 

RE: Searching HTML created from Excel

Hi

Quote (RussellNiiOdartei):

At present this excel spreadsheet has been converted into an HTML document
That sounds bad.

Quote (RussellNiiOdartei):

Is there another way around this?
Export in CSV, then display/search/sort/filter/paginate the data with a server-side script. Of course, we have no information about what can be accessed/executed on their server, so this may or may not work for them.

As a quick and dirty solution, you could try some client-side solutions in JavaScript, for example Table Sorting, Filtering, Etc by Matt Kruse. ( See the Examples, there is a search-like filtering too. ) Of course, if the table is huge, better forget the client-side solutions.

Feherke.
http://free.rootshell.be/~feherke/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close