Format as it is

I have used read and write range activity
But format is changed when write data in another sheet.
I want to as it is format in another sheet.
I also used preserve format but not run properl.

Hi

Try using Write Range activity from System >> File >> Workbook . You should use the Read Range activity under the System too.

Regards,
Dhanush

@AsadPathan2665 ,

Did you use Excel application scope for both read / Write or Workbook for both read / write?
Make sure you are using same for both the operations.

Yes both I have used excel application scope

Hi @AsadPathan2665 ,

Could you let us know How exactly the Format changes ? Is there a Change in the values, numbers, currencies ?

No. 003701027608
Write another sheet only- 3701027608

Hi

Use workbook activities in that read range and write range don’t use excel activities

Regards,
Dhanush

Numbers
Before- 003701027608
After- 3701027608

Hi @AsadPathan2665

Try to change the cell format after pasting it in another sheet using Change cell format activity.

Go to Manage package → Install Balareva.Excel.Activities

REgards
Gokul