I am trying to copy particular range of values from Excel 1 to Excel 2. But while writing range in Excel 2, it is not retaining the cell formatting(cell color codes) in Excel 2.
Currently I’m using read range and Write range activities to copy paste the content.
Is there any other alternative that I can use to retain the color codes and other formatting.
PS: I cannot copy/paste the entire sheet, because the sheet in Excel 2 contains other data as well.