Excel get sheets activity

Help
, ,
1

Hello i want to take out all sheet except last one how can i do it i am sharing my file i just want sheet 1,sheet 2, and sheet 3, but i dont want final sheetMain.xaml (6.5 KB) School-Fee-Slip-Format-in-Excel-Template.xlsx (15.7 KB)

2

Hi @Sheeraz_Areeb,

  1. Please use the below activity.

https://docs.uipath.com/activities/docs/gsuite-delete-sheet

–
Mukesh

2 Likes
3

Thanks for replying i have 4 sheets i just want to exclude last sheet because i want to extract data from first three sheets and put in 4th sheet

4

You can Check - If sheetname is not Like ‘Sheet4’ - Then only Process.

also ,Update the TypeArguement of Foreach to - String

image

–
Mukesh

5

Thanks

6

HI i have 4 sheets i just want to exclude last sheet because i want to extract data from first three sheets and put in 4th sheetSchool-Fee-Slip-Format-in-Excel-Template.xlsx (15.7 KB)Main.xaml (6.5 KB)

7

Is the sheet name of the sheet you wanna exclude is fixed?
If so workbook.getsheets will give you array of all sheet
for loop it
if condition to read only from your desired sheets
finally write to 4th sheet

Note: here workbook is the output variable of the excel application scope used.

8

i tried sheet.count(-1) but not working is it possible

9

Hi @Sheeraz_Areeb

Check the attached xaml
Main.xaml (7.9 KB)

1 Like
10

Thank you very much i was looking for that only

11

You are welcome :slightly_smiling_face:

1 Like
12

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