Cannot find UiPath.Excel.Activities.Business.ExportExcelToCsvX

Help Activities
, ,
1

Hello,

I am trying to export an excel into a csv format but cannot find the package UiPath.Excel.Activities.Business.ExportExcelToCsvX in manage packages? I have used write to csv however I would like to use the UiPath.Excel.Activities.Business.ExportExcelToCsvX package in order to attempt preserving the format of the data. Does anyone know how to get this package?

1 Like
2

Hi

If you are using the latest studio version it would come by default under excel package
So make sure you have the excel package installed
Go to design tab → manage package and see whether UiPath.excel.activities is installed
If not search and install

Cheers. @E.T.S

3

Hi,

Thank you for your reply!

I don’t seem to have that option:
image

1 Like
4

Hope u have excel package installed @E.T.S
Check under manage packages in design tab

1 Like
5

grafik
giving us:
grafik

1 Like
6

U can directly search in activity panel as Export to Csv if u have the excel package installed
@E.T.S

1 Like
7

Found the activity thank you!

1 Like
8

Hi,

When I am using the export to csv activity I am getting an error as I need to use the variable type ireadrangeref but I am using a read range activity before this which read an Excel file and outputs a datatable - unsure how to configure to get the irangeref variable?

9

can u share a screenshot of that error @E.T.S

10

image
image747×138 34.3 KB

11

can you try:

grafik
grafik566×567 36.6 KB

12

it has to be a range that looks something like this
either you can write your own or you can find with that plus symbol next to it

image
image643×619 15 KB

if you want to use the datatable as input you can use WRITE CSV FILE instead of EXPORT TO CSV

Cheers @E.T.S

13

That works perfectly thanks!

14

Perfect, so the topic can be closed
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum