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
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
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