//'C:/Users/Franciscog/Desktop/papageno.xls'

import java.io.File
import jxl.*
import jxl.write.*

//=====================================================================
base_xml = '<cusCallerID AreaCode="404" LineNumber="2013" Prefix="208"/>'


//read excelfile

wb = Workbook.getWorkbook(new File('C:/Users/Franciscog/Desktop/papageno1.xls'))
workbook = Workbook.createWorkbook(new File('C:/Users/Franciscog/Desktop/papageno1.xls'), wb)
sheet = workbook.getSheet(0)


(1 .. sheet.getRows()).each {
 row ->

 xml = new XmlParser().parseText(base_xml)

 log.info 'new xml'

 xml.@"${sheet.getCell(0, 0).getContents()}" = sheet.getCell(row, 0).getContents()
 xml.@"${sheet.getCell(0, 1).getContents()}" = sheet.getCell(row, 1).getContents()
 xml.@"${sheet.getCell(0, 2).getContents()}" = sheet.getCell(row, 2).getContents()
 xml.@"${sheet.getCell(0, 2).getContents()}" = sheet.getCell(row, 3).getContents()
 xml.@"${sheet.getCell(0, 2).getContents()}" = sheet.getCell(row, 4).getContents()
 
 
 w = new StringWriter()
 p = new XmlNodePrinter(new PrintWriter(w))
 p.preserveWhitespace = true;
 p.print(xml)
 
 //do stuff here
 log.info w.toString()
}

workbook.close()
wb.close()