我的问题是在读取合并/组合列单元格的 Excel 文件时。例如,将下面的excel数据读取到数据库中。
Excel 输入:
+----+-------+---------+-------+
| ID | NAME | DEPT |
+----+-------+---------+-------+
| | FNAME | LNAME | |
+----+-------+---------+-------+
| 1 | Akil | Tiwari | IT |
| 2 | Vinod | Rathore | IT |
| 3 | Jatin | Khanna | HR |
| 4 | Divya | Kherde | AD |
| 5 | Amey | Gauda | FI |
+----+-------+---------+-------+
预期数据库输出:
+----+-------+---------+------+
| ID | FNAME | LNAME | DEPT |
+----+-------+---------+------+
| 1 | Akil | Tiwari | IT |
| 2 | Vinod | Rathore | IT |
| 3 | Jatin | Khanna | HR |
| 4 | Divya | Kherde | AD |
| 5 | Amey | Gauda | FI |
+----+-------+---------+------+
只要正常连接你的 Excel,Excel 连接管理器就会像下面这样读取它:
+----+-------+---------+-------+
| ID | NAME | F3 | DEPT | <-- Header
+----+-------+---------+-------+
| | FNAME | LNAME | | <--First Row
+----+-------+---------+-------+
| 1 | Akil | Tiwari | IT | <-- Second Row
| 2 | Vinod | Rathore | IT | .
| 3 | Jatin | Khanna | HR | .
| 4 | Divya | Kherde | AD | .
| 5 | Amey | Gauda | FI | .
+----+-------+---------+-------+
在 Excel 源中,只需重命名列,如下所示”
NAME --> FNAME
F3 --> LNAME
然后只需添加一个条件拆分,使用以下表达式过滤 ID = NULL 的行
ISNULL([ID]) == false
那么第一行将被忽略
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)