HOw to convert .csv files into .xlsx files in uipath

[Gayathri_Mk]

HOw to convert .csv files into .xlsx files in uipath

[Jobin_Joy]

Hi @Gayathri_Mk

Hope this will helpful.

How to convert CSV file into XLSX

Hay, I have a questions. I’m trying open my csv file and then save it into xlsx file. But When I do that this I get that my all data is in A column why is this like that. [image] this is what I have, what is missing to write it the some as in csv only in difrent format?

Thank you.

[Gayathri_Mk]

I tried but unable to after converting if i try to open by using excel application scope it is coming like file has been corrupted like that

[Jobin_Joy]

Can you please try like this ?

Thank you.

[Srini84 (Srinivas Kadamati)]

@Gayathri_Mk

You can try as @Jobin_Joy suggested

Also you can use Read CSV activity and declare a variable for Datatable

Now use WriteRange activity and pass the Datatable Variable

Hope this will help you

Thanks

[Gayathri_Mk]

Write Range: The specified package is invalid. The main part is missing.
Getting error like this

[Jobin_Joy]

Hi @Gayathri_Mk

Please make sure you have installed the below package.

Thank you.

[Vijay_RPA]

Code.xaml (5.7 KB)
Use this one @Gayathri_Mk
Make sure microsoft.office.inerloop.excel should be installed

[Gayathri_Mk]

i need using uipath activities

[Vijay_RPA]

Then Use start process .keep CSV file PATH in that .
then send hotkey f12
Save as pop appears . Select the .xlsx from drop down(I have seen that select item not working for this use click activities )
then Save

[postwick (Paul Ostwick)]

Read the CSV into a variable using Read CSV, use Write Range to write the data to Excel.

[Gayathri_Mk]

Write Range: The specified package is invalid. The main part is missing.
I am getting this error

[postwick (Paul Ostwick)]

Right click UiPath.Excel.Activities and click Manage. Upgrade to the latest version and see if the error goes away.

[postwick (Paul Ostwick)]

@Gayathri_Mk

Write Range: The specified package is invalid

After searching the forum for this, there are lots of posts. Always search the forum for answers. It sounds like the issue is probably with the Excel file not the activity nor package.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

Earlier I got the same exception with the CSV file partially downloaded from one of the application in my organisation.

Please check if the CSV file partially downloaded or corrupted at your end. Manually open and see any content is not correct before we proceeding the suggestion from our forum members.

@postwick correctly mentioned on this issue this error due to the input file not with the package.

[Luis261980 (Luis Nunes)]

Easy way copy the file from xxxxx.csv to yyyyy.xlsx …