If the backend data is already in an excel spreadsheet you can use an
ADO connection to access, compare, run scripts based on the data etc. I'd suggest reading this bit:
http://support.smartbear.com/viewarticle/56911/Or you can declare the connection yourself (JScript example):
//create connection
var xlsPath = 'C:\Somespreadsheet.XLS';
var ecommand = new ActiveXObject("ADODB.command");
var econnection = new ActiveXObject("ADODB.connection");
econnection.connectionstring = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + xlsPath + ";Extended Properties=Excel 8.0;User ID=admin;Password=''";
econnection.open();
ecommand.ActiveConnection = econnection;
//read data
var rdr = eselect("SELECT * FROM [Sheet1$]");
for (;!rdr.EOF;rdr.MoveNext()){
Log.Message(rdr(0).Value); //read first column
Log.Message(rdr(1).Value); //read second column
}
rdr.close();
rdr = null;
(VBS example with builtin method):
Dim xlsPath
xlsPath = "C:\Somesheet.XLS"
Set MyConnection = ADO.CreateADOCommand
MyConnection.ConnectionString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & xlsPath & ";Extended Properties=Excel 8.0;User ID=admin;Password=''"
MyConnection.CommandText = "SELECT * From [Sheet1]"
Set rdr = MyConnection.Execute
While Not rdr.EOF
Column1 = rdr(0)
Column2 = rdr(1)
rdr.MoveNext
Wend
