Pull data from excel with color and other format

[Venuka]

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

[atcodedog05]

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 🙂

[Venuka]

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

[atcodedog05]

@Venuka 

Even i have faced that 😅 so its relatable 

[hsyuibe86]

Hi @Venuka 

Dis thing work out for you?I'm curious.

Thanks,