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.
If you do not want to build this solution yourself, SpreadsheetConverter for HTML has built-in submit support, called the Advanced Service.
Another alternative is to 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 (October - 2008)
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.
How would you go about setting up different Forms with different email addresses for Submit?
Example - Some forms would go top Bob is shipping, another to Sally in accounting and yet another to Harry in IT. Is there a way to change the email addresses locally?
You need to request one receiver code for each email address, and then have that receiver code entered in the wizard when you generate the form.
I would like my spreadsheet web page to simply close when the user clicks on the Submit button.
The solution is to the success url to a window that close itself, for example see discussion at
http://forums.devshed.com/javascript-development-115/javascr ipt-close-problem-23554.html
Create a page that only contains
and place that on your server and call it close-window.htm . Then set the success url to http://www.spreadsheetconverter.com/close-window.htm
Where can I change the e-mail of the Advanced Service to where the forms are send to?
The Advanced Service consists of two parts
1. The email looks like the web page
2. The fields are stored in a database for later retrival.
You get 1. by selecting Advanced Service in the SpreadsheetConverter wizard
You get 2. by using a recevier code for an email address that is known to SpreadsheetServer.
When we set up the Advanced Service account for you, you got one login + password. Create a new user for the second email address whose submits you want to store, request a receiver code for this second email address, enter it into the wizard, convert and publish.
I do not get the submits from the Free or Advanced Submit Service anymore, why?
Most likely, the emails are blocked by your spam filter. Note that you have at least two spam filters; one in your local email program, and one in the email server. Tell the guys who manage the email server to make sure that emails from @spreadsheet-converter.com (with an extra dash) are not blocked.
If this doesn't help, request a new receiver code for an email address on another domain, regenerate the web form with this new receiver code, and then upload the new page.
To be 100% sure no submits are lost, you should use the Advanced Submit Service since all the submits are saved into our database. Thus, you can always retrieve them later. In order to make this work, the email address you used for creating the receiver code must have an account in the Advanced Submit Service.
Yahoo Mail suggest that you set up a filter in Yahoo! Mail to ensure that they get your email messages in their Inbox. Yahoo! Mail users may find more information regarding filters at this page:
