We have recently released the Version 2.3 of SpreadsheetWEB and it is more functional than ever. Now let’s see in what ways SpreadsheetWEB helps users to create high-performance web applications or web forms out of your Excel spreadsheets.
The features of SpreadsheetWEB 2.3 are listed in the following sections:
- Mapping Support
- Web Services Support
- Comment Support
- Validation Support
Mapping Support
You can create classy looking web based mapping applications with SpreadsheetWEB easily. The Wizard prompts you to begin the process by selecting the region you want to capture after clicking on the “Maps” option under the SpreadsheetWEB add-on menu.
The regions include the World and continents. You will choose a map from the “Select Map” list and continue with identifying certain IDs within the spreadsheet that will correspond to location on the map under the option labeled “Data Label Range”. The second option, “Data Range”, will let you select the range of data that corresponds to the labels. On the third page you will be able to customize the map in terms of colour, labels, shadows, and tooltips. After pressing “Finish” and converting the spreadsheet into a web application, it will look something like this.
Web Services Support
SpreadsheetWEB supports Web Services in two levels. It could either enable a specific worksheet formula to connect to an external Web Service or render an Excel file to be a Web Service itself and permit external applications to connect to it and retrieve information afterwards.
To do so, the Wizard will come to your help and ask you to insert a WSDL for the Web Service as well as a username and password if it is necessary.
Finally a formula will be created in the active cell that will look like the following: =SpreadsheetWEBWSGET(wsdlAddress, operationName, username, password, outputRange, inputRange1, inputRange2…)
and the data will be filled in and the Web Service can be modified by altering the formula.
Comment Support
You can convert the comment boxes within the Excel files into their web applications too.
The figure above shows a typical comment box in Excel and the figure below shows how it looks on a web application.
Validation Support
Version 2.3 of SpreadsheetWEB introduced support for the validation function found in Excel. This function forces you to input a value that fits to certain rules that are supported within Excel including changing allowable values to solely whole numbers, decimals, dates, times, or within certain text lengths. Criteria within those ranges are also supported with functions such as “between, not between, equal to, not equal to, greater than, less than, greater than or equal to, less than or equal to, and minimum/maximum fields.”
Error Alert messages can also be created within Excel and converted using SpreadsheetWEB.
Simply check “Validation” under the Advanced Input Control Properties and make it function properly.
Try it now?
To start using SpreadsheetWEB, just go to our website, download the free trial version and publish your first web applications in minutes!
