How To Enable This Feature in excel through uipath studio

Help Studio
, ,
1

Hi,

I want enable this feature after completion of bot run.

Click on any cell of in excel — Click Design— Click show in tabular form

Im not sure whether we can do with macros or not any other approaches please

Attached Snapshot below

image
image1086×427 23 KB

2

Hi @Putta_Sri_Sai_Rishik_Chow

You can do it with Macros

or

Use click and Key board shortcuts

Regards,

3

Hi @Putta_Sri_Sai_Rishik_Chow

=> Then take the Use application\browser activity and pass the excel file path in URL.
=> Inside use application\browser activity place the click activities and indicate the elements by Ui element approach.

Check the below workflow for better understanding.
Browser_Practice.xaml (23.3 KB)

Browser_Practice
Browser_Practice880×908 67.3 KB

It works for me…

Hope it helps!!

4

Hi @Putta_Sri_Sai_Rishik_Chow

  1. Open the Excel file where you want to enable the “Show in Tabular Form” feature.
  2. Create a new VBA macro to enable “Show in Tabular Form” for the specific sheet. The VBA code to enable the “Show in Tabular Form”

Sub EnableShowInTabularForm()
’ Replace “Sheet1” with the actual name of the sheet where you want to enable the feature
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets(“Sheet1”)

ws.ListObjects.Add(xlSrcRange, ws.Range("A1").CurrentRegion, , xlYes).Name = "Table1"

End Sub

  1. Save the Excel file with the VBA macro-enabled as a .xlsm (Macro-Enabled Workbook) file.
  2. In UiPath, use the “Excel Application Scope” activity to open the .xlsm file.
  3. Use the “Invoke VBA” activity within the “Excel Application Scope” to execute the VBA macro and enable the “Show in Tabular Form” feature.

Hope it helps!!

5

I want to use this macro in different sheets and in different workbooks pravallika…

Is it possible…?

6

You can use with the changing parameters like sheetname…

7

hi @mkankatala

I want to use it in different excels with different sheets…(not with one excel sheet)

8

Thats fine…

If you have send me one sample xaml that would be appreciated… and i can know in a better way so that we can close this topic.Thanks.

9

Then Store the List of files in a List Datatype variable.
Then use for each to iterate the List Variable.
Then Pass the CurrentItem in the Application arguments option. Then it will take one by one file path.

Hope you understand!!