Pull data from excel with color and other format

Question

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

2020-12-01_16-09-53.png

hsyuibe86 · Answer

Hi @Venuka

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

Thanks,

atcodedog05 · Answer

@Venuka

Even i have faced that 😅 so its relatable

Venuka · Answer

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