且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在“读取"之前跳过6行.进入powerquery

更新时间:2023-12-03 20:31:05

使用本机CSV PowerQuery解析器

let
    file_path = "C:\your_path\csv.txt",
    file = File.Contents(file_path),
    src = Lines.FromBinary(file),
    skip = List.Skip(src,6),
    combine = Text.Combine(skip, "#(lf)"),
    csv = Csv.Document(combine),
    promote = Table.PromoteHeaders(csv)
in
    promote