Can anyone help me on copying csv file into excel without change in format.
While I am trying to read and write it is converting some columns into text format.
Hi @pari_patel
Try to read the CSV file with read range (inside Excel Application Scope) and write the output using write range (Excel Application Scope)
How should it work? Inside excel scope, it will allow to read only xlsx files.
First Copy the full path of the file. You can do it by selecting the file and from the tool bar option select copy path.
Paste this path in excel scope. And you are good to go.
Sorry but not understanding what you are saying. If possible please provide me sample file. thanks
Thank You @kumar.varun2 This is working. One more help needed on Excel, If I want to filter columns and then remove rows, What is the flow and what activities I can use here?
See below Sample, I want to filter this column A and remove the rows of entire sheet which has #N/A Value.
likewise I have to perform more filters in one sheet.
If you can help that would be great.
Thank You again
You can use the Filter Data Table Activity for this. Filter out the values which are empty.
Or
You can use LINQ to filter the Data Table
For your reference
Four Ways to Filter Data Tables in UiPath Studio | UiPath
Also, since this topic is closed, please raise it in a separate topic.
Thanks for sharing but in my case, it is not working.
Reason: My #N/A values generated from VLOOKUP.
Any suggestion how should I remove those?
Share the excel file sample
I did try before, but because of formula is there then it is giving some number value(ex: -12345786) after removing #N/A.
I want to filter #N/A and remove the rows.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
yogitagaikwad2206
Pushpendra_kowthavarapu
Shiva_Nikhil