Video Tutorial for ExcelServer
Getting started, make Excel spreadsheet a template, save data on Excel into database
- 01 Log in to ExcelServer
- 02 Create a template
- 03 Define fields and create tables on template
- 04 Save template, set permission
- 05 Fill in a form based on template, save data on Excel into database
- 06 Update or delete form data from "My Workbench"
- 07 Add primary key to table, set fields as required
- 08 Group and sort, easy to locate data in "My Workbench"
- 09 Find data in "My Workbench"
Add permission to Template, share data among users
- 10 Create departments using Applciation Manager
- 11 Create roles
- 12 Create users
- 13 Grant permission of template to roles or users
Add GUI features to spreadsheet, use dropdown, treeview, listview on template
- 14 Bind systam variable to fields
- 15 Genarate ID automatically
- 16 Add dropdown list to spreadsheet
- 17 Add list view to spreadsheet
Data-Weaver, transfer data between Excel and database
- 18 Define data-weaver on template, get data from database into Excel
- 19 Use "thisForm" variable in data-weaver, get data from database according to what is on Excel worksheet
- 20 Use functions in data-weaver, generate summary report
- 21 Update database with values on Excel spreadsheet
Workflow
- 23 Workflow works in ExcelServer, let spreadsheet move among users according to business logic
- 24 Add workflow to template
- 25 Deal work items in workflow, redo, undo