Forum Discussion
Excel Abfrage einer Webseite und Verarbeitung mit PowerQuery
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
Die Daten stammen von der der Webseite https://muenzshop.rlbooe.at/3870_DE-Services-Kundenblatt.htm. Der Test einens Mitarbeiters von Norton mit Norton Power Eraser ergab keinen malicious code.
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