01-19-2023 07:52 AM - edited 08-18-2023 07:33 AM
Hey Pros!
Happy to announce a simple but important upgrade to our Python connector to support the parsing and handling of Excel files (as compared to simple CSV files).
Excel is the most popular spreadsheet tool in the world and is common in almost any business function, from marketing to finance. Now, users are able to work with two libraries - xlrd and openpyxl to read/write data to/from excel files. These libraries also open up another set of use cases with our recently announced Pandas libraries for data manipulation and transformation. Any customers using the Python connector should find this useful to expand the types of files they can parse data using the Python connector.
Please reach out to your Workato rep if you have any questions and reply below to let us know your thoughts!
Cheers,
Meghan
06-24-2024 04:28 PM
Hi,
Are there example recipes for this?
Thanks
07-12-2024 06:55 AM
Hey @Martin_rubens!
You can find these types of recipes in Workato's recipe library here: https://app.workato.com/browse/recipes?q=category:Python%20excel