Forum Discussion

XBug's avatar
XBug
Contributor
9 years ago

How to test the content of an Excel spreadsheet?

Hi,   What I would like to do is the following: Open an Excel File from a directory Check if the content of the column in Excel file meets a certain criteria   I have done the first step but ...
shankar_r's avatar
shankar_r
Community Hero
9 years ago

Hi, 

 

Simple sample for validating content in excel.

 

Sub CompareValue(str_ComVal)
  Dim Excel

  Set Excel = Sys.OleObject("Excel.Application")
  Excel.Workbooks.Open("D:\Users\Documents\Testss.xlsx")

  If Excel.ActiveWorkbook.Sheets.Item("Sheet1").Range("A1") = str_ComVal Then
      Log.Checkpoint("Matched")
  Else
      Log.Error("Not matched")
  End If
  
  Excel.Quit
  Set Excel = Nothing
End Sub