โ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
โ08-16-2023 06:42 AM
When i try to open the link to the solution pantry it takes me to https://bloomfire.com. Did the location for the example change?
โ08-18-2023 07:34 AM
Thanks for the update, @bboren. I'll look into this!
โ06-20-2024 01:39 PM
Hi,
where can I find a tutorial to use this?
โ07-12-2024 06:55 AM
Hi @julio_jaquez,
You can explore these types of recipes in Workato's recipe library here: https://app.workato.com/browse/recipes?q=category:Python%20excel