Does "Append to CSV" work?

Build
#1

I need to convert some .xlsx to .csv. I have tried using both the “Write to CSV” and “Append to CSV.” Everything looks like it works and it gives a .csv file. However, when I load the .csv into another program, it does not work. When I use Excel and save it as a .csv, it works fine in the other program.
The only difference in the files is if I made it into a .csv or I used one of the UiPath options.

What am I doing wrong?

#2

@Love_David_C

For loading .csv you need to use Read CSV activity

Hope this helps

Thanks

#3

Sorry, I should have mentioned that.
I am reading the .xlsx with a “Read CSV” and then trying the write/append.

#4

@Love_David_C

For .xlsx you need to use Read Range activity
image

Mark as solution if this works

Thanks

#5

I’m dumb. I meant that I have the read range I was reading about the other one when I was posting and put the wrong name. Here is my workflow.

Main upload.xaml (28.6 KB)

#6

@Love_David_C

Excel application scope accept only .xls or .xlsx files not csv files

Thanks

#7

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