This topic was automatically generated from Slack. You can find the original thread here.
How do we deal with this? Lack of dependency
An error occurred: Missing optional dependency ‘openpyxl’. Use pip or conda to install openpyxl.
It seems like you’re encountering an error related to a missing Python package openpyxl, which is commonly used for reading and writing Excel files. In Pipedream’s environment, you don’t have the ability to directly install packages using pip or conda like you would in a traditional development environment. However, you can use Python code steps in Pipedream workflows, and for most standard libraries and packages, they are pre-installed or can be imported directly without manual installation. If you’re trying to use openpyxl within a Pipedream Python code step and encountering this issue, it’s possible that openpyxl might not be supported directly in the Pipedream environment. In such cases, you might need to look for alternative methods to achieve your goal, such as using Node.js steps if applicable or reaching out for specific support regarding library availability. For tasks specifically requiring openpyxl or if you’re working with Excel files and need functionalities that openpyxl provides, I recommend reaching out to Pipedream support or submitting a feature request for the inclusion of openpyxl or similar functionalities within the Pipedream environment. You can submit a feature request or seek further assistance by visiting Pipedream Support. Remember, Pipedream’s capabilities are continually evolving, and user feedback is valuable for enhancing the platform’s features and supported libraries.
Hi , try adding:
import openpyxl
in your python step, it should install the optional package