excel 复杂计算，替换时间为时间字符串，然后拼接成sql

大道至简_lyon

于 2024-07-30 09:10:23 发布

阅读量175

点赞数 2

文章标签： java 服务器前端

本文链接：https://blog.csdn.net/a5601564/article/details/140787630

版权

=SUBSTITUTE(
    "insert into "&$D$39&" values ('"&
    TEXTJOIN("','",FALSE,
        IF(D42:P42="","",
            IF(ISNUMBER(D42:P42),
                IF(AND(D42:P42>0,D42:P42<1),
                    TEXT(D42:P42,"hh:mm:ss"),
                    IF(D42:P42>=1,
                        IF(MOD(D42:P42,1)=0,
                            TEXT(D42:P42,"yyyy-mm-dd"),
                            TEXT(D42:P42,"yyyy-mm-dd hh:mm:ss")
                        ),
                        D42:P42
                    )
                ),
                D42:P42
            )
        )
    )&"');",
    "'NULL'","NULL"
)

I003対象

insert into TX_REDIRECT_KANRI values ('100000001','001','001','','','UFB020','2022-02-10','UFB020','UFB020','2022-02-10','UFB020','2022/2/1','2022/2/28');

100000001

001

UFB020

2022/2/10

UFB020

2022/2/10

UFB020

2022/2/1

2022/2/28