How do I create a web form that uses a FrontPage server extensions enabled web server?

When you create a form to be used by a web server that supports FrontPage Server Extensions (for example Microsoft IIS or Apache), follow these steps:

  1. Create the Excel spreadsheet.
  2. Name the input and output cells in Excel (This step is not mandatory, but makes the result easier to understand).
  3. Create the web page using SpreadsheetConverter.
  4. Start FrontPage.
  5. Load the web page created in step 3 into FrontPage.
  6. Put the cursor somewhere in the form near the input fields, right-click, and select ‘Form properties’.
  7. The minimum you must do is to select ‘Send to’ and enter the email address.
  8. Save the web page.
  9. Publish the web page onto your web server.

How can I secure my SpreadsheetConverter calculator?

Place it on an HTTPS:-site and password protect it. How to password protect depends on which type of webserver you are using.

How do I enable compression on Apache?

By enabling compression, the amount of data you download will be 1/10. All modern browser support compression.

http://www.schroepl.net/projekte/mod_gzip/index.htm

How make users login before using my calculator?

If you are using SpreadsheetConverter/ExcelEverywhere to HTML and want your users to login before they can use the calculator, the solution is to use the authentication of the web server to handle this. Both Internet Information Server (IIS) and Apache handles this.

If you use IIS, you can create normal Windows users and deny guest access to your web server.

If you use Apache, here is an article describing it: Protect Web sites with Apache Server’s HTTP authentication system. Alternatively, you can program the authentication yourself. Secure your Web pages with custom authentication Or, you can use ASP.NET’s form authentication. A simple solution is to store name + password in web.config. ASP.NET Form Authenticiation tutorial The SpreadsheetServer also handles logins.

Try this Excel add-in now!

Click on Download to install and test this Excel add-in for Windows.

Click on Upload to let us convert a spreadsheet for you for free.