import org.codehaus.groovy.scriptom.ActiveXProxy import java.io.File; // create a proxy for Excel def xls = new ActiveXProxy("Excel.Application") xls.Visible = false Thread.sleep(1000) // open a file xls.WorkBooks.Open(new File("53Bites.xls").canonicalPath) // get the workbooks object def workbooks = xls.Workbooks def workbook = xls.ActiveWorkBook // select the active sheet def sheet = workbook.ActiveSheet def labelRow = "I" def valueRow = "J" for (i in 100..199) { def sl = sheet.Range(labelRow+i) def sv = sheet.Range(valueRow+i) label = sl.Value.value if (label != null && label.equalsIgnoreCase("Soup of the Day")) { println "Soup of the Day is: ${sv.Value.value}" } } // close the workbook without asking for saving the file workbook.Close(false, null, false) // quits excel xls.Quit()