Invoke code to move worksheets

Help Activities
, ,
1

hi community,

I am finding a way to move the worksheets from one workbook to another one.

I found a vba coding but i am not allowed to use vba

therefore could share some coding for me?

Thanks.

2

@raymondhui

  1. Use Read Range activity to read it from one excel file and it will give output as DataTable. Let’s say ‘InputDT’.

  2. And then use Write Range activity and pass inputDT to write into other excel file.

3

Hi,

We can achieve it using ClosedXML (used from Excel.Activities Package), as the following.

img20211020-7
img20211020-71286×1183 17.4 KB 

wbSrc = New ClosedXML.Excel.XLWorkbook("src.xlsx")
wbDist = New ClosedXML.Excel.XLWorkbook("dist.xlsx")
ws1 = wbSrc.Worksheet("Sheet1")
ws1.CopyTo(wbDist,"NewSheetName")
ws1.Delete()
wbDist.Save()
wbSrc.Save()

note: wbSrc and wbDist is XLWorkbook type. ws1 is IXLworkSheet type.

Regards,

4

as there are many formatting in the worksheet, therefore cant use read range?

5

Hi

Did we try with activity

Cheers @raymondhui

6

Hey @raymondhui

Check this thread from stack overflow: C# - How to copy a single Excel worksheet from one workbook to another? - Stack Overflow

It’s the C# code but we can try to replicate the same in UiPath Invoke Code

Check if this helps you

7

Hey @raymondhui

PFA solution workflow for your question

Forum_Solutions.zip (15.2 KB)

Cheers,
Parth

1 Like
8

yea finally i do more steps and use this activity.

1 Like
9

Glad
Happy automation @raymondhui

10

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