Forum Discussion
Solved
Excel Abfrage einer Webseite und Verarbeitung mit PowerQuery
Ich habe in einer Excelarbeitsmappe (Excel 2019 unter Win 10) Daten von einer Webseite abgerufen und mit einer Powerquery auf eine Datenblatt übertragen. Das hat bis zum 14.08.2024 einwandfrei funkti...
I have now found the culprit. For unknown reasons, the Microsoft program “Microsoft -NET Framwork 4.8” was installed on my PC and that was the culprit. After I removed it, my program is running again without any problems.
Thanks again for your advice
mfg/Ludwig
let
Source = Web.BrowserContents("https://muenzshop.rlbooe.at/3870_DE-Services-Kundenblatt.htm"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column2", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column3", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(4), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column4", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(3), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column5", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(3) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(2), TABLE:nth-child(4) > * > TR > TD[colspan=""5""]:not([rowspan]):nth-child(1):nth-last-child(1)"}, {"Column6", "TABLE:nth-child(4) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(3) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(2) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(1)"}}, [RowSelector="TABLE:nth-child(4) > * > TR"]),
#"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true])
in
#"Promoted Headers"Inzwischen habe ich den Übeltäter gefunden. Aus unbekannten Gründen hat sich auf meinem PC das Microsoftprogramm "Microsoft -NET Framwork 4.8 installiert und das war der Übeltäter. Nachdem ich dieses entfernt habe läuft mein Programm wieder anstandslos.
Nochmals danke für eure Ratschläge
mfg/Ludwig