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,090 points
405 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
0 answers
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 in RPA by Shivi Singhal
2,526 views
+2 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8 in RPA by Anvi
• 11,690 points
2,448 views
0 votes
1 answer

How to extract specific type of files from a directory using UiPath?

Hey @Avani, if you want to extract ...READ MORE

answered Mar 13 in RPA by Anvi
• 11,690 points
1,346 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,090 points
188 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,090 points
171 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,090 points
339 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,090 points
282 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
786 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
198 views