Read CSV: Craziness

Hi

A) Wheres the Old Read CSV gone. Now I only have the Excel option.
image

And B)
Whats this Craziness
The top one won’t except “” but works without
the bottom one works with “” but not without

Hi @rmorgan ,

Have you installed the right stable version of UiPath.Excel.Activities package ?

Read CSV is grouped within the classic Activities:

And maybe you have to set the classic filter

@rmorgan
might be better when you also give an explanation on what you want to express with screenshot

mayb you will try by

  • remove the filter “read csv”
  • set the activities filter to classic

UPD-1

  • which is working e.g for UiPath.Excel.Activities Version 2.24.4

In Version 3.1.1 (maybe also newer ones)

  • the classic filter is broken (compared to the Docu) and offers not the read CSV file activity
  • but offers

on which is more elaborated by Jon

for further questions lut us know which version of UiPath.Excel.Activities package is referenced

1 Like

Read CSV was always part of the Excel dependency (I never liked this as a CSV is a text file and so doesn’t require Excel at all), they have just grouped it now with the other activities in that package and changed the icon, those are superficial changes.
(It should be part of System Activities, not Excel activities though, but thats a separate debate).

As for the differing things from the local file read.
More modern activities have multiple ways you can enter an argument, and can display them differently depending on how you do it.
Its possible you selected the top one from a menu, navigating to the file, and its being treated as a ‘LocalResource’ and the other is a string you pasted in and so needs the quotation makes.
If you click the plus icon next to the field you might see some extra options that can identify this?

1 Like

Read CSV was always part of the Excel dependency (I never liked this as a CSV is a text file and so doesn’t require Excel at all), they have just grouped it now with the other activities in that package and changed the icon, those are superficial changes.
(It should be part of System Activities, not Excel activities though, but thats a separate debate).

Thats the answer I was looking for :slight_smile: Thought I was going mad

In regards to this, I think there must be a bug, as both are labelled “local file” which should be of string, not local resource.
Will raise a ticket

1 Like

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