cancel
Showing results for 
Search instead for 
Did you mean: 

please give me a ########### solution onthis

Former Member
0 Kudos

Dear SDN friends,

I used the one of our SDN friend "Alamelu Pandiyan`s" it was working fine but Alamelu Pandiyan please give a solutions becasue i am facing the problem i get the data more than 255 character i am getting ######### in the excel table please give me solution ASAP i really struct in this point. I used same your coding only.

your early response is very helpful.

i pasted the code below can any one give me solution :

xml_file.append("<?xml version='1.0' encoding='UTF-8' standalone='no'?><")

.append(_nodename)

.append(">\n");

int size = columnInfos.size();

for(int i =0;i<noofelem;i++)

{

IWDNodeElement elem = wdTableNode.getElementAt(i);

xml_file.append("<")

.append(_nodename)

.append("Element>");

for (int j = 0;j<columnInfos.size();j++)

{

String attributeName = (String)columnInfos.get(j);

String attributeValue = "";

if(elem.getAttributeValue(attributeName)!=null)

attributeValue = elem.getAttributeValue(attributeName).toString();//attributeName

attributeValue = elem.getAttributeValue(attributeName)+"";

// xml_file.append(attributeName)

xml_file.append("<")

.append(attributeName)

.append(">")

.append("<![CDATA[")//added by rajesh

.append(elem.getAttributeValue(attributeName))

.append(attributeValue)

.append("]]>")//added by rajesh

.append("</")

.append(attributeName)

.append(">\n");

}

xml_file.append("</")

.append(_nodename)

.append("Element>\n");

}

xml_file.append("</")

.append(_nodename)

.append(">\n");

Regards

Suresh

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

None of the one is answered since long time so that I have closed

Former Member
0 Kudos

Just increase the excel column width by dragging it towards right while viewing your excel. You will be able to see the proper values. This has nothing to do with coding I suppose!

Former Member
0 Kudos

Normally you get the #### signs in excel when a number is bigger then its field. It probably has nothing to do with your export, just resize the field when watching the excel.

Jeschael

Former Member
0 Kudos

Hi,

can you please explain where i need to change in my code.

Former Member
0 Kudos

Hi J.V. Lebbink

can you please tell me where i need to change in code or in back end field length. why because i am getting data from Backend

Former Member
0 Kudos

try to use html tags instead of using xml. and setting value to every tag just convert it into string.

Edited by: kavita chavan on Dec 21, 2009 11:11 AM