List of applications currently stored in your account
When you run the SpreadsheetWEB Wizard, the final step offers the option for the Wizard to upload your Excel spreadsheet to our server and automatically create a web application for you.
You can find these web applications under the Applications tab in the SpreadsheetWEB Control Panel.
All applications are listed in a table. If you have more web applications than can be listed on a single page, the table will be spread out over several pages.
An example Web Applications list in SpreadsheetWEB Control Panel
An explanation of symbols and buttons seen on this page can be found below:
| Applications | Displays the name of the application as a link. Upon click, application will open in a new browser window |
 |
Download the Excel file associated with the applications |
 |
Shows the web address (URL) of a web application |
 |
Shows WSDL location of a web service |
 |
Edit settings of an application |
 |
Open data tab |
| Creation Date | Creation date of an application |
| Online | Shows whether an application is online of offline: : online - application is published  : offline – application is offline, cannot be accessed over the internet |
| Access | : everybody can access the application  : access restricted to registered users |
| Group | Name of the group application is associated with |
Find out the web address of your application
To find out the web address of a web application click on 
in the list of web applications. A new screen will appear displaying the name and address of your web application. See the screenshot below.
An example web application URL found using the Control Panel.
View, download and work on saved data
Click the 
icon in the data column to open the data tab to view, download and work on saved data of a web application. Please note: the data tab and database functionality are only available if activated and set up during conversion with the SpreadsheetWEB wizard.
An example data tab that allows the user to view, download, and work on saved data.
Add web applications
To add a web application click Add web application. A new page will appear where you need to give the web application a name, provide an Excel spreadsheet, etc. Please see the screenshot below:
The new page that opens after you decide to add a new web application.
An explanation of symbols and buttons seen on this page can be found below:
| Name of the new web application | Enter a name for the web application. |
| Excel Spreadsheet | Upload the Excel spreadsheet associated with the application. Note: Only Excel spreadsheets that prior to uploading have been processed with the SpreadsheetWEB Wizard can be used here. Before uploading an Excel spreadsheet, you must at least once run the SpreadsheetWEB wizard on the file. This required because the Wizard embeds code in the Excel spreadsheet that is used by our server-side application. |
| Status | Available options: online and offline Online: The web application is published at a specific web address and can be viewed by others in a web browser Offline: The web application is stored in your account but is not published yet. |
| Access | Available options: unrestricted and restricted Unrestricted: Anyone who knows the web address of your web application can open and view it in a browser Restricted: Only defined users can access the web application, i.e. open it in a browser, view it and perform calculations. Restricted with registration: Only defined users can access the web application, i.e. open it in a browser, view it and perform calculations, after registering from the login page. |
| Allow concurrent editing | Concurrent Data Editing allows record locking to prevent two users from editing the same file at the same time |
| Single record application | Single Record Application provides the functionality to create an application with a single record. Every time a user accesses this application and presses Save, it will overwrite the existing record. In a way, it is similar to working on the same Excel file and saving over and over again. |
|
| Secure Access (SSL) | Enables SSL security for the web application |
| Online availability | Select if a web application will be published only for a certain period of time or for as long as the web application has been removed by you. |
| Add to group(s) | chose the access type restricted only users that belong to the group you specify here, have full access to this web application |
| Notes | Space for your own notes, which will also be displayed in the web application list in the column Notes |
Once you are ready please click Save to add a web application. To cancel the process, please click Cancel.
Add web services
Wikipedia defines Web Service as "a software system designed to support interoperable machine-to-machine interaction over a network. It has an interface described in a machine-processable format (specifically WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP-messages, typically conveyed using HTTP with an XML serialization in conjunction with other Web-related standards. Web services are frequently just Internet Application Programming Interfaces (API) that can be accessed over a network, such as the Internet, and executed on a remote system hosting the requested services."
SpreadsheetWEB allows an excel file, typically incorporating formulas, to be exposed as a web service allowing an external application to connect to this web service and retrieve information.
To begin, log into the SpreadsheetWEB control panel and under the "Applications" tab, click on "Add Web Service."
The "Add Web Service" option under the "Applications" tab.
The following menu will be displayed and the user will be prompted to insert a name for the web service, select an Excel spreadsheet to upload, determine the status of the application (online/offline) as well as generate an application key. The application key is entirely unique and will be required before connecting to the web service in the future. There is also an SSL option, a disable cache option, an option to set the availability on the web, a place to determine which group it is a part of, and a small section for notes.
The "Add Web Service" page.
Delete applications
Check the box of the applications you wish to remove.
In applications, select the applications you wish to delete in the list of web applications by ticking the respective check boxes. Then click on Delete selected applications above the table. The page will refresh, now showing the updated list of web applications - those that are currently stored in your account with the selected ones now removed.
Change the name of an application
To change the name of a web application, go to the applications tab and browse to the web application you wish to edit and in the same row click the 
button. A new page will appear with a table showing the current settings of your web application. In the top row, simply overwrite the existing web application name and then click save at the bottom of the page.
Update the Excel spreadsheet that is attached to an application
To update the Excel spreadsheet that is linked to an application, go to the applications tab and browse to the application you wish to edit and in the same row click the button. A new page will appear with a table showing the current settings of your application.
In the second row it says Excel spreadsheet. Here you can simply upload a new Excel spreadsheet. Important: only Excel spreadsheets that prior to uploading have been processed with the SpreadsheetWEB Wizard can be used here. That means that if you have changed anything in the Excel file, you need to convert the file again using the SpreadsheetWEB wizard, save and close the file before you can upload it.
Assign an application to a group of users
To assign an application to a user group, it is required that you have already created a user group. The steps to create a new user group will be explained farther in the document.
Assigning an application to a group of users can be done while adding an application or at any time afterward.
If you already have an application that you want to assign to a group, please go to the applications tab, then browse to the web application you wish to edit and in the same row click the button. A new page will appear with a table showing the current settings of your web application. Go down to the row where it says Add to group(s) and select the group that you want your web application to be assigned to. When you are done, click save.
Restrict access to an application
Restricting access to an application is a multiple-step process.
- It is required that you have created a group.
- At least one user must be assigned to that group.
- Access must be changed to restricted.
- The web application must be assigned to the same group.
For step 3 and 4, click the applications tab in the navigation menu. From the list of web application, find the one that you want to restrict access from and click the button in the same row. On the next page, please go to the row where it says Access and activate the option button next to restricted. To assign the web application to a group, go to Add to group farther down in the table and select a group from the combo box.
Change the online/offline status of an application
To change the online/offline status of a web application, click the applications tab in the navigation menu and browse to the application you wish to edit and in the same row click the button. A new page will appear with a table showing the current settings of your web application.
Go to Status and activate either the option button online, if you wish your application to be available on the web, or offline if you wish that your application is only stored in your account but not yet available for others on the web.