Convert rows to columns in uipath

Help Activities
, ,
1

Hi
I’m taking taking transpose of my excel sheet …converting rows to columns but it comes an error
How to resolve this
I need it urgently
Extracted Result.xlsx (8.7 KB)

Transpose.xaml (8.2 KB)

Screenshot (16)
Screenshot (16)1920×1080 213 KB

Screenshot (17)
Screenshot (17)1920×1080 89.9 KB

Thanks in advance

2

HI @Aima_Arif

Check out the Video link

Regards
Gokul

3

Hi @Aima_Arif

Use this directly on excel

image

cheers

1 Like
4

The following error comes by using this activity

Screenshot (18)
Screenshot (18)1920×1080 242 KB

5

Have you checked this video ? @Aima_Arif

6

Hi @Aima_Arif

May I know why did you provide any range?

You need to provide a start range atleast

cheers

7

Now I’m watching that link. Hope this will solve my issue

8

Hi @Aima_Arif

Let us know if you have any issue.

9

I’ve followed the same steps
Now this error has occurred

Screenshot (20)
Screenshot (20)1920×1080 229 KB

10

HI @Aima_Arif

Just following the below steps to enable the VBA in the excel setting

Sl.No Steps
Step 1 Open an Empty excel or any excel file
Step 2 Goto File-> Option
Step 3 Goto Trust Center → Trust Center Settings → Trusted Locations
Step 4 Click on Add new Location and browse for the folders (Project Location) and check the Sub folder of this location also trusted and click on ok
Step 5 The Location will be added in the list of trusted location and click on Ok
Step 6 Goto Trust Center → Trust Center Settings → Macro Setting, enable the Trust access to VBA project object model and click on Ok

image

Regards
Gokul

1 Like
11

Check out this video link @Aima_Arif

Regards
Gokul

1 Like
12

Thank you so so much :slight_smile:
Its working fine
Thank you again for helping me :slight_smile:

1 Like
13

I’ve one more question
If sheet 2 does not exist… How it can be Created automatically using this piece of code?
Because I’m extracting data from web and store that data in excel sheet i-e Sheet1
so when I use transpose it showing me error on line sheet 2

Screenshot (21)
Screenshot (21)1920×1080 134 KB

14

HI @Aima_Arif

Try to use invoke VBA and pass the text file.

Sub create_sheet
  Sheets.Add.Name = "New Sheetname"
End sub

Check out this blog

One topic is for one issue. You can create new topic for this issue.

Regards
Gokul

1 Like
15

Thank you :slight_smile:

16

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