amalanov / editexcelpqm Goto Github PK

For instance non-activated office can cause such problem.
Reproduce steps:

• open vs code
• click right button on xlsx
• call Excel->M menu item

this results in handled error: .Queries field of activeX worksheet object is undefined.
When you close popup and follow the procedure again, it works.

When I try to extract the M code from an .xslm file, I get an error message:

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.

Errors

• Right click context menu doesn't have commands for .xlsx files
• When command is run directly from pallet get this error:

Detailed Error:

Detailed Error Text:

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).