Thursday, April 19, 2012

jQuery to create superior Excel-like tables on webpage

There is a project need to create an excel like spreadsheet on a webpage but with superior predictive capabilities. Like typing postal codes to retrieve company names.

jQuery can do just that.

We just need to maintain a separate table of the company name with the corresponding address and postal code. So that when someone types in the company name, we can use the jquery's ajax capabilities to pick up the corresponding postal code and show it in the next column. Street name and unit number will show in the next two columns.

If the company name is not found, then the user have to type in the postal code, street name and unit number for the first time.

Information on creating an simple excel table using javascript jquery can be found below:
http://stackoverflow.com/questions/2185636/excel-like-application-in-javascript

No comments:

Post a Comment