Convert XLS file to CSV

csv

#1

Hi

I would like to convert an XLS file to CSV when we receive an email.

Also i need to remove the headers and one last column

Can someone let me know how to go about.

Thanks

S


#2

Hello @srinivass,

Take a look at this:

https://activities.uipath.com/docs/csv

https://activities.uipath.com/docs/excel

Regards,
Susana


#3

I did look at it, but couldn’t find anything in which converts to CSV in the workflow

Is it by just renaming it works.

image


#4

Check the destination in Move File activity, is the extension being changed to CSV?

If so, type of conversation might not always work.


#5

So Am i right in thinking by changing the extension to from XLS to CSV, it will work

In the move destination it says Path.GetFileNameWithoutExtension(item.ToString)+".csv"


#6

If the data is intact after changing the extension, you may use move file.

But since you have to do some manipulation why don’t you convert excel into a data table and convert it to csv after your header and column removal?


#7

Ok thanks for the suggestion, I do the understand the datatable part of removing headers and column but how to convert

Do you mean I have to use a recording sequence and do save as.

I just tried to rename the xls file to csv and tried to open, i get the following error, if i click yes it opens the file


#8

ReadRange from Excel file to a DataTable.
Use WriteCSV activity with that DataTable to write it to a CSV file afterwards.

Changing extension might work from a user perspective, but you’re essentially creating a fake csv file.
Yes, you can open it in Excel and it “looks” like a csv, but you can’t treat it as a CSV file - it’s still an .xls file inside. Whatever is supposed to consume that as an input (there has to be a reason why you need to convert it) will most probably crash, since it’s expecting a csv and gets an xls.


#9

Thank you for the solution.


#10

Sorry for bumping an old thread. But can you please share with me the xml file about this?
i already try the solution from @andrzej.kniola but can’t produce any results.
is there any example bout this?

Really sorry for bumping this old thread.

Thanks before
Cheers.

Delf


#11

what do you want exactly, this was something i did couple of months back


#12

the example .xaml file about this problem. I already tried doing it by myself but can’t get any results.

This is my project
Main.xaml (10.2 KB)
is there anything wrong with this?

Thanks before
Cheers


#13

I could not convert xls to csv, but had to open the xls file and pick the data from it.

I cant run your xaml file because my UIPath licence has gone past its date.

sorry about that

S