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)
- Please use the below activity.
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
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
Thank you very much i was looking for that only
You are welcome
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.