Skip to Content
avatar image
Former Member

about excel export for WD!

i 've seen the thread web" target="_blank">www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a94353">web dynpro Binary Cache.

<b>i have to got some changes for requirement:</b>

<b>1.></b>i don't wanna to open a new URL page and a download dialog windows(open/save/cancel option buttion) when i click excel URL file.i hope it only to pop the download dialog windows;

2.> after i download the excel file to my local computer.i don't wanna to select some options(1.As a XML list;2.As a read-only workbook) to open it.i hope i can open it directly by click the *.xls file.

<b>3.></b>i don't know how to change the column name for excel file. Liking some blank-letter maybe appear in the column name. e.g.: <b>First Name</b> not <b>FirstName</b>.

looking forward to u reply.thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 11, 2006 at 08:27 AM

    HI,

    Use the following threads,

    Excel download... and upload?

    saving-file-on-server-folder

    Excel download... and upload?

    saving-an-excel-object-in-ole

    /message/758567#758567 [original link is broken]

    Regards

    Saravanan K

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 13, 2007 at 01:05 PM

    Hallo Wingoal,

    Look at the NW 7.0 version of my Excel Export tutorial on SDN: Exporting" target="_blank">https://wiki.sdn.sap.com/wiki/x/0mQ">Exporting Table Data Using On-Demand Streams - SAP NetWeaver 7.0:

    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.

    What's still not solved there is the "Keep spacial characters in column header texts" problem.

    Regards, Bertram

    Add comment
    10|10000 characters needed characters exceeded