PQ - Get actual worksheet functions list

Get actual worksheet functions list

Code:

let Source = Web.Page(Web.Contents("https://support.office.com/en-us/article/Excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188")), Data0 = Source{0}[Data], Clean = Table.TransformColumns(Data0,{{"Type and description", Text.Clean, type text}}), Split = Table.SplitColumn(Clean, "Type and description", Splitter.SplitTextByEachDelimiter({":"}, QuoteStyle.Csv, false), {"Type and description.1", "Type and description.2"}), Replace = Table.ReplaceValue(Split," ","#(lf)",Replacer.ReplaceText,{"Type and description.2"}), Trim = Table.TransformColumns(Replace,{{"Type and description.2", Text.Trim, type text}}), Replace2 = Table.ReplaceValue(Trim,",","#(lf)",Replacer.ReplaceText,{"Type and description.2"}), Ren = Table.RenameColumns(Replace2,{{"Type and description.1", "Type"}, {"Type and description.2", "Description"}}), Index = Table.AddIndexColumn(Ren, "Index", 1, 1), Reorder = Table.ReorderColumns(Index,{"Index", "Function name", "Type", "Description"}) in Reorder

part of data:

Index Function name Type Description

1
ABS function Math and trigonometry Returns the absolute value of a number

2
ACCRINT function Financial Returns the accrued interest for a security that pays periodic interest

3
ACCRINTM function Financial Returns the accrued interest for a security that pays interest at maturity

4
ACOS function Math and trigonometry Returns the arccosine of a number

5
ACOSH function Math and trigonometry Returns the inverse hyperbolic cosine of a number

6
ACOT function Math and trigonometry Returns the arccotangent of a number

7
ACOTH function Math and trigonometry Returns the hyperbolic arccotangent of a number

8
AGGREGATE function Math and trigonometry Returns an aggregate in a list or database

9
ADDRESS function Lookup and reference Returns a reference as text to a single cell in a worksheet

10
AMORDEGRC function Financial Returns the depreciation for each accounting period by using a depreciation coefficient

11
AMORLINC function Financial Returns the depreciation for each accounting period

12
AND function Logical Returns TRUE if all of its arguments are TRUE

13
ARABIC function Math and trigonometry Converts a Roman number to Arabic
as a number

14
AREAS function Lookup and reference Returns the number of areas in a reference

and so on ...

Index	Function name	Type	Description
1	ABS function	Math and trigonometry	Returns the absolute value of a number
2	ACCRINT function	Financial	Returns the accrued interest for a security that pays periodic interest
3	ACCRINTM function	Financial	Returns the accrued interest for a security that pays interest at maturity
4	ACOS function	Math and trigonometry	Returns the arccosine of a number
5	ACOSH function	Math and trigonometry	Returns the inverse hyperbolic cosine of a number
6	ACOT function	Math and trigonometry	Returns the arccotangent of a number
7	ACOTH function	Math and trigonometry	Returns the hyperbolic arccotangent of a number
8	AGGREGATE function	Math and trigonometry	Returns an aggregate in a list or database
9	ADDRESS function	Lookup and reference	Returns a reference as text to a single cell in a worksheet
10	AMORDEGRC function	Financial	Returns the depreciation for each accounting period by using a depreciation coefficient
11	AMORLINC function	Financial	Returns the depreciation for each accounting period
12	AND function	Logical	Returns TRUE if all of its arguments are TRUE
13	ARABIC function	Math and trigonometry	Converts a Roman number to Arabic as a number
14	AREAS function	Lookup and reference	Returns the number of areas in a reference