In this step you define the input cells that are used for user input in the web application.
What are the input cells? Please have a look at the 'Excel file' in the screenshot below. YELLOW CELLS will be the cells used for data input on the web application. Now check the screenshot of the web application. Here you can see that only the fields that were defined as input cells allow user input. All other cells are not accessible.
Excel file before conversion and Excel file as a web application
You can also use form controls for user input. There are two ways to create form controls, both which will be explained in more depth later on:
- Use the SpreadsheetWEB Wizard to create PSW form controls.
- Create form controls with Excel using Excel's built-in form controls.
SpreadsheetWEB can automatically convert Excel's built in form controls. Please consult the table below to confirm which of Excel's form controls SpreadsheetWEB currently supports.
SpreadsheetWEB's supported form functions.
Option to manually select a range
First, click the option button next to "Manually select a range", then click the button to right of the field in the same line.
Selecting a range of input cells
A new window called "Input Cells" will appear. Now you can select the input cells just like you can select cells in Excel. Continue by selecting a range with the mouse.
Select individual cells spread over the spreadsheet with "CTRL + LMB".
Selecting individual cells in the spreadsheet
Or simply type in the cell addresses in the form field in the dialog window. Press "Next" to continue.
This method is recommend if necessary input cells are spread all over your spreadsheet. It requires the input cells to be formatted with a specific cell color before the SpreadsheetWEB Wizard is started.
At first, all input cells need to be formatted with a specific color. In this example, yellow is used.
All input cells must be a specific color before SpreadsheetWEB wizard is started.
In the Wizard click the option button next to "Auto detect by cell colors".
Auto detect by cell colors option in the wizard
Use the colored button to choose the color you have used or alternatively use the dropper to pick the color in your Excel spreadsheet. In both cases, the colored button will change its color to the color that you have selected.
Then click the button. You will see that the color you have selected for your input cells will appear in the pallet.
If the color of the cell was red as an example, then use the dropper to pick the color in your Excel spreadsheet and the colored button turns red .
If you have accidently selected a wrong color, simply click to remove a color.
Then press "Next" to continue.
Use this method, if you want to create a static web page without any user input or if you have already defined input cells in your Excel spreadsheet using Excel form controls. SpreadsheetWEB is able to recognize the form controls combo box, check box, option button and list box and can convert these automatically. Alternatively, you can also define form controls in the next step of the SpreadsheetWEB Wizard.
Click "Next" to continue.