I am in need of opening an excel file and saving it as a CSV. There are going to be 100+ files which have to saved this way. What is a better solution for this?
Should I open excel application, Open files, save as csv, close excel
Open Excel, iterate through the files, save as CSV and then finally close excel
Any help is greatly appreciated.