Exporting into Excel Using the Dynpro Binary Cache is not working on NW04s

[Former Member]

Hello,

I am using excel data export using the

"Exporting Context Data into Excel Using the Web Dynpro Binary Cache" guide at

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a94353">this link</a>.

The tutorial is working on NW04 but when I use it on NW04s I receive errors for the StringBuffer object:

java.lang.NoSuchMethodError: java.lang.StringBuffer.append(Ljava/lang/String;)Ljava/lang/AbstractStringBuilder;

Any ideas?

[BeGanz]

Hallo Roy,

I have created an updated/enhanced version of this tutorial running on NW 7.0. The new solution allows to open the exported Excel File instantly without opening a popup window befor:

See <a href="https://wiki.sdn.sap.com/wiki/x/0mQ">Exporting Table Data Using On-Demand Streams - SAP NetWeaver 7.0</a>.

<b>NOTE:</b>

Use <b>LinkedHashMap</b> instead of <i>HashMap</i>

  private Map getProductColumnInfos() {
    Map columnInfosMap = new LinkedHashMap();
    columnInfosMap.put(IPrivateTableCompBasketView.IProductsElement.QUANTITY, "Quantity");
    columnInfosMap.put(IPrivateTableCompBasketView.IProductsElement.ARTICLE, "Article");
    columnInfosMap.put(IPrivateTableCompBasketView.IProductsElement.COLOR, "Color");
    columnInfosMap.put(IPrivateTableCompBasketView.IProductsElement.PRICE, "Price in EURO");
    columnInfosMap.put(
      IPrivateTableCompBasketView.IProductsElement.TOTAL__PER__ARTICLE,
      "Total Per Article In Euro");
    return columnInfosMap;
  }

This keeps the order of key-displaytext-pairs passed by the client (table component) to the service (excel export component) stable.

Regards, Bertram

[Former Member]

Roy,

Seems that you had built your project using JDK 1.5, then deployed it to server running on JDK 1.4

Valery Silaev

SaM Solutions

http://www.sam-solutions.net

[Former Member]

Hi Valery,

I thought so too but if I go to Window->Prefrences->Java->Compiler->Compilance and Class files I see I am on 1.4. I am using JDK 1.5 on my machine but I think using this check will be enough for compiling it under 1.4...

Anywhere else I should check/change?

Roy

Message was edited by:

Roy Cohen

[Former Member]

Hi,

try here only

u go to Window->Prefrences->Java->InstalledJRes-> and edit chage over there

Thanks,

Lohi.

[Former Member]

Hi,

I have changed it there and it is working, I thought that the compilance level will do...