xlwings Addin Errors - “Invalid procedure call or argument” / “File not found”
I'm trying to run a python sub using the xlwings addin (v0.14.0). I have set the following parameters in the ribbon of the addin:
Interpreter: pythonw.exe
PYTHONPATH: C:Program FilesAnaconda3envsVirtualEnv
UDF Modules: mdlGetHistoricalData
When I press Import Functions I receive the "Invalid procedure call or argument 5" error.
If I change the Interpreter parameter to be blank (it should default to pythonw.exe) I receive the error "File not found: xlwings32-0.14.0.dll 53", this file is currently located inside the virtual environment package specified in PYTHONPATH. I have tried placing it in my Python project location as well, but I still recieve this error.
Is there something wrong with my parameters in the addin? Or is there something else wrong here?
Facts:
- I'm using xlwings 0.14.0 in my virtual environment and the ribbons
version is identical. - I'm using Python 3.6 in my virtual environment
- I've used the "@xw.sub" identifier in my Python script
- I have also tried stepping through Py.CallUDF and RunPython in VBA and receive identical errors
python excel vba xlwings
asked Nov 14 '18 at 11:18
17DOWN17DOWN
168
add a comment |
I'm trying to run a python sub using the xlwings addin (v0.14.0). I have set the following parameters in the ribbon of the addin:
Interpreter: pythonw.exe
PYTHONPATH: C:Program FilesAnaconda3envsVirtualEnv
UDF Modules: mdlGetHistoricalData
When I press Import Functions I receive the "Invalid procedure call or argument 5" error.
If I change the Interpreter parameter to be blank (it should default to pythonw.exe) I receive the error "File not found: xlwings32-0.14.0.dll 53", this file is currently located inside the virtual environment package specified in PYTHONPATH. I have tried placing it in my Python project location as well, but I still recieve this error.
Is there something wrong with my parameters in the addin? Or is there something else wrong here?
Facts:
- I'm using xlwings 0.14.0 in my virtual environment and the ribbons
version is identical. - I'm using Python 3.6 in my virtual environment
- I've used the "@xw.sub" identifier in my Python script
- I have also tried stepping through Py.CallUDF and RunPython in VBA and receive identical errors
python excel vba xlwings
asked Nov 14 '18 at 11:18
17DOWN17DOWN
168
1
Look more closely at the docs: docs.xlwings.org/en/stable/addin.html#global-settings: Interpreter is the full path and PYTHONPATH is where your modules are.
– Felix Zumstein
Nov 14 '18 at 13:50
Thanks for the reply Felix. I made the required changes and now I get an error which reads: "Python process exited before it was possible to create the interface object ... the command .. Working Dir: <unspecified> 1000"
– 17DOWN
Nov 19 '18 at 9:49
1
I found the answer to my problem in another one of your answers. I had my PYTHON path set to Z: instead of Z:\ stackoverflow.com/questions/38983144/…
– 17DOWN
Nov 19 '18 at 11:57
add a comment |
I'm trying to run a python sub using the xlwings addin (v0.14.0). I have set the following parameters in the ribbon of the addin:
Interpreter: pythonw.exe
PYTHONPATH: C:Program FilesAnaconda3envsVirtualEnv
UDF Modules: mdlGetHistoricalData
When I press Import Functions I receive the "Invalid procedure call or argument 5" error.
If I change the Interpreter parameter to be blank (it should default to pythonw.exe) I receive the error "File not found: xlwings32-0.14.0.dll 53", this file is currently located inside the virtual environment package specified in PYTHONPATH. I have tried placing it in my Python project location as well, but I still recieve this error.
Is there something wrong with my parameters in the addin? Or is there something else wrong here?
Facts:
- I'm using xlwings 0.14.0 in my virtual environment and the ribbons
version is identical. - I'm using Python 3.6 in my virtual environment
- I've used the "@xw.sub" identifier in my Python script
- I have also tried stepping through Py.CallUDF and RunPython in VBA and receive identical errors
python excel vba xlwings
asked Nov 14 '18 at 11:18
17DOWN17DOWN
168
I'm trying to run a python sub using the xlwings addin (v0.14.0). I have set the following parameters in the ribbon of the addin:
Interpreter: pythonw.exe
PYTHONPATH: C:Program FilesAnaconda3envsVirtualEnv
UDF Modules: mdlGetHistoricalData
When I press Import Functions I receive the "Invalid procedure call or argument 5" error.
If I change the Interpreter parameter to be blank (it should default to pythonw.exe) I receive the error "File not found: xlwings32-0.14.0.dll 53", this file is currently located inside the virtual environment package specified in PYTHONPATH. I have tried placing it in my Python project location as well, but I still recieve this error.
Is there something wrong with my parameters in the addin? Or is there something else wrong here?
Facts:
- I'm using xlwings 0.14.0 in my virtual environment and the ribbons
version is identical. - I'm using Python 3.6 in my virtual environment
- I've used the "@xw.sub" identifier in my Python script
- I have also tried stepping through Py.CallUDF and RunPython in VBA and receive identical errors
python excel vba xlwings
python excel vba xlwings
asked Nov 14 '18 at 11:18
17DOWN17DOWN
168
asked Nov 14 '18 at 11:18
17DOWN17DOWN
168
asked Nov 14 '18 at 11:18
17DOWN17DOWN
168
asked Nov 14 '18 at 11:18
17DOWN17DOWN
168
asked Nov 14 '18 at 11:18
17DOWN17DOWN
168
168
1
Look more closely at the docs: docs.xlwings.org/en/stable/addin.html#global-settings: Interpreter is the full path and PYTHONPATH is where your modules are.
– Felix Zumstein
Nov 14 '18 at 13:50
Thanks for the reply Felix. I made the required changes and now I get an error which reads: "Python process exited before it was possible to create the interface object ... the command .. Working Dir: <unspecified> 1000"
– 17DOWN
Nov 19 '18 at 9:49
1
I found the answer to my problem in another one of your answers. I had my PYTHON path set to Z: instead of Z:\ stackoverflow.com/questions/38983144/…
– 17DOWN
Nov 19 '18 at 11:57
add a comment |
1
Look more closely at the docs: docs.xlwings.org/en/stable/addin.html#global-settings: Interpreter is the full path and PYTHONPATH is where your modules are.
– Felix Zumstein
Nov 14 '18 at 13:50
Thanks for the reply Felix. I made the required changes and now I get an error which reads: "Python process exited before it was possible to create the interface object ... the command .. Working Dir: <unspecified> 1000"
– 17DOWN
Nov 19 '18 at 9:49
1
I found the answer to my problem in another one of your answers. I had my PYTHON path set to Z: instead of Z:\ stackoverflow.com/questions/38983144/…
– 17DOWN
Nov 19 '18 at 11:57
1
1
Look more closely at the docs: docs.xlwings.org/en/stable/addin.html#global-settings: Interpreter is the full path and PYTHONPATH is where your modules are.
– Felix Zumstein
Nov 14 '18 at 13:50
Look more closely at the docs: docs.xlwings.org/en/stable/addin.html#global-settings: Interpreter is the full path and PYTHONPATH is where your modules are.
– Felix Zumstein
Nov 14 '18 at 13:50
Thanks for the reply Felix. I made the required changes and now I get an error which reads: "Python process exited before it was possible to create the interface object ... the command .. Working Dir: <unspecified> 1000"
– 17DOWN
Nov 19 '18 at 9:49
Thanks for the reply Felix. I made the required changes and now I get an error which reads: "Python process exited before it was possible to create the interface object ... the command .. Working Dir: <unspecified> 1000"
– 17DOWN
Nov 19 '18 at 9:49
1
1
I found the answer to my problem in another one of your answers. I had my PYTHON path set to Z: instead of Z:\ stackoverflow.com/questions/38983144/…
– 17DOWN
Nov 19 '18 at 11:57
I found the answer to my problem in another one of your answers. I had my PYTHON path set to Z: instead of Z:\ stackoverflow.com/questions/38983144/…
– 17DOWN
Nov 19 '18 at 11:57
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53298977%2fxlwings-addin-errors-invalid-procedure-call-or-argument-file-not-found%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53298977%2fxlwings-addin-errors-invalid-procedure-call-or-argument-file-not-found%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Look more closely at the docs: docs.xlwings.org/en/stable/addin.html#global-settings: Interpreter is the full path and PYTHONPATH is where your modules are.
– Felix Zumstein
Nov 14 '18 at 13:50
Thanks for the reply Felix. I made the required changes and now I get an error which reads: "Python process exited before it was possible to create the interface object ... the command .. Working Dir: <unspecified> 1000"
– 17DOWN
Nov 19 '18 at 9:49
1
I found the answer to my problem in another one of your answers. I had my PYTHON path set to Z: instead of Z:\ stackoverflow.com/questions/38983144/…
– 17DOWN
Nov 19 '18 at 11:57