Table in Excel sheet

[former_member1193316]

Hi ?GURU's,

I m using webdynpro-java. in this i hav been fetechd data and displaying in a table format.

i want to display this table in an excelsheet. how can i achieve this,

plz provide me sme materia related to do this.

thanks in advance

venkat

[former_member751941 · Accepted solution]

Hi Venkat,

Check this Links,

/people/anilkumar.vippagunta2/blog/2007/02/04/office-control-in-webdynpro-ii

Regards,

Mithu

[Former Member]

Hi ,

Check my weblog on the same.. Not the most elegant solution.. But must solve the problem..

<a href="/people/sap.user72/blog/2006/05/04/enhancing-tables-in-webdynpro-java-150-custom-built-table-utilities to Excel</a>

Regards

Bharathwaj

[BeGanz]

Hi Venkat,

when using SAP NW 7.0 see <a href="https://wiki.sdn.sap.com/wiki/x/0mQ">Exporting Table Data Using On-Demand Streams - SAP NetWeaver 7.0</a>. Otherwise see "further Reading section" on wiki page.

<b>UPDATE - Keeping the order of colmuns stable</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]

Venkat,

Go through the link below <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">How to export data into excel</a>

I think it will be helpful to you.

Regards

Madhu