Hi All,
I need to convert excel sheet into CSV File.
Based on some filter conditions in excel sheet , i need to copy the filtered data from the excel sheet and paste it in the CSV File.
Please suggest me how can i move forward.
Hi All,
I need to convert excel sheet into CSV File.
Based on some filter conditions in excel sheet , i need to copy the filtered data from the excel sheet and paste it in the CSV File.
Please suggest me how can i move forward.
Use Read Range to get the data, then use the Write to CSV activity to write the data to a CSV file.
UiPath makes this as simple as a sequence of 2 activities.
but write to csv file takes datatable. we are filtering the data based on datatable only. then how can we write the filtered excel sheet data to csv. please suggest
Read range pulls the data into a datatable, which would then be transferred to the CSV in the Write to CSV activity.
You can use below activities in the following order:
Thanks for the reply
Thanks for the reply and it worked