Excel Read Range and Write Range is not copying over format

Help StudioX
,
1

Hello! I am copying a tab from one Excel file to another with the read range and write to Excel activities in StudioX. Still, it is not copying over the format for some reason, so the resulting data is bizarre. Has anyone experienced this? Any ideas on how to fix it would be greatly appreciated.

2

@jessika.torres

If you want format…then use copy paste ramge…use read range to understand the range that you need to copy

Cheers

3

Thank you @Anil_G
I am using Read range, and then write to excel.

4

@jessika.torres

Instead of write excel use copy paste ramge activity

Cheers