Help center
Sign inTry for free
Course contents7 lessons
Course overview
  1. 01How to Create a New Application
  2. 02How to Change Application Access Type
  3. 03How to Assign Tags While Saving a Record
  4. 04How to Use Chat Feature in Applications
  5. 05How to Manage Transactions in Applications
  6. 06How to Use The Automated Application Creation Tool
  7. 07Application migration and backup

Lesson 1 of 7

How to Create a New Application

Create a SpreadsheetWeb Hub application from an Excel workbook, bind named ranges to interface controls, preview the result, and publish it.

2 min read

Create a web application from an Excel workbook and expose its inputs and calculated outputs through a browser-based interface. The workbook remains the calculation model, while SpreadsheetWeb provides the application layout, controls, access, and publishing workflow.

Prepare the workbook

Review the Excel file before uploading it. Assign named ranges to the input cells users will edit and the output cells or blocks the application will display.

Clear named ranges make the Designer easier to use because every interface control is bound to a workbook reference. They also help protect the application from worksheet changes that could move a cell to another location.

Create the application

  1. Open Applications in SpreadsheetWeb Hub.
  2. Select Create New Application.
  3. Enter an application name. If the workbook is uploaded first, Hub can use the Excel filename as the initial name.
  4. Upload the Excel workbook.
  5. Add tags if the application should be grouped or accessed through a tag-based rule.
  6. Select Create Application.

SpreadsheetWeb may offer the automated application-generation tool. You can use it to create an initial interface or choose No thanks and build the interface manually, as shown in the video.

Design the user interface

Open the new application and select Go to Designer, then choose User Interface.

Drag structural components and input or output controls from the control panel into the page. For each control:

  1. Bind it to the appropriate workbook named range.
  2. Set its label and display properties.
  3. Configure any control-specific behavior required by the application.

Use Preview to confirm that input values reach the correct workbook cells and that calculated outputs display as expected.

Publish and test the application

Select Publish when the interface and calculations are ready. Publication makes the current transaction available to permitted users.

From the Applications page, select View Published Version. Complete a realistic scenario and verify the calculation before sharing the application with additional users.