Adapter Module (Reading Excel File)

[Former Member]

Hi Guys,

I followed the Webblog :

For File Adapter Module Development , for reading Excel Sheet.

Deployment all went fine and when i used in my configuration , file is getting picked up but the xml content is not getting displyed , it says not well formated.Below error is shown in the CC Monitor

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

-

---

XML document must have a top level element. Error processing resource 'http://pxxxxx:50xxx/mdt/messagecontentservlet?att...

My coding in nwds

xmldata = "<?xmlversion="1.0"encoding="UTF-8"?> "

+ "<ns:"+wb.getSheet(0).getCell(0, 0).getContents() +"xmlns:ns=""

+ wb.getSheet(0).getCell(1, 0).getContents() + "">"

+ "<Name>"+ wb.getSheet(0).getCell(1, 2).getContents()

+ "</Name>" +"</ns:" wb.getSheet(0).getCell(0, 0).getContents()">";

Kindly suggest if any

srini

Edited by: Venkateswarlu Srinivas on Jul 4, 2008 2:47 PM

[Former Member]

try removing the \n you have added in the string