topic Re: Product Update: Python Connector & Excel Files in Workato Pros Discussion Board

Product Update: Python Connector & Excel Files

meghan-legaspi — Fri, 18 Aug 2023 14:33:20 GMT

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

Re: Product Update: Python Connector & Excel Files

bboren — Wed, 16 Aug 2023 13:42:09 GMT

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?

Re: Product Update: Python Connector & Excel Files

meghan-legaspi — Fri, 18 Aug 2023 14:34:18 GMT

Thanks for the update, @bboren. I'll look into this!

Re: Product Update: Python Connector & Excel Files

julio_jaquez — Thu, 20 Jun 2024 20:39:20 GMT

Hi,

where can I find a tutorial to use this?

Re: Product Update: Python Connector & Excel Files

Martin_rubens — Mon, 24 Jun 2024 23:28:42 GMT

Hi,

Are there example recipes for this?

Thanks

Re: Product Update: Python Connector & Excel Files

meghan-legaspi — Fri, 12 Jul 2024 13:55:06 GMT

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

Re: Product Update: Python Connector & Excel Files

meghan-legaspi — Fri, 12 Jul 2024 13:55:33 GMT

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