Analysis for Microsoft Excel Design panel

[suresh_panneer_selva (Usap)]

Hi,

I am using Analysis for Excel tool for uipath automation. Where I will connect the tool to SAP environment and fetch a workbook. In the workbook I select “Display Design panel” after the selection I have to make a selection(Column) in Data source and right click at select “Add to column”. I am unable to make a column selection in Data source. Any help how I need to handle this.

I had tried with different combination. Select item activity, Click activity,search in Find tab.

[MateuszSzatkowski (M Szatkowski)]

Hi Suresh,

Could you provide workflow of this process you just described?

[lakshman (Ganta lakshman)]

@suresh_panneer_selva

If possible can you please share screenshot of that window. So that we can look and help you.

[suresh_panneer_selva (Usap)]

Unfortunately I am unable to take screen shot due to restrictions

[anmita]

Hello @suresh_panneer_selva
I am having a similar scenario could you share which method you have used to solve this issue

Thanks in advance!!!

[Riyas.Muhammed (Muhammed Riyas)]

May be this will help

SAP Analysis for Excel use

Normally we use “Excel Application Scope” activity to run the VBA, but Analysis & Analysis Design tabs will not be available while we are using “Excel application Scope” activity. To use Analysis tab and run any VBA codes with SAP Analysis in the excel, use “Open Application” activity to open blank excel workbook then brows the excel file. Once the file is opened, use “Excel Application Scope” activity and open the same excel file. Now we can see the Analysis & Analysis Design tabs. [image] […