Reading excel data without sheet name

Help
1

Hi Team,

Is it possible to read excel data without having the sheet name, and also can bot read the heading of the excel which has no cell value.

Please suggest any solution,
Thanks

2

Sheet name is required in reading data in excel activities, If your sheet names are dynamic you can get sheet names using .net functions - e.g workflow is available at - How to Get names of Excel worksheets - #6 by Rishabh_Lakhera

You can also try excel activities such as - https://gallery.uipath.com/packages/BalaReva.Excel.Activities/

Please elaborate more, screenshot will help.

3

@kuldip.gohil Thank you so much for quick reply.

I have checked in the properties “Microsoft Excel 97-2003 Worksheet (.xls)” this is the format in which sheet name not showing.

In excel sheet “word-art” is there which doesn’t have the cell value, so is there any way to read that word-art text.

4

Can you please upload the excel file you are referring to where sheet name is not there? If you have security restrictions, remove actual data from excel and upload test data into it.

5

@Madhavi Please find the sample excel which doesn’t have the sheet name. Excel without sheet name.xls (39.5 KB)

6

I think this is a work sheet file.

7

@ShivpujanK If file reads dynamically means. The file which you shared is having two sheets that is Customer and Sheet1

8

@indra Thank you, I think I can extract the data now.

But still finding the solution for “How to extract word art text from excel”.

9

@ShivpujanK Sheet names are exiss in this excel. But they are set to be hidden in the excel settings. Refer below link. You will find a section “The Show sheet tabs setting is turned off”. Follow the steps specified and enable the sheet tab display. You can see sheets.

In UiPath, even though sheets are not displaying, you can use Get workbook sheets activity and refer to the first sheet from the result.

1 Like
10

@Madhavi Thank you so much for your reply. It was helpful your effort is appreciated.

Can you suggest on this issue as well : “How to extract word art text from excel sheet”.
The main problem is that word art doesn’t have the cell value, so how to automate it.

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.