Deepl api for whole excel file

[Anudi]

Hi!

I want to use the deepl API to translate whole Excel sheets. I've already found this community https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DeepL-translator-API/td-p/8193...

But the macro shown there only takes a single colomn as input, what I need is a tool that ready in a whole excel file and outputs a translated one (without losing formatting), does anyone know how to implement this?

[KGT]

I've never used this, or investigated DeepL, and so haven't seen a pre-built solution, but looks like they post the details of the API pretty accessible.

That macro just constructs the text into a string to parse to the API. 

Using this: https://developers.deepl.com/docs/api-reference/translate

You are probably looking for this: https://developers.deepl.com/docs/api-reference/document

Otherwise, you can make your file into one text field (with delimiter) and pass that to the translate API