本帖最后由 wuxiang_123 于 2012-1-11 09:59 编辑
导入外部数据时,取消勾选【数据首行包含列标题】。
使用如下代码:
- SELECT F1,F2,F3,F4,F5,F6,F7,F8 FROM
- (select F1+0 AS 排序,F1,F2,F3,F4,F5,F6,F7,F8 FROM [数据$A2:H]
- UNION ALL
- select F1-0.1,"工号","姓名","基本工资","住房津贴","伙食津贴","奖金","罚款","应发工资" FROM [数据$A2:H]
- UNION ALL
- select F1+0.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL FROM [数据$A2:H])
- WHERE 排序 IS NOT NULL
- ORDER BY 排序
复制代码
数据源截图:
生产的工资条效果图:
之前想多了,其实不取消勾选【数据首行包含列标题】也是可以实现。不勾选后的代码为:
- SELECT 工号,姓名,基本工资,住房津贴,伙食津贴,奖金,罚款,应发工资 FROM
- (select 工号+0 AS 排序,工号,姓名,基本工资,住房津贴,伙食津贴,奖金,罚款,应发工资 FROM [数据$]
- UNION ALL
- select 工号-0.1,"工号","姓名","基本工资","住房津贴","伙食津贴","奖金","罚款","应发工资" FROM [数据$]
- UNION ALL
- select 工号+0.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL FROM [数据$])
- WHERE 排序 IS NOT NULL
- ORDER BY 排序
复制代码
该贴已经同步到 wuxiang_123的微博
|