on 03-08-2009 9:38 AM
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
None of the one is answered since long time so that I have closed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.