Filter excel files with no table name

Help Studio
, ,
1

Hello,

I have a really complex excel file with no table name.
I need to filter to table but it requires a table name. I tried to value it as " " but didn’t work.
Any other recommended solutions?

Thanks in advance.

2

Hi
Did we try with Macros if it has a complex structure
@dcrt

3

I am trying to use code as little as possible, as best practice.
I was curious if there is any way to do it with uipath activities.

4

It’s based on the need buddy
As your excel some complex structure as you said we can go for macros and of course we can execute that macro with two activity
Either EXECUTE MACRO or INVOKE VBA

cheers @dcrt

1 Like
5

@dcrt You can use fileList=Directory.GetFiles(“YourExcelFilePath”,“*.xlsx”) and to get sheet names make output of ExcelApplicationScope and put that output variable in ForEach like wb.GetSheets

1 Like
6

Like i said before i was trying to use as little code as possible.
So i am assuming from your answers there is no way to use filter table activity without table names or any other alternative way.
Thank you for your time.

7

@dcrt How Complex is Your Excel File :sweat_smile:

8

Seems like i am able to filter the excel with filter data table activity since it doesn’t require a table name, Thanks for your all helps :slight_smile:

2 Likes
9

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