How to import data from a file? (txt, csv, or xls)

[sfresher]

I was trying to create a test application to auto GUI test, and I want to import all the test variables from a data file (txt, csv, or xls).

e.g. I want to test the "add" function of Windows Calculator. Instead of hardcode my script to test 1+5=6, 9+62=71, I can simple import data from a file, contains 1, 5,6, 9, 62, 71. By doing this, I can easily modify my test data in the feature.

Should I use any UDF to implement this?

[Szhlopp]

I was trying to create a test application to auto GUI test, and I want to import all the test variables from a data file (txt, csv, or xls).

e.g. I want to test the "add" function of Windows Calculator. Instead of hardcode my script to test 1+5=6, 9+62=71, I can simple import data from a file, contains 1, 5,6, 9, 62, 71. By doing this, I can easily modify my test data in the feature.

Should I use any UDF to implement this?

Yeah use a UDF. Use the forum search for finding a UDF to read csv/xls correctly. StringSplit would also help you ALOT...

[File.txt]

1,5,2,9,124,7,11,6,7

FileRead

StringSplit

From help file on StringSplit:

the first element ($array[0]) contains the number of strings returned