1.执行批量insert脚本的时候
="insert into tenant_dept_info (dept_id, tenant_id) values ('"&F2&"','"&B2&"');"
2.截取字符串
=RIGHT(B1,LEN(B1)-FIND("-/",B1))
3.多个sheet匹配
=VLOOKUP(G2,部门表!B:C,2,0)
1.执行批量insert脚本的时候
="insert into tenant_dept_info (dept_id, tenant_id) values ('"&F2&"','"&B2&"');"
2.截取字符串
=RIGHT(B1,LEN(B1)-FIND("-/",B1))
3.多个sheet匹配
=VLOOKUP(G2,部门表!B:C,2,0)