Excel Text to Column function through UiPath

Help Studio
1

Hi all, have a datatable that needs to go through text to columns before becoming usable but is there a way to do it through UiPath Studio? I’ve googled and they say there’s an activity for it but my personal UiPath studio does not have it, not even when i search for packages to download.

Can anyone help?

image
image290×723 3.52 KB

Needs a line break (Ctr + J) to properly break into columns

2

Hello @2101065g

Welcome to UiPath community…!

Please watch the below video.

Thanks

3

it says to use Text to Columns activity which I do not have.

image
image386×582 2.75 KB

4

I have tried searching for it under Manage Packages but still have nothing

image
image1120×637 16 KB

5

can you click on the filter button and enable all categories? Also are you using studiox or studio?

Thanks

6

Yep have tried checking under all packages, still nothing

image
image1122×632 15.8 KB

Per my class’s requirement, I am using Studio and not StudioX

7

Try to create a new project and check it once. Hope you have created a Windows Compatibility project.

Also share the studio version.

Thanks

8

made a new project, still the same result. can’t find the activity anywhere
image

9

it doesn’t seem to be a community edition. Hope you are trying to use the community ediiton. If yes, please check the below video and download the community edition.

Thanks

10

The academic version I’ve installed is per the reuirements of my course and so I am unable to use the community version