currently, my code checks each cells of each sheets of each excel files,
saves the data of the row, collumn, sheet and it's value
and then compare the values,
code:
'''
function ExcelDiff()
{
var ListFilesRef = [];
var ListFilesToTest = [];
var endwitherror = false;
FilesRef = aqFileSystem.FindFiles([path], "*");
if (FilesRef != null)
while (FilesRef .HasNext())
{
aFile = FilesRef .Next();
Log.Message(aFile.Name);
ListFilesRef.push(aFile.Name);
}
FilesToTest = aqFileSystem.FindFiles([path], "*");
if (FilesToTest != null)
while (FilesToTest.HasNext())
{
aFile = FilesToTest.Next();
Log.Message(aFile.Name);
FilesToTest.push(aFile.Name);
}
for(var i = 0; i < ListFilesRef.length; i++)
{
var excelRef = ReadDataFromExcel([path]+ListFilesRef[i]);
var excelToTest = ReadDataFromExcel([path]+ListFilesToTest[i]);
for(var k = 0; k < excel19[0].length; k++)
{
if(excelRef[0][k] != excelToTest[0][k])
{
Log.Warning("differences detected", "differences detected between "+ListFilesRef[i]+" (Ref) and "+ListFilesToTest[i]+" (ToTest) on the sheet: "+excelRef[1][k]+" cell: "+excelRef[3][k]+excelRef[2][k]);
endwitherror = true;
}
}
}
if(endwitherror == true)
Log.Error("differences detected");
}
function ReadDataFromExcel(pathtoexcel)
{
var contentfile = [];
var sheet = [];
var row = [];
var collumn = [];
var total = [];
var Excel = Sys.OleObject("Excel.Application");
Excel.Workbooks.Open(pathtoexcel);
var SheetCount = Excel.Sheets.Count;
for(var k = 1; k<= SheetCount; k++)
{
Excel.Worksheets.Item(Excel.Sheets.Item(k).name).Activate();
var RowCount = Excel.ActiveSheet.UsedRange.Rows.Count;
var ColumnCount = Excel.ActiveSheet.UsedRange.Columns.Count;
for (var i = 1; i <= RowCount; i++)
{
for (var j = 1; j <= ColumnCount; j++)
{
contentfile.push(VarToString(Excel.Cells.Item[i,j]));
sheet.push(Excel.Sheets.Item(k).name);
row.push(i);
collumn.push(j);
}
}
}
total.push(contentfile);
total.push(sheet);
total.push(row);
total.push(collumn);
Excel.Quit();
return total;
}
'''
and i have come across those forums, however, I was unable to apply those solution,
that's why i'm here
