cancel
Showing results for 
Search instead for 
Did you mean: 

Error of AbstractStringBuilder in Export to Excel

dhruv_shah3
Active Contributor
0 Kudos

Hi All,

I am using [https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3596] [original link is broken] [original link is broken] [original link is broken]; Blog for exporting data into the Excel file.

But i am getting error in xml.append.

whenever there is xml.append is used i am getting error AbstractStringBuilder is not visible.



x
				.append("<")
				.append(headerName)
				.append(">")
				.append(dataNodeElement.getAttributeValue(attributeName))
				.append("</")
				.append(headerName)
				.append(">
");

So pls help me...asap.

Thanks & Regards,

Dhruv Shah

Edited by: Dhruv Shah on Sep 9, 2008 12:26 PM

Edited by: Dhruv Shah on Sep 9, 2008 12:27 PM

Accepted Solutions (1)

Accepted Solutions (1)

former_member197348
Active Contributor
0 Kudos

Hi Druv,

Did you try like this:

x.append("<").append(">")
.append(dataNodeElement.getAttributeValue(attributeName))
.append("</"). append(">\n");

Regards,

Siva

Edited by: Siva Rama Krushna on Sep 9, 2008 12:36 PM

dhruv_shah3
Active Contributor
0 Kudos

Hi Siva,

I am getting errors in this code:



private String toExcel(IWDNode datanodes, Map columnInfos)
	  {
	   IWDMessageManager m = wdComponentAPI.getMessageManager();
	   StringBuffer x = new StringBuffer();
	   
		  String attributeName, headerName;
		  String entriesName = datanodes.getNodeInfo().getName();
		  String entryName = entriesName + "Element";
	  // m.reportSuccess(entryName);   
	   //m.reportSuccess(entriesName); 
		  // trim given header texts, so that XML element names adhere to the rule 'no spaces contained'.     
		  trimHeaderTexts(columnInfos);
		//String test = AbstractStringBuilder(test);
		  x.append("<?xml version='1.0' encoding='UTF-8' standalone='no'?>\n");
		  x.append("<").append(entriesName);
		  x.append(">\n");

		  for (int i = 0; i < datanodes.size(); ++i) {
			IWDNodeElement dataNodeElement = datanodes.getElementAt(i);
			x.append("<").append(entryName);
			x.append(">\n");
	
			for (Iterator iter = columnInfos.keySet().iterator(); iter.hasNext();) {
			  attributeName = (String) iter.next();
			  headerName = (String) columnInfos.get(attributeName);
		  //	m.reportSuccess((String) iter.next());
			  x
				.append("<")
				.append(headerName)
				.append(">")
				.append(dataNodeElement.getAttributeValue(attributeName))
				.append("</")
				.append(headerName)
				.append(">\n");
			
			   //m.reportSuccess((String)dataNodeElement.getAttributeValue(attributeName));
			}
		
			x.append("</").append(entryName).append(">\n");
		  }
		  x.append("</").append(entriesName).append(">\n");
		  return x.toString();
	 }
  

So whereerve i am using xml.append i am getting errors...

former_member197348
Active Contributor
0 Kudos

Hi Druv,

The code what I gave in the last post was published wrongly by the forum. I don't know why the plus symbol(+) is not showing in the post?

Change your code and try

x.append("<?xml version='1.0' encoding='UTF-8' standalone='no'?>\n");
		  x.append("<")
                 .append(">\n");
 
		  for (int i = 0; i < datanodes.size(); ++i) {
			IWDNodeElement dataNodeElement = datanodes.getElementAt(i);
			x.append("<").append(entryName);
			x.append(">\n");
	
			for (Iterator iter = columnInfos.keySet().iterator(); iter.hasNext();) {
			  attributeName = (String) iter.next();
			  headerName = (String) columnInfos.get(attributeName);
		  //	m.reportSuccess((String) iter.next());
			  x
				.append("<")
                                   .append(">")
				.append(dataNodeElement.getAttributeValue(attributeName))
				.append("</")
                                    .append("> \n");
			
			   //m.reportSuccess((String)dataNodeElement.getAttributeValue(attributeName));
			}
		
			x.append("</")
                         .append(">\n");
		  }
		  x.append("</")
                     .append(">\n");
		  return x.toString();

I don't know why my code changes are not being displayed properly. The code is shown as the same as the copied one not new one.

Try like this:

*x.append("</ " ).append( " > \n");* 

Regards,

Siva

Edited by: Siva Rama Krushna on Sep 9, 2008 1:02 PM

Answers (1)

Answers (1)

Former Member
0 Kudos

This error occurs if the wrong JDK version (>= JDK 6) is selected in NWDS. Make sure you use a JDK version that is compatible to your NetWeaver release, e.g. JDK 1.4 for NW 7.0 or JDK 5 for NW 7.1.

Armin

dhruv_shah3
Active Contributor
0 Kudos

Thanks,

I had done this changes in the NWDS and installed the JDK 1.4.

Regards,

Dhruv Shah