I have an issue with reading excel csv/txt file in Studio X.
Format when I am opening the file in Excel without using StudioX.
When I am using it in StudioX and would like to do any action then I am not able to do anything becasue the view is quite different, StudioX doesn’t convert it to proper table.
The issue is separator I guess but I dont know why UiPath is showing the file in different and incorrect way that when I am opening the file myself. As you can see StudioX converts the data to a few different columns so I cannot use text to columns.
But I need to remove 3 first rows, and filter out only values in specific column (the rows that are hidden after filtering should be removed) and save it finally as csv too. Will I be able to remove data and filter using “Read csv/text file” activities?
After reading the data you will get data in datatable format and you can use filter datatble and all activities related to datatable to do your manipulations and when use write csv to write back
