mfarshad
Occasional Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Cell comaprison with CSV
Hi, I have Cells in my object repository. I just want to compare it with my CSV file. My Code is as follows. I can read and parse my table (cells). But the problem is with reading of csv file, storing them into a variable and then compare it with my cells. To confirm either they match or not. sub myTest set myPage = Aliases.browser.pagePE set myTable = myPage.FindChild("idStr","tblTransList",20) call ParseTable(myTable) end sub Sub ParseTable(ATable) Dim i, j Log.AppendFolder("Table") For i = 0 To ATable.RowCount - 1 Log.AppendFolder("Row " & i) ' Goes through cells For j = 0 To ATable.ColumnCount(i) - 1 ' Obtains a cell Set cell = ATable.Cell(i, j) ' Posts the cell's text to the log Log.Message("Cell " & j & ": " & cell.innerText) Next Log.PopLogFolder() Next Log.PopLogFolder() End Sub Sub CSVDriver ' Creates a driver DDT.CSVDriver("C:\MyFile.csv") ' Iterates through records While Not DDT.CurrentDriver.EOF() '... DDT.CurrentDriver.Next() WEnd ' Closes the driver DDT.CloseDriver(DDT.CurrentDriver.Name) End Sub if cell.innerText = inputData.Value(cellIndex) then Log.Message("Values matched") else Log.Error("Values did not match") end if4.8KViews0likes2CommentsRe: HTML table comparison with CSV
i have one online Web Table and to open that table i have to 1- go to that URL 2 - Click on drop down to go some specific page 3 - put a specific date of form 4- Click on OK button 5- I will the get all the row on the same page, I have to scroll down the bottom to see all the rows and columns. Now i want to take all the rows in my software, in the same formate as they appear on the web page. This is one task that i have to do. Secondly I want to import my CSV file from my local drive into my software. That CSV have same data values in rows and columns as they are in my WebTable. Now I want to compare my both Table i.e WebTable and CSV Table. To verify that the data in both Table are equal and if not i want to know at which row there is a data missmatch?1KViews0likes0CommentsRe: HTML table comparison with CSV
yes i tried this, but it is not able to find my csv file when i used it in Jscript. But i was able to download the file when i past the local drive path in my browser. My file extention is CSV, do i have to convert this file to xls. Also please tell me how to format cells in TC, i.e do i compare the online file rows and csv file rows. Thanks1KViews0likes0CommentsHTML table comparison with CSV
Hi, I am trying to compare my online HTML table having number of rows with my CSV file that is in my local drive. I just captured the table cells by using Display Object Spy and got individual cells. Now i want to import my CSV file having the same data and then compare the values in both the files. Thanks5.4KViews0likes4Comments