How to Get names of Excel worksheets

[Naoneko (Naoko Sumida)]

Hello, I’m a beginner.
I have an Excel Workbook with many worksheets.
In my Excel Workbook, there are over 50 Worksheets.
I want to make PDF files from some worksheets(1 Worksheet to 1 PDF file) by robots.
Names of PDF files are from names of worksheets.

I think as follows:
(1) Use Excel Application Scope to my Excel Workbook
(2) Assign Output of (1) to variable1(UiPath.Excel.WorkbookApplecation)
(3) To get All Worksheets, use GetWorkSheets function, like “variable1.GetSheets”.

Then Error occurred “Exception from HRESULT: 0x80004002 (E_NOINTERFACE)”.
Message is “Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel.Worksheet’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D8-0000-0000-C000-000000000046}’ failed due to the following error: Exception from HRESULT: 0x80004002 (E_NOINTERFACE)”.

Please teach me how to get names of Excel WorkSheets and convert worksheets to pdf files!

[Niket_Ghai]

HI!
this might Help!

How to read the different sheet names in excel

Do you want to read the Data inside different sheets or you want the names of the sheets?

Also see if you have installed the required packages…i.e. Excel activities package.

[sarathi125 (Parthasarathi)]

Hi,

Check this link,

How to get the Sheet name from Excel

Eduardo Bernabe Sacahui Diaz September 26, 2016 20:45 NONE Hello !!! Friends!!! I have so far two assigns and a for each and I am trying to get the sheet name or names of an specific workbook. thanks for the help. ====first assigng ==== myinfo = new Workbookinfo() this variable type is classexcelActivities.woorkbook also tried the interop.excel.workbook - ====second assing ==== ListofSheets = myinfo.getSheetList(mypath.tostring) this variable type is a list of strings - ====and …

It may help you understand the scenario in a better manner

[Naoneko (Naoko Sumida)]

Thanks for your reply!
I have installed Excel activities package.
My sample robot well done for a workbook with one worksheet, but with a workbook with many worksheets Error occurred!

Do I need any packages?

[Rishabh_Lakhera]

Hey @Naoneko

Try these!

Is it possible to convert a excel file to PDF using UiPath

I’m trying to use this in a workflow, but am not sure how to utilize the ‘Invoke power shell’ activity with UiPath. It works fine when I save it as a .ps1 file and execute with powershell, but I tried putting it into UiPath and it didn’t work. I tried by putting the entire script into the CommandText input, made the TypeArgument System.Management.Automation.PSObject, changed all double quotes " to single quotes ’ and made sure the box IsScript was checked. Sometimes it runs fine with no errors.…

[Rishabh_Lakhera]

Get sheet names in this manner!
SheetNames.xaml (7.8 KB)

Cheers.

[Naoneko (Naoko Sumida)]

Thanks for your reply and sample file.
But in your sample, I have changed file name to my excel file, same error occurred.

[Naoneko (Naoko Sumida)]

Thanks Everyone.
I am Naoneko.
I get an answer, but it is let me down.

Samples and my robot are correct.
But they do not work for my Excel workbook.
There is 1 Graph Sheet in my Excel workbook.
My robot works well for Table worksheets, but cannot work for a Graph worksheet.

Anyone has other answers?
If you have other answers, reply me!

[Stephu]

@Naoneko: Any solution found?