PQ - from excel workbook with/without promote headers

[sandy666]

with Table.PromoteHeaders


let
Source = Excel.Workbook(File.Contents("(path_to_the_file)\fakedata-0p7sxQX3Zv8cX2nyJaCYn.xlsx"), null, true),
#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet" = Source{[Item="fakedata-0p7sxQX3Zv8cX2nyJaCYn",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet", [PromoteAllScalars=true])
in
#"Promoted Headers"

without Table.PromoteHeaders


let
Source = Excel.Workbook(File.Contents(("(path_to_the_file)\fakedata-0p7sxQX3Zv8cX2nyJaCYn.xlsx"), true, true),
#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet" = Source{[Item="fakedata-0p7sxQX3Zv8cX2nyJaCYn",Kind="Sheet"]}[Data]
in
#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet"

one line less and the effect is the same :)


namephoneemailaddresspostalZipregioncountrylist

Porter Franklin(625) 763-3454urna.nec@protonmail.net949-736 Vitae St.
16112Lipetsk OblastNigeria
11

Kasimir Ramirez(394) 402-7467ante.lectus@outlook.coukAp #611-325 Lectus Ave
60746Zuid HollandAustria
7

Darius Stone1-184-757-7028ipsum.dolor@protonmail.netP.O. Box 830, 967 Orci Rd.
30546Madhya PradeshChina
3

Linus Jarvis1-839-469-3822feugiat.metus@outlook.eduAp #965-6264 Suspendisse Road05-958South IslandChile
1