Submit
Can I save the web page as an Excel workbook?
No, there is no direct saving functionality in the resulting web page.
However, since all of the fields are contained within a HTML-form, you can submit the form to a web server and store all of the field values in a file on the web server. SpreadsheetConverter for HTML has built-in submit support.
It uses our service, and the free service is free. If you do not want to use our server, you can use a web server enabled with the FrontPage server extensions, all fields will be stored into a tab-separated file on the server.
I do not want to use FrontPage server extension, any alternatives?
You can use our free or advanced service.
If your web server supports Perl, formmail.pl is an alternative. See http://www.formmail.com/
If you use a Windows server, look at formmail.asp
http://www.sortedsites.com/software/formmail.asp
or if you prefer ASP.NET
http://notebook.arkane-systems.net/index.php/Formmail_in_ASP .NET
If you use PHP, here are some
http://www.dtheatre.com/scripts/formmail.php
http://www.hotscripts.com/Detailed/29699.html
For Java, see
http://www.hotscripts.com/Detailed/21178.html
http://www.hotscripts.com/Detailed/6177.html
and "Java Servlets Developer's Guide" published by McGraw-Hill/Osborne Media Group
http://www.java2s.com/Code/JavaDownload/HTMLFormsFromBookJav aServletsDevelopersGuide.zip
I requested a receiver code but I did not get an email with the codes.
If you entered the email address correctly - you can try a second time - then most likely AOL has decided that the email with the receiver code is spam and has deleted it.
You have to try another email address.
How do I create a submit form so that the form information goes to an email?
You can read about our submit support here
http://www.spreadsheetconverter.com/excel_form_submit_email. htm
Then, you create a form using Excel, start SpreadsheetConverter and select 'Submit'-button under 'Configure toolbar'.
The first time you add a submit button, you will have to request a receiver code, so that we know where to send the email.
The relevant section in the manual is found here:
http://www.spreadsheetconverter.com/manual/SpreadsheetConver ter%20Users%20Guide.htm#dialog_toolbar
Why do I get an email with fields with names lie p2C144?
If you name the cells in Excel, those names will be used instead of p2C144
Is there any way I can control the Name attribute of an input field?
Name the cells in Excel using the little box up to the left.
The name must start with a letter. The rest can be letter, digit and _.
These names will be used as id.
How can I collect the submitted data using Java?
SpreadsheetConverter generates a standard HTML-form.
You loop over the request parameters, either by looping over the parameters, or by using getParameter.
Use getParameter method to get form element values
For example, if you named cell A1 "firstname", you can access the first name using the formula
request.getParameter("firstname")
---
Reading data using a servlet
http://www.nakov.com/inetjava/lectures/part-3-webapps/InetJa va-3.3-HTML-Forms-and-Parameters.html
http://www.spreadsheet-converter.com:8080/servlets-examples/
http://www.jguru.com/faq/view.jsp?EID=1297854
and from the book "Java Servlets Developer's Guide" published by McGraw-Hill/Osborne Media Group
http://www.java2s.com/Code/JavaDownload/HTMLFormsFromBookJav aServletsDevelopersGuide.zip
---
Or directly inside a JSP-page. The advantage of using a JSP-page is that all you need is to copy the file to the server. Servlets may require changing a configuration file.
<%@page import="java.util.*" %>
<%
String username, password;
if(request.getParameter("firstname") == null)
username = "";
else
username = request.getParameter("firstname");
%>
The email with submitted data names the fields like p1A3, p1D3, p1E3
The email looks like this:
p1A3: 5 p1D3: 9,50 p1E3: 47,50
If you name the individual cells in Excel, these names will be used as names. Note that they must start with a letter, and only contain letters, digits and "_".
Also note that the Advanced Service sends you a snapshot of the whole form as it looked to the user.
How can I download all submitted data into Excel or a database?
If you use our Advanced Service, our server will store all submits and you can download them as a Excel table.
Login to
with user=demo, password=demo and press "Save as Excel"
You can customize the column headers.
It costs $153/year or $15/month (Dec-2006)
I want the form to be emailed to different persons depending on the value of a dropdown list.
So in other words, there isn't anything to where we can add to the excel spreadsheet that would have a down down menu with a list of email addresses and when its submitted it would get sent in conjunction with the notice to whoever would get that, also to the person or persons selected for the drop down list in the spreadsheet??
The email is always mailed to the same address, at least if you use our Advanced or Free Service.
A workaround is to mail it to the same email address, and then have a filter in the email server that looks for a value and forwards the email to the right person.
Exchange and Outlook supports filters like this.
I will need to have the submissions sent to another email address, what do I do?
Request a new receiver code for the new email address, enter it into the wizard and regenerate the web page, and then publish the new page.
How can the submitted data be emailed to me?
You have have to do the following steps:
1. Open your spreadsheet 2. Select Convert 3. Step through the wizard. 3. Press 'Configure toolbar and submit' 4. Select 'Add submit button' 5. Press 'Configure submit' 6. Press 'Request free receiver code' and enter your email address 7. Wait for the email 8. In the dialog that is still open, select 'I want to use the SpreadsheetConverter web site, here is my receiver code' 9. Enter the receiver code into the field below 8. 10. Select 'Free' or 'Advanced' 11. Press 'Ok' 12. Press 'Ok' 13. Press 'Next' and .... and 'Finish' to start the conversion. 14. Once Internet Explorer is opened, you can test, enter some values and press 'Submit' 15. Your first email arrives.
Can the submit buttom be configured to send an auto response to the person submitting the form as well as to me?
No, not directly.
However, if you named the cell in Excel where the user enters his email address "email", you can set up an auto-responder on your own email address.
