Forum Discussion

Bharadwaj's avatar
Bharadwaj
Contributor
10 years ago

How to Read and compare images in two excel files

Hi All, I  have two excel files in whch I have tabular data as well as pictures in it. I can easily read the tabulat data and compare them but I am not aware of how to read the pictures in them and ...
  • joseph_michaud's avatar
    joseph_michaud
    10 years ago

    Use the Excel OLE Object to provide the pictures:

     

    function LogExcelPicture(num)
    {
      var Excel = Sys.OleObject("Excel.Application");
      
      Excel.Workbooks.Open("C:\\Book1.xls");
      Excel.WorkSheets(1).Shapes(num).Copy();
      Log.Picture(Sys.Clipboard, "clipboard picture");
      Excel.Quit();
    }