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?