Excel get sheets activity

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)

Hi @Sheeraz_Areeb,

  1. Please use the below activity.

–
Mukesh

2 Likes

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

You can Check - If sheetname is not Like β€˜Sheet4’ - Then only Process.

also ,Update the TypeArguement of Foreach to - String

image

–
Mukesh

Thanks

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)

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.

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

Hi @Sheeraz_Areeb

Check the attached xaml
Main.xaml (7.9 KB)

1 Like

Thank you very much i was looking for that only

You are welcome :slightly_smiling_face:

1 Like

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