用Excel服务器实现web远程集团统计信息系统〈二〉
时间:2023-10-29 08:30:17 雅雅
二、设计“销售日报” 打开Excel,点击主菜单“Excel服务器”,用admin登录。 1
二、设计“销售日报”
打开Excel,点击主菜单“Excel服务器”,用admin登录。
1.建立表格模板
点击“模板”,选择“新建”:
![](http://img.skycn.com/articleimg/20040923-6.jpg)
选择“初始填报权限”:
![](http://img.skycn.com/articleimg/20040923-7.jpg)
选择“最终查阅权限”:
![](http://img.skycn.com/articleimg/20040923-8.jpg)
开启“启用”模板:
![](http://img.skycn.com/articleimg/20040923-9.jpg)
画出表格,定义单一数据项:
![](http://img.skycn.com/articleimg/20040923-10.jpg)
![](http://img.skycn.com/articleimg/20040923-11.jpg)
![](http://img.skycn.com/articleimg/20040923-12.jpg)
数据规范用于规范Excel中填写内容。
定义重复数据项:
![](http://img.skycn.com/articleimg/20040923-13.jpg)
![](http://img.skycn.com/articleimg/20040923-14.jpg)
![](http://img.skycn.com/articleimg/20040923-15.jpg)
![](http://img.skycn.com/articleimg/20040923-16.jpg)
2.定义工作流
选择主菜单“工作流”:
![](http://img.skycn.com/articleimg/20040923-17.jpg)
![](http://img.skycn.com/articleimg/20040923-18.jpg)
![](http://img.skycn.com/articleimg/20040923-19.jpg)
![](http://img.skycn.com/articleimg/20040923-20.jpg)
![](http://img.skycn.com/articleimg/20040923-21.jpg)
定义审核任务:
![](http://img.skycn.com/articleimg/20040923-22.jpg)
![](http://img.skycn.com/articleimg/20040923-23.jpg)
![](http://img.skycn.com/articleimg/20040923-24.jpg)
建立流向:
![](http://img.skycn.com/articleimg/20040923-25.jpg)
定义完成工作流:
![](http://img.skycn.com/articleimg/20040923-26.jpg)
保存模板,结束。
打开esweb,用admin来登录,看一看显示:
![](http://img.skycn.com/articleimg/20040923-27.jpg)
服务器是您的服务器名称。
打开Excel,点击主菜单“Excel服务器”,用admin登录。
1.建立表格模板
点击“模板”,选择“新建”:
![](http://img.skycn.com/articleimg/20040923-6.jpg)
选择“初始填报权限”:
![](http://img.skycn.com/articleimg/20040923-7.jpg)
选择“最终查阅权限”:
![](http://img.skycn.com/articleimg/20040923-8.jpg)
开启“启用”模板:
![](http://img.skycn.com/articleimg/20040923-9.jpg)
画出表格,定义单一数据项:
![](http://img.skycn.com/articleimg/20040923-10.jpg)
![](http://img.skycn.com/articleimg/20040923-11.jpg)
![](http://img.skycn.com/articleimg/20040923-12.jpg)
数据规范用于规范Excel中填写内容。
定义重复数据项:
![](http://img.skycn.com/articleimg/20040923-13.jpg)
![](http://img.skycn.com/articleimg/20040923-14.jpg)
![](http://img.skycn.com/articleimg/20040923-15.jpg)
![](http://img.skycn.com/articleimg/20040923-16.jpg)
2.定义工作流
选择主菜单“工作流”:
![](http://img.skycn.com/articleimg/20040923-17.jpg)
![](http://img.skycn.com/articleimg/20040923-18.jpg)
![](http://img.skycn.com/articleimg/20040923-19.jpg)
![](http://img.skycn.com/articleimg/20040923-20.jpg)
![](http://img.skycn.com/articleimg/20040923-21.jpg)
定义审核任务:
![](http://img.skycn.com/articleimg/20040923-22.jpg)
![](http://img.skycn.com/articleimg/20040923-23.jpg)
![](http://img.skycn.com/articleimg/20040923-24.jpg)
建立流向:
![](http://img.skycn.com/articleimg/20040923-25.jpg)
定义完成工作流:
![](http://img.skycn.com/articleimg/20040923-26.jpg)
保存模板,结束。
打开esweb,用admin来登录,看一看显示:
![](http://img.skycn.com/articleimg/20040923-27.jpg)
服务器是您的服务器名称。