How to read excel data using HTML page |
How to read excel data using HTML page |
thenvk |
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 |
Darin McGrew |
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.
|
Lo-Fi Version | Time is now: 19th April 2024 - 08:49 AM |