HTML Form and copy data into excel spreadsheet. |
HTML Form and copy data into excel spreadsheet. |
sunshine076 |
Jun 4 2011, 10:22 AM
Post
#1
|
Group: Members Posts: 1 Joined: 4-June 11 Member No.: 14,689 |
I have been working on this piece of code for a few days. It is very simple to use however what I want it to do is once the user presses the Submit Button it will store the data in each textbox in an excel spreadsheet while keeping a running total. Can this be done? Here is my code:
<html> <onclick a ref="mainpage.html"> <body style="background-color:##F5F6CE"></style> <form action="Mainpage.html" method="post" target="_blank"> <H2 align=center><font color=#8A084B>Voice of the President</font></align></H2> <H2 align=center><font color=#8A084B>Submittal Form</font></align></H2> <form action="/html/tags/html_form_tag_action.cfm" method="get" target="_blank"> <font color=#8A084B size="5">First name:</font> <br /> <input type="text" name="first_name" value="" maxlength="100" /> <br /> <font color=#8A084B size="5">Last name:</font> <br /> <input type="text" name="clock_num" value="" maxlength="100" /> <br /> <font color=#8A084B size="5">Clock Number:</font> <br /> <input type="text" name="last_name" value="" maxlength="100" /> <br /> <font color=#8A084B size="5">Department:</font> <br /> <input type="text" name="dept" value="" maxlength="100" /> <br /> <font color=#8A084B size="5">Date:</font> <br /> <input type="text" name="T_Date" value="" maxlength="100" /> <br /> <font color=#8A084B size="5">Time:</font> <br /> <input type="text" name="T_Time" value="" maxlength="100" /> <br /> <font color=#8A084B size="5">Comments:</font> <br /> <textarea rows="8" cols="40" name="comments"></textarea> <br></br> <input type="submit" value="Submit" /> <input type="reset" value="Reset" /> <input type="submit"value="Home" ACTION="index.html" /> </form> </BODY> </HTML> |
Frederiek |
Jun 5 2011, 03:06 AM
Post
#2
|
Programming Fanatic Group: Members Posts: 5,146 Joined: 23-August 06 From: Europe Member No.: 9 |
Search the web for "submit form to excel".
|
Brian Chandler |
Jun 5 2011, 07:43 AM
Post
#3
|
Jocular coder Group: Members Posts: 2,460 Joined: 31-August 06 Member No.: 43 |
You might also ask if this is really what you want to do. Why not save the information in a database, which you can display as you wish.
Spreadsheets are basically fragile. If you mess something up on this collected data, you could lose it all. |
Lo-Fi Version | Time is now: 27th April 2024 - 10:44 PM |