• Home
  • About us
  • Document
  • Download
  • Buy
  • Support

  • What is ExcelServer
  • Installation Guide
  • Getting Started
  • Video Tutorial

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

 

Beijing CESoft Co., Ltd. All righits reserved.
Email: cuiyajun@qinzhe.com