[Groovy Script]엑셀 파일 열기

import java.io.File

import java.util.Date

import jxl.*

import groovy.xml.MarkupBuilder

import org.custommonkey.xmlunit.*

//read excelfile

wb = Workbook.getWorkbook(new File('C:/.../ChangedData.xls'))

sheet = wb.getSheet(0)

def writer = new FileWriter('C:/.../data.xml')

def xml = new MarkupBuilder(writer)

xml.mkp.xmlDeclaration(version: "1.0", encoding: "utf-8")

//=======================

//xml.users(){user(count:'i')

   for (int i=1; i<sheet.getRows();i++) {

      for (int j=0; j<sheet.getColumns(); j++){

           p=sheet.getCell(j,i).getContents()

      log.info p

       }

   }

}

wb.close()