amalanov / editexcelpqm Goto Github PK
View Code? Open in Web Editor NEWVisual Studio Code plugin to edit Power Query M code stored inside xlsx/xlsm file
License: MIT License
Visual Studio Code plugin to edit Power Query M code stored inside xlsx/xlsm file
License: MIT License
For instance non-activated office can cause such problem.
Reproduce steps:
this results in handled error: .Queries field of activeX worksheet object is undefined.
When you close popup and follow the procedure again, it works.
In order to close Excel I do the following
if (this.excel && this.excel.Workbooks.Count !== undefined && this.excel.Workbooks.Count === 0){
this.logger("All workbooks are closed. Close Excel also.");
this.getExcel().DisplayAlerts = false;
this.getExcel().Quit();
this.excel = undefined;
}
but it remains in system monitor.
EditExcelPQM: Hi! This is Sasha. Erro occured on load of winax module. This is native node module. This could happen due to update of VSCode Electron version. In this case you need either to download a new version from my repo or change electron version in nmp task build_winax_for_vscode and then run in Windows command line nmp build_vscode_extension && nmp pack_extension so the error is.... The module '\?\c:\Users\VP.vscode\extensions\amalanov.editexcelpqm-1.1.6\node_modules\winax\build\Release\node_activex.node' was compiled against a different Node.js version using NODE_MODULE_VERSION 85. This version of Node.js requires NODE_MODULE_VERSION 89. Please try re-compiling or re-installing the module (for instance, using npm rebuild
or npm install
).
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.