New SpreadsheetWEB 3.0

SpreadsheetWEB provides you with all you need to turn Microsoft Excel spreadsheets into high-performance web applications or web forms and to publish them instantly on the web.

New Features in SpreadsheetWEB 3.0

Scripting Support
New Control Panel user interface
Improved server performance and memory management
Excel 2007 Ribbon and Connect to Workbook feature
Installation for 64-bit servers
Microsoft SQL 2008 support

Features of SpreadsheetWEB

Create Web applications and Web forms like online databases and surveys, sign-up and registration forms, invoices, time sheets, and many other applications with SpreadsheetWEB. It is free. It is easy to use. Anyone with basic Excel spreadsheet skills can create professional looking Web applications in no time. Enhance your applications and forms by adding multiple worksheets, charts, images, logos, and calculations (333 Excel functions supported). Easily password-protect your forms. View data collected from your Web apps online or in familiar Excel format. Create your applications in Excel, turn them into web applications in minutes using SpreadsheetWEB.

Scripting Support

Support for scripting enables end-users to implement Javascript code as well as html tags into their web-based applications, broadening the functionality of their finalized web pages. Using Javascript, end-users will be able to seamlessly integrate utilities hosted by other organizations with open APIs into their own web applications. Adding new script to an existing spreadsheet is as easy as writing Javascript code in an HTML editor. Developers will be able to reach HTML fields and even spreadsheet cells by adding Javascript/HTML codes from the script editing page. They will be able to validate their forms, override before and after calculation calls and even integrate 3rd party products such as Google Maps, PayPal, 3rd party charting and visualization products, etc… with their final web pages. Since scripting also supports adding HTML tags directly, users will be able to add new input fields, styles, embedded scripts, embedded objects (like Flash) directly to their final pages. Scripting gives unlimited flexibility to development-oriented users to integrate their custom web pages/parts with SpreadSheetWEB generated web pages.

Employee Evaluation SpreadsheetWEB

Dashboard Reporting

SpreadsheetWEB supports creating dashboard reports combining filters, data grids, charts and pivot tables. It allows user to interact with data in an interavtive manner. A simple, user-friendly, browser based editor is used to create dashboards. Once created, a dashboard can be deployed to a select list of individuals through SpreadsheetWEB's application management module to ensure data security.

Employee Evaluation SpreadsheetWEB

Sparkline Support

Sparklines are small and compact charts with high data density, and serve to display the trends and variations of associated data area in figures. SpreadsheetWEB supports 8 types of sparkline charts including line, discrete bar, bar, area, pie, icon and scale. Sparklines enable users create rich dashboards and reports. Here are a few examples:

Mapping

SpreadsheetWEB supports integrating maps with spreadsheet that can converted to interactive web based mapping applications. This allows creating rich dashboard and reporting applications integrated with data and formulas in Excel spreadsheets. SpreadsheetWEB supports over 500 maps including world and continents, USA and counties, USA regions, Europe (by countries), Europe (by regions), United Kingdom, North America, South America, Central America, Canada (Provinces and Territories), Asia, Middle East, Oceania, and Africa.

Web Services Support

SpreadsheetWEB includes two levels of support for Web Services. The first one is the ability to connect to a Web Service from inside Excel via a SpreadsheetWEB specific worksheet formula. The purpose of this feature is to bring data into an Excel file from external Web Services. An example can be getting real time stock prices for a given stock. SpreadsheetWEB will then maintain the web service connection in the Excel file when converted into a web application.

The second type of Web Services support 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.

PivotTables®

Publish your Excel-based PivotTables® applications to the web. It is easy to create interactive online tables with SpreadsheetWEB. You can use these online reports to analyze data, make comparisons, detect patterns and relationships, and discover trends. Most common PivotTables® functionalities are supported.

Rich User Interface Experience

Browsing Buttons: Create a rich user interface experience by using custom browsing buttons that allow users to navigate easily back and forth between worksheets in mulitple worksheet web applications.

Hide and Deactivate Sections of Web Applications: Design web applications that are easy to use. Let your users only see and fill in relevant areas of your web applications by hiding or deactivating areas of a web application depending on previous user input.

Validation Support: SpreadsheetWEB supports input validation function found in Excel. This function forces the end user 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.”

Comment Support: SpreadsheetWEB supports comments found within cells in Excel. This allows the user to convert comment boxes from their Excel spreadsheets into their web application. The comment boxes will be displayed to the end user when they place their cursor over the icon that appears next to the cell containing the comment. While the default comment icon is the same icon found in Excel, SpreadsheetWEB supports several alternative indicators.

Secure access (SSL)

With SpreadsheetWEB1.6 we provide you with the ability to send your data using SSL, providing enhanced security for you and your users.

Additional Access Control Features

New SpreadsheetWEB-specific Excel functions: Two new SpreadsheetWEB-specific Excel functions were added for flexible and easy implementation of user/user role based access rights in web applications. Easily implement restricted areas within your applications in order to provide users access only to areas relevant to their responsibilities.

Database Features

With SpreadsheetWEB it is possbile to connect web applications to databases by using only the SpreadsheetWEB Wizard. Submitted and stored data in the database can be downloaded as Excel reports or viewed and manipulated directly in the web browser using the SpreadsheetWEB web control panel.

Using Excel's built in query features you can even create web applications that process and display data stored in your database. And all this requires no web programming experience. All you need is knowledge of Microsoft Excel.

Addditional SpreadsheetWEB Database Features

Using the SpreadsheetWEB web control panel you can view, edit an process data in your SpreadsheetWEB database directly in the web browser. Tag or mark your data with custom keywords. The new history button delivers an online report about the history of events of your data records.

Visit our help documentation for detailed instructions on how to use Microsoft Excel's SQL commands in connection with SpreadsheetWEB.

Auto Response Email:

With this feature you have the ability to send an email to users when they click on the “Save” button in your application.

Notification Email:

With this feature developers can easily send themselves a notification email when new data is submitted.

Page Forwarding:

This feature provides the ability to forward users to another page after their data is submitted. This can either be a URL entered by you or a custom page you create using SpreadsheetWEB.

Create web forms to collect data online

Create web applications and web forms like online surveys, sign-up and registration forms, invoices, timesheets, and many applications.

Typical Applications

Built your applications in Microsoft Excel, once ready simply convert them into web applications using SpreadsheetWEB.

Most Microsoft Excel functions supported

SpreadsheetWEB supports 333 Microsoft Excel functions. For a complete list of currently supported Microsoft Excel functions please click here

Multiple Worksheet Applications

SpreadsheetWEB allows you to convert multiple worksheet workbooks into rich web applications. Calculations, references accross different worksheets are automatically converted. Using the tab bar on top of the browser window allows easy navigation between different worksheets of the web application.

Wide Selection of Input Types

SpreadsheetWEB offers a wide range of different input types. Beyond the standard text box you find combo boxes, list boxes, option buttons, password fields, and a totally new input type called 'grid'. This new input type allows you to select a range of cells (matrix) at once as a single input definition, making it much easier to handle large ranges of cells, if they are grouped in a matrix.

Data via Email

Create web forms in minutes. Once the users of your web application click the "Submit" button, an email is being sent to you containing the current contents of the web application. It is very simple to set up; you only need to enter your email address.

Charts

Use SpreadsheetWEB's chart conversion functionality to create, for example, online reports, online dashboards, financial analysis tools. The following charts are currently supported:

Please click here to see the full list of supported charts

Images and Drawings

Create impressive web applications using your corporate design, illustrations, Microsoft Drawing Art and any other images that you can import to Microsoft Excel.

Password Protection

Password protect your web applications to restrict access only to those users you provided with a username and a password. If you want more security for your data, a server edition of SpreadsheetWEB is available. Please contact us for more information.

Integrate SpreadsheetWEB applications with your web site

Web applications created with SpreadsheetWEB can easily be integrated with your web site or blog by using the iframe technology. SpreadsheetWEB offers a code generation tool with the new SpreadsheetWEB web administration tool.

Current Restrictions

Currently some cell formats, some Microsoft Excel functions, Microsoft Excel macros and VBA code, conditional formatting, and third party add-ins are not supported.

Do you have any ideas or suggestions what features future versions of SpreadsheetWEB should have? Please let us know. Send us an email.