Excel activities question

Help Studio
,
1

Hi,
From Excel work book with formulas, I did the following Uipath sequence.

  1. Delete empty Sheet1 using a macro
  2. Copy data Sheet1 to Excel work book using Uipath activitiy
    Now Excel sheet Formulas do not calculate based on the data in the copied sheet. They show #REF!
    Can you please advice. Thanks a lot!
2

Hey @A_Learner!! First read the formula then paste into the new excel!! Use this activity:

image
image776×255 6.5 KB

Hope it helps!!

3

Thank you! It does not work.
The sheet to be copied is not exactly in Excel format. It has multiple tables with cells extending over multiple colums etc. Thanks,

4

Hi!

Could you please provide us the sample input and expected output. so that we can help you. if those details are confidential please provide with the dummy input data.

Regards,
NaNi

5

Hi @A_Learner

Also share the sample input and expected output file

Regards
Gokul

6

Thank you. Is there a way to keep excel book1 open, select sheet2, ctrl +C to select all the content, open excel book2, do ctrl + V?

Thanks a lot,

7

Hi!

Follow the below steps.

1.Excel Application Scope
2.Read Range->Read first sheet (“Book1”) output as Dt_1
3.Read Range->Read second sheet (“Book2”) output as Dt_2
4.Take one For each row in Data table read Dt_1
5.Take one send hot key and indicate it on Excel (CTRL+C)
6.Take one more For each row in Data table read Dt_2
7.Now take send hotkey and indicate it on second excel i.e, Book2 (CTRL+V).
Regards,
NaNi

8

Thank you. Will try.

9

Thank you. When I delete the sheet, all formulas in other sheets getting REF error. Also, Excel would not let me paste new sheet with the same name which is needed for the formulas.