Extracting Data Table from CSV

Hello friends (@rkelchuri, @Ninett_Panfir, @Rammohan91, @balupad14, @loginerror, @MAHESH1 ),

how is it possible to etract the content of a .csv file as a DataTable with the correct columns, originally separated by a “;” in the csv file?
Here there is the xls file corresponding to the csv file.

16797_261118 - Copy.xls (75.4 KB)

Thank you,
it’s very urgent.
Thank you for the precious help.
Camilla :slight_smile:

Hi @CamiCat

well since the xls files have already Semicolons “;” as delimiter, you only need to change the extensions of the files to .csv and then use Read CSV activity and change the Delimiter option to Semicolon like this :

after this you’ll have a datatable that you can play with as you want…

you can save it using write CSV activity and you will have the format that you want.

hope it helps

2 Likes

Thank you @reda.
I tried the Read CSV file but it says It is already opened.


How can I close all Excel instances?
"System error at initialization: The process cannot access the file ‘*’ because it is being used by another process. at Source: Invoke workflow file: Read CSV
Thank you,
Camilla

Weird I also had the same problem when I was trying to open you xls file for the first time…
I ended tasks from Details under Task Manager and end task
image
hope it helps.

1 Like

Hi,
You can use Kill process activity and in the process name property you can give "Excel

Thanks.

1 Like