Excel format issue - formulas impacted in Destination file

Help Activities
, ,
1

Hi,

How to copy (original format) of a an excel rows from one excel sheet which always has dynamic number of rows and paste to another excel without changing the source format

I tried with preserve format in Read range activity which is not working - any suggestions .

2

what is the issue you are facing with preserve format?

3

Hello @monishanair2010 , Try copy-paste activity to copy all data without any changes in format.
image
image
In Property, You can customize the data you need , in CopyItems
Note: Copy / Paste range activity should use in the Excel application scope

4

Hi @monishanair2010

Try this solution it could be useful for you :

  1. set static excel template with a specific format for all rows
  2. the robot takes the copy from the template to another folder
  3. read the needed table and write it to the copied template
5

Copy Paste range not working for copy data to another excel sheet

6

Hello @monishanair2010 , Try the copy paste actvity in Modern excel activities.
Nested Excel scope, you pass the formula from one excel to another excel sheets. Kindly refer this flow, You may got some Idea.
CopypasteFormula.zip (80.4 KB)

Happy Automation

Regards,
Gokul Jai

1 Like
7

Hi Gokul, I don’t find modern excel activities in manage packages ? am I missing something here, I have studio version of 2020 is that the reason.

8

@monishanair2010
1.Click View option on Activity panel
2. Chech the Show modern.
3. Now you can find the modern activities

image
image343×577 10.9 KB

9

Yes I did select and below activities only available
image

10

@monishanair2010 Check App integration >Excel
image

And also update your Excel packages

1 Like
11

Thank you Gokul, It worked great :slight_smile:

12

@monishanair2010
Happy Automation :smiley:

1 Like
14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.