- there is one Excel read range variable is DT_IN(DataTable ) , here i need to write DT_IN data in one csv fiel, i use write csv it shows the error.
- i need to convert one Excel file into CSV fiel
Hi @Shermil_Aarthy. Not sure what your error is but see below for a sample workflow of how this is typically done. You can also possibly use the Save Excel file as activity.
Sample Input File:
Book1.xlsx (8.8 KB)
Screenshot for easy reference:
Source Code for sample:
Main.xaml (9.0 KB)
If this does not solve your issue please tag me and share a screenshot of your challenge.
Happy Automating! 
Follow this solution.
@ashokkarale Your solution does not compile, i also see it is over 6 years old, preferable to stick to newer solutions. @LeonWentzel Tried your solution and it worked !
You are doing in right way but can you show us what is the exception you are getting, based on that we can give help you.
Regards,
Mahesh Kankatala
Yes, you can directly convert the Excel data to CSV.
Since DT_IN is already a DataTable, use Write CSV like this:
DataTable: DT_IN
FilePath: “C:\YourFolder\Output.csv”
Make sure you are using the Write CSV activity from UiPath.Excel.Activities and not passing the Excel file path into it.