Skip to main content
New Participant
September 20, 2010
Question

Create a form to search excel spreadsheet

  • September 20, 2010
  • 2 replies
  • 2989 views

I need help developing a web application, “Targeted Zip Codes” - will allow people to enter a zip code to see if it is in a targeted location.  I created a form on my homepage with a text box and submit button.  The targeted zip codes are saved in an excel spreadsheet. The web page is a html, and all files are saved in the host directory.

Example

Step 1: Enter zip code: 78221

Step 2: Click the submit button

Step 3: Search "excel spreadsheet to see if 78221 is on it,

Step 4: If zip code is on spreadsheet, then display text “child lives in targeted area”, or

            If zip code is not on spreadsheet, then display text” child does not live in targeted area. 

This topic has been closed for replies.

2 replies

September 20, 2010

It can be done with static html alone. You do not need a database or any server side scripting to acheive your result. Use excel data as spry dataset and then use spry filtereing. You might have to do a little find/replace to make xml syntax out of excel document that will be read by spry dataset.

http://labs.adobe.com/technologies/spry/samples/data_region/SuggestSample.html

Participating Frequently
September 20, 2010

Ah, very true.


Participating Frequently
September 20, 2010

1) Some sort of server side scripting will be required to do this. It can not be accomplished with html alone.

2) An Excel sheet is a bad way to store data for searching, especially in a web app. Use a real database.