IRPA - Excel operations - Import Data from Text/CSV

Hi,

I'm trying to automate the import of data from a CSV file into Excel and do some manipulation during the import (replace values, remove columns,...). Is there a good way doing this? I couldn't find any function within the excel SDK and it's quite hard to do all the steps using UIAutomation or WIN. I need some pre-processing on the data stored on the CSV file and excel was till now the best application.

Any ideas how to import CSV data into excel?

excel-importdatafromcsv.jpgexcel-importdatafromcsv-replacevalues.jpg

Adrian