QV加载Excel文件错误
0
代码如下:LOAD [行次],
[资 产] as 资产负债_科目,
期末余额 as 资产负债_期末余,
年初余额 as 资产负债_年初余
FROM
[D:\work\Boke\BI\BI Project\黄浦卫生\试点单位财务报表-数值\社区卫生\老西门2011-2013\*]
(biff, embedded labels, table is 资产负债表$, filters(
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Col, Pos(Top, 8)),
Remove(Col, Pos(Top, 7)),
Remove(Col, Pos(Top, 6)),
Remove(Col, Pos(Top, 5))
错误信息:
cannot locate table in biff file
[资 产] as 资产负债_科目,
期末余额 as 资产负债_期末余,
年初余额 as 资产负债_年初余
FROM
[D:\work\Boke\BI\BI Project\黄浦卫生\试点单位财务报表-数值\社区卫生\老西门2011-2013\*]
(biff, embedded labels, table is 资产负债表$, filters(
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Col, Pos(Top, 8)),
Remove(Col, Pos(Top, 7)),
Remove(Col, Pos(Top, 6)),
Remove(Col, Pos(Top, 5))
错误信息:
cannot locate table in biff file
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
曹浩 - QlikView顾问、QV讲师 2015-09-16 回答
赞同来自: