ContributionsMost RecentMost LikesSolutionsHow Import csv file into xls file using TestCompete OR VBScriptHi, I want to Import csv file into standard xls file formate. Can anybody provide me VBscript code OR TestComplete method to import csv file into xls file. Please find the attached csv file. Regards Anand KeshriNot able to read data from csv fileHi , I tried to read data from csv file but its in different format thats why I am not able to read from csv file using testComplete. Please provide me the solution. set dtobj = DDT.CSVDriver("\\testdata\madata\automation\Reporting\AIR00226\AUM_AUC_&_Enrollment_Rates.csv") Sponsor_Cohort=dtobj.Value(0) dtobj = .CSVDriver("\\testdata\madata\automation\Reporting\AIR00226\AUM_AUC_&_Enrollment_Rates.csv")Sponsor_Cohort=dtobj.Value(0) Record_Keeper=dtobj.Value(1) Null values are displayed in above defined variables. Please find the attached csv file.