Hello,
I have a excel validation file with data in color and strike offs etc., Now I would like to pull excel data with same format. Please find below screenshot and suggest how can we pull the data with same format into alteryx or is there any way to send output with existing input excel file format.
Thanks & Regards,
Venuka
Hi @Venuka
You can overwrite and preserve the formatting with below option in output tool.
By checking the option preserve formatting on overwrite.
Hope this helps 🙂
Hi @atcodedog05
Thank you So much for quick response.
Preserve formatting option Is not there in the version 2019.2 but its there in 2020.2.
I have tried with that option, but its not coming in the color which I have shown in the pic and strike-out is not working.
Thanks & Regards,
Venuka