topic Re: Can I export to .xlsx / percentage in Alteryx Designer Desktop Discussions

Can I export to .xlsx / percentage

Hamder83 — Mon, 07 Mar 2022 14:12:23 GMT

Hi

Is it possible to export to a excel file, in a format that excel automatically will read as percentage? Without having to set it in excel?

Kind regards

Re: Can I export to .xlsx / percentage

apathetichell — Mon, 07 Mar 2022 14:43:13 GMT

In Alteryx out of the box - or using XlsxWriter/Python? https://xlsxwriter.readthedocs.io/format.html

I've never done it in XlsxWriter but it should be possible. It's not possible in standard Alteryx.

Re: Can I export to .xlsx / percentage

CathyS_Slalom — Mon, 07 Mar 2022 21:34:09 GMT

Hi @Hamder83, you can format the excel first and then use the output data tool and select Preserve Formatting on Overwrite.