北京
乾学院 32 号会员
2 回帖  •  633 浏览  • 
     ...

直接在公式里写关联

 
关联(16)

 

举例

Excel文件book1.xlsx中有员工就餐数据，部分数据如下所示：

..

现在要计算D列的员工餐费Meal charge，计算规则如下表所示：

..

编写SPL脚本：


A

1

=T("e:/work/book1.xlsx")

2

=A1.run('Meal   charge'=case(Grade,"manager":case('Meal type',"breakfast":20,"lunch":30,"supper":40),"chief":case('Meal   type',"breakfast":15,"lunch":20,"supper":25),"worker":case('Meal   type',"breakfast":10,"lunch":15,"supper":20)))

3

=T("e:/work/book2.xlsx",A1)

A1   读出book1.xlsx数据

A2   循环每条记录，根据Grade和Meal type的值查询出Meal charge的值

A3   把A1中的结果保存到文件book2.xlsx

 

 


关联(16)