The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> How to read excel data using HTML page
thenvk
post Nov 1 2010, 05:57 AM
Post #1





Group: Members
Posts: 1
Joined: 1-November 10
Member No.: 13,053



I am working on a simple tool for my office.We have a very huge database with 5000 tables. All the tables, Columns and their attributes are stored in to excel sheet.

Tool I am designing is for mapping between front end and back end values. Now I will use an image (front end screen of our application) , when user clicks it, I need the HTML to access the excel sheet and display the back end field,the name of tables it can be found in and other data related to that field

Simply,I want to pull data from excel and display them differently for each different click. I want to pass the parameter on click and filter a column in excel with it and display the entire set of sheet with this criteria. Is this possible? or am I expecting too much
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Darin McGrew
post Nov 1 2010, 12:39 PM
Post #2


WDG Member
********

Group: Root Admin
Posts: 8,365
Joined: 4-August 06
From: Mountain View, CA
Member No.: 3



You'll need a server-side (e.g., CGI, PHP, ASP) program to process HTML form data, access the MS Excel data, and generate an HTML document in response. HTML alone can't do the job.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 19th April 2024 - 08:49 AM