Forum Discussion
SHAYAN1350
Nov 06, 2020Copper Contributor
transfer data and hyperlink from web to power quary
hello Is there a way in Power Query to transfer data from the web, the hyperlinked text is transferred to Power Query in the same conditions and works? and for that how can i extract URL code from ...
SHAYAN1350
Nov 07, 2020Copper Contributor
SergeiBaklan
Nov 07, 2020Diamond Contributor
Yes, sorry, Html.Table() is not available so far in Excel. Parsing of page as text which Gil suggested could work, but you shall to know which kind of links you'd like to extract and how to clean them.
- SHAYAN1350Nov 08, 2020Copper Contributor
Thanks Baklan
I was looking for a way to create an Excel file that extract all category of formula in excel from below link by power query, that I can update the ability to access all information and examples of formulas. if it possible help me to do it please.
https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb