let
    srcPath = Excel.CurrentWorkbook(){[Name="LocalPath"]}[Content]{0}[Column1],
    Source = Folder.Files(srcPath),
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Content", "Name"}),
    #"Added Custom" = Table.AddColumn(#"Removed Other Columns", "GetFileData", each Excel.Workbook([Content],true)),
in
    #"Added Custom"