Hi there @Jon, I have a follow up on this question.
I am having a series of excel files which are quite old and I am looking to extract the data using a python script in the “code node”.
I upload the file using a “form node” first, which is fantastic.
my second option was to use “extract from file node” but I was not able to go through all the sheets in the document and to slice the data, I seemed to lack this option somehow.
so after many fails I decided to go through a hard coded python script so that I can manipulate and directly extract the data from the sheets (all have the same form).
you can see in the image bellow that I am having issues to access the file. I have used the Methods in the documentation but I cannot have access to the binary or the path to access the file.
can you please tell me how to direct the uploaded file to the code?
this is the error:
Node type
n8n-nodes-base.code
Node version
2 (Latest)
n8n version
1.81.4 (Self Hosted)
Stack trace
Error: ValueError(msg) ValueError: Invalid file path or buffer object type: <class 'pyodide.ffi.JsException'> at PythonSandbox.getPrettyError (C:\Users\RubenCasillasPacheco\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-nodes-base\nodes\Code\PythonSandbox.ts:101:11) at PythonSandbox.runCodeInPython (C:\Users\RubenCasillasPacheco\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-nodes-base\nodes\Code\PythonSandbox.ts:85:15) at PythonSandbox.runCodeAllItems (C:\Users\RubenCasillasPacheco\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-nodes-base\nodes\Code\PythonSandbox.ts:46:27) at ExecuteContext.execute (C:\Users\RubenCasillasPacheco\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-nodes-base\nodes\Code\Code.node.ts:155:14) at WorkflowExecute.runNode (C:\Users\RubenCasillasPacheco\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-core\src\execution-engine\workflow-execute.ts:1123:8) at C:\Users\RubenCasillasPacheco\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-core\src\execution-engine\workflow-execute.ts:1470:27 at C:\Users\RubenCasillasPacheco\AppData\Roaming\npm\node_modules\n8n\node_modules\n8n-core\src\execution-engine\workflow-execute.ts:2029:11