How to get the Sheet name from Excel

Help
5

Hi Corneliu, please is there any documentation with listed methods and properties for objects like Workbook in UiPath? I was not able to find anything like GetSheets method in UiPath (and it is not standard workbook’s method neither as far as i know)

1 Like
6

Hi jreszetar,
What is the Version of UIPATH you are using?
I am getting the option and version is 2016.2.6143.

2 Likes
7

Hi Uday, i am using 2016.1.6040. I have already noticed that the methods are listed once i enter .(dot) after the object in assign activity. Is there also some other place where can i find the members of specific object if its not listed in activities?

1 Like
8

Could you update the Excel Activities, too?

1 Like
9

Hi Badita, I have Excel activities package version 1.2.6123.30845. i think this is the newest one as i dont see any updates available but i am not able to find GetSheets between available activities.

1 Like
10

That is not an activity.
You need to use an output Workbook variable in Excel Application Scope and then use wb.GetSheets
See attached.

Sheets.xaml (5.6 KB)

6 Likes
11

Studio 2016.1.6137, Excel activities 1.2.6123.30845, this still throws an NRE.

Attached sample - working part and throwing an NRE. The bug that Corneliu was talking about earlier is still there.

ExcelTest.xaml (12.4 KB)

5 Likes
12

I have the nu package to use but don’t know if I can share it in here. this will allow you to use sheetlist function to get all the names.

13

From technical point of view, you can (or if you can’t add it as an attachment due to user restrictions or something similar, you could upload it somewhere and post a link, or post the code to pastebin etc.).

1 Like
14

The WoorkbookApplication variable is an OutArgument and right now it is created when the activity is completed. This is why you have to use it outside the Excel Application Scope.

We will fix this in a future release.

3 Likes
15

Dear all:

I have a solution for y’all.

First, install this package.

ExcelActivities.1.0.18.nupkg (9.5 KB)

Second: open this xaml and set up the path to an excel workbook with more than one sheet.
Readsheetname.xaml (7.7 KB)

Please, please comment your findings on this.

16

Hello,
Can anyone please help me to know how to move the excel sheet to another workbook.

17

@Uma,
What about Read Range of the sheet to a datatable variable, then Write Range with that variable to the other file?

I’m sure there are a few other coding methods too.

Thanks.

1 Like
18

No i want to move the sheet only which not having any data.and i am moving that sheet which is just template and i want to move this sheet into tge another workbook.
Thanks

19

Can you have the sheet in a file by itself? Then you can use the “Copy File” Activity to use the template with other datatables.

EDIT: Or, have a template with all the sheets you need, then like I said use Copy File and Write Range to the copied file to those sheets you want.

20

My template file only have the sheet(that having the format only)and i want to add this sheet into my anther workbook.supppse my one wb contains sheet 1and i wanto add this sheet 1into my another workbook.

21

I want to do same as option of excel move or copy .
Thanks

22

Can you copy the sheet to another Workbook and delete exisiting sheet?

image

23

My Excel sheet is protected and sent in eMail. I am downloaded and trying to read data when com exception is displayed. Is there alternate way to get sheet name

24

Hello,

can you please share me the document how you made the package procedure.

1 Like