NetOffice icon indicating copy to clipboard operation
NetOffice copied to clipboard

Add powerquery to the workbook object model

Open sylvainpiron opened this issue 5 years ago • 2 comments

Hi, Is it possible to add powerquery to the object model? You can access it with interop by using late binding like this:

dynamic wb = app.ActiveWorkbook;
int cnt = wb.queries.Count;
System.Diagnostic.Debug.Print(cnt.ToString());

Thanks, Best regards Sylvain PIRON

sylvainpiron avatar May 20 '20 13:05 sylvainpiron

Thanks for noticing there is a new API in Excel 2016 for this feature.

I don't have ETA when this could be implemented, it mostly depends on how large is this new API surface.

jozefizso avatar May 20 '20 14:05 jozefizso

Released in https://github.com/NetOfficeFw/NetOffice/releases/tag/v1.9.4

jozefizso avatar Nov 17 '23 13:11 jozefizso