-
|
I was hoping that this extension would enable me to writeback to Excel while the file is open - basically replacing the default "advanced" editor. What I am experiencing is that I can't write changes back to the file unless it's closed. Is there a mechanism from VSCode to make the Excel file "writeable" even while the Excel front end is open with the file? Or is this locked down by design? |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 1 reply
-
|
Unfortunately, Excel locks open files down pretty hard while they're open. I have the same issues editing my files, which is why I created a "watch Excel file" mechanism in the recent release. The extension is waits a configurable amount of time for you to close the file so it can sync back. This is a new feature that's largely untested, as I'm pretty disciplined about closing my files while I edit the .m code. I'm open to suggestions on how we might sync back to open files. I believe we'd have to use the Office object model, reaching pretty heavily into Windows and Office APIs. I suppose we could just brute-force it and write some RPA to open Advanced PQ editor and paste it in! That's kinda klunky and hacky though. Excel UI manipulation is unreliable at best, as is reaching into the object model. That said, I KNOW this sort of thing is done with Excel extensions. Way back in the day I used to use ShowCase / Essbase Excel extensions, and this thing created real Excel objects (querytables and pivot tables) backed with hooks to Essbase, and it just looked like a pivot table field selection with extra cube features. Might be worth investigating--an Excel extension to talk to the VS Code PQ Editor extension? I'll add this to the enhancement requests and see what I can can come up with! |
Beta Was this translation helpful? Give feedback.
-
|
...I created an issue for this. Huge project going on at work at the moment (which I created this extension for in the first place). When I come up for air I'll look into syncing back live to open files. |
Beta Was this translation helpful? Give feedback.
-
|
Wilson,
Thanks so much for the quick reply!
I hope you can make so progress to make this happen...it would be so useful....
I had been using an Excel add-in from MonkeyTools which was able to write back to Excel while the file was open, but my employer locked down the network, etc...so I can no longer use it....
The Monkey Tools developer, Ken Puls, might be a good resource for you...when you have the time.
Please keep me posted!
James
…On Thursday, October 2nd, 2025 at 11:44 AM, Wilson Cook ***@***.***> wrote:
...I created an issue for this. Huge project going on at work at the moment (which I created this extension for in the first place). When I come up for air I'll look into syncing back live to open files.
—
Reply to this email directly, [view it on GitHub](#3 (reply in thread)), or [unsubscribe](https://github.com/notifications/unsubscribe-auth/AKLVRZ5O3SW2HKS3UPE5R5L3VVB4PAVCNFSM6AAAAACIDVFXISVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTINJXGU2TCNY).
You are receiving this because you authored the thread.Message ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
Unfortunately, Excel locks open files down pretty hard while they're open. I have the same issues editing my files, which is why I created a "watch Excel file" mechanism in the recent release. The extension is waits a configurable amount of time for you to close the file so it can sync back. This is a new feature that's largely untested, as I'm pretty disciplined about closing my files while I edit the .m code.
I'm open to suggestions on how we might sync back to open files. I believe we'd have to use the Office object model, reaching pretty heavily into Windows and Office APIs. I suppose we could just brute-force it and write some RPA to open Advanced PQ editor and paste it in! That's ki…