本站资源&API

日期相关

节气日期

从1901-2100年（含两端）的节气日期，以JSON形式返回。数据示例：

[
    ["19010106","小寒"],["19010121","大寒"],["19010204","立春"],["19010219","雨水"],
    ["19010306","惊蛰"],["19010321","春分"],["19010405","清明"],["19010421","谷雨"],
    ["19010506","立夏"],["19010522","小满"],["19010606","芒种"],["19010622","夏至"],
    ...
    ["21000707","小暑"],["21000723","大暑"],["21000807","立秋"],["21000823","处暑"],
    ["21000907","白露"],["21000923","秋分"],["21001008","寒露"],["21001023","霜降"],
    ["21001107","立冬"],["21001122","小雪"],["21001207","大雪"],["21001222","冬至"]
]

访问链接：https://www.blackexcel.cn/static/file/solarterms.json

您也可以直接使用下面的PowerQuery示例代码：

let
    源 = Table.FromRows(Json.Document(Web.Contents("https://www.blackexcel.cn/static/file/solarterms.json")), {"日期", "节气"}),
    更改的类型 = Table.TransformColumnTypes(源,{{"日期", type date}, {"节气", type text}})
in
    更改的类型