How to delete some specific sheets from an existing excel file using vb.net code?

0 votes

I was trying the below vb.net code to delete some specific sheets from an excel file but it doesn't give me the result what I expected. Actually I need to add that vb.net code into 'Invoke vba' activity in UiPath

Jul 27, 2018 in RPA by wrecker
• 3,110 points
831 views

1 answer to this question.

0 votes
You can create a output of Excel application scope workbook as ExcelWorkbook

Using ExcelWorkbook.GetSheets you get the sheets, iterate it with for each loop as foreach item in ExcelWorkbook.GetSheets

now you have a every single worksheet name you can perform delete operation or also skip it

Thanks!! Might it help you
answered Jul 27, 2018 by Atul
• 5,530 points

Related Questions In RPA

0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 27,740 points
1,125 views
0 votes
1 answer

How to extract table and text from pdf file and load into Excel by using workbench commands in automation anywhere

Hey Dhruv, to extract table and text ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 27,740 points
616 views
0 votes
1 answer

How to open an excel file with a dynamic file name such that the file name is FXTB-(date today) using UI Path.

Hey Alza, I am trying to understand ...READ MORE

answered Oct 14, 2019 in RPA by Abha
• 27,740 points
250 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
4,195 views
0 votes
1 answer

UiPath - Citirx Automation

best way to do that is to ...READ MORE

answered Apr 13, 2018 in RPA by wrecker
• 3,110 points
274 views
0 votes
1 answer

UiPath - Web Scraping

Multiple solutions are listed below: Check your Selector Use ...READ MORE

answered Apr 13, 2018 in RPA by wrecker
• 3,110 points
358 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
529 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
438 views
+1 vote
1 answer

Looping on URLs from Excel file using UiPath

you have a Excel file with a ...READ MORE

answered Jul 25, 2018 in RPA by Atul
• 5,530 points
1,129 views
0 votes
1 answer

Changing a specific column of an excel sheet in UiPath

You can use a For each row ...READ MORE

answered Jun 21, 2018 in RPA by Atul
• 5,530 points
272 views