OfficeJS add Formula property to Query object

OfficeJS add Formula property to Query object
2

Upvotes

Upvote

 Jul 26 2022
1 Comments (1 New)
New

I'd like to suggest to add a Formula property to the Query object so I might read and write M code of a query. VBA already has this property and given that Excel on-line will gain traction if it comes to editing queries this is a useful addition. I can then write code that updates a query when the user edits a column name in a table (for instance). Or I can write an add-in which inserts a new query into an Excel workbook (this also requires a QueriesCollection.Add method).

Comments
Copper Contributor

I would also like this please.