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

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 …

Hello @srinivass , Take a look at this: [image] .xls to .csv Help Hi I have a folder with .XLS files,I want to convert all the .XLS files to .CSV file Activities The UiPath Documentation Portal - the home of all our valuable information. Find here everyt…

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] [image]

Check the destination in Move File activity, is the extension being changed to CSV? If so, type of conversation might not always work.

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”

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?

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…

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

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

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

Convert XLS file to CSV

Help

Susana (Susana González Cacheiro) September 27, 2017, 9:58am 2

Hello @srinivass,

Take a look at this:

Regards,
Susana

Topic		Replies	Views
How to convert .xlsx to .csv Studio studio , question , activities_panel	6	3717	July 8, 2023
Convert Excel file (.xlsx) to (.csv) Help robot , activities , studio	6	14788	March 6, 2019
How to save .csv attachement as .xlsx from outlook Studio mail , outlook , studio , question	10	1135	May 31, 2022
Convert XLSX file to CSV through Invoke code method VBA, only change file type Studio excel , csv , studio , question , activities_panel , vba , invoke-code	4	2879	July 20, 2022
Csv to xlsx converter Activities datatable , excel , activities , variable , web , string , question	5	1920	August 3, 2021

Convert XLS file to CSV

Related topics