OfficeJS add Formula property to Query object

OfficeJS add Formula property to Query object
1

Upvotes

Upvote

 Jul 26 2022
0 Comments 
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).