Skip to Content

Table in Excel sheet

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 04, 2007 at 10:39 AM

    Hi Venkat,

    Check this Links,

    Looking for example to export data from a DynPro table to Excel file

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

    Regards,

    Mithu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 04, 2007 at 10:43 AM

    Venkat,

    Go through the link below How" target="_blank">www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a94353">How to export data into excel

    I think it will be helpful to you.

    Regards

    Madhu

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 04, 2007 at 12:46 PM

    Hi Venkat,

    when using SAP NW 7.0 see Exporting" target="_blank">https://wiki.sdn.sap.com/wiki/x/0mQ">Exporting Table Data Using On-Demand Streams - SAP NetWeaver 7.0. 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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 04, 2007 at 12:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded