How to keep the specified sheet in excel?

Help Activities
, , , ,
1

Hi,

I have excel with multiple sheets which will be in specified name.
I have to keep only specified 2 name sheet in the same excel file.

Can someone guide me on this?
Thanks

2

@jamuna_T
check this reference

try this flows steps:
Excel Application Scope (Path: “your_file_path.xlsx”)
Get Workbook Sheets (Output: sheetNames)
Assign: sheetsToKeep = New List(Of String) From {“Sheet1”, “Sheet2”}
For Each (item in sheetNames)
If: Not sheetsToKeep.Contains(item)
Then: Delete Sheet (SheetName: item)
End

1 Like
3

Hi @jamuna_T

Can you try like below

CurrentSheet.Name.Equals("Sheet1") Or CurrentSheet.Name.Equals("Sheet2")

This image depicts a UiPath automation workflow designed to iterate through all sheets in an Excel file and delete any sheet that is not named "Sheet1" or "Sheet2". (Captioned by AI)
This image depicts a UiPath automation workflow designed to iterate through all sheets in an Excel file and delete any sheet that is not named "Sheet1" or "Sheet2". (Captioned by AI)900×1492 45.4 KB

Sequence15.xaml (18.4 KB)

Regards,

1 Like
4

Thanks for the response , could you please provide this as a Xaml

5

Please find attached xaml . Hope this helps. Also kindly mark Resolved if it resolves your query. Thanks !!
Main 1.xaml (13.7 KB)

1 Like
6

Thanks for the response, When i am trying this getting error like
Delete Sheet: Unable to get the Delete property of the Worksheet class
please assist me on this

7

@jamuna_T

Have you tried this?

Regards,

1 Like
8

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