6 Comments

You must be Logged on to comment or reply to a post.

  1. Paolo Sartor

    On your example, I’ve created a function to generate the excel form in XML format.

    Its use is simple and the realization of the report is very fast.

    I enclose:

    • A sample report
    • The excel product module (.xml)
    • The excel product module (XLS extension). it is the same as before
    • The function module to generate the excel form
    • The function module to send mail

    For sending the mail you can also use the standard function module SO_NEW_DOCUMENT_ATT_SEND_API1

    Thanks to all the people who will be using my programs


    http://www.informatica2005.it/Documenti/SAP_Excel_xml/z_ut_crea_excel_xml.zip

    (0) 
  2. Paolo Sartor

    If you like you can set of LEDs on the excel sheet created.

       Immagine.JPG

        CASE w_msgtype.

          WHEN ‘I’ OR ‘S’.

    * Green led

            CLEAR s_excel.

            MOVE 1          TO s_excel-sheet_nro.

            MOVE w_row      TO s_excel-row_nro.

            MOVE 7          TO s_excel-column_nro.

            MOVE ‘n’        TO s_excel-value.

            MOVE ‘Webdings’ TO s_excel-fontname.

            MOVE ’99CC00′   TO s_excel-char_color.  “Green

            APPEND s_excel  TO it_excel.

          WHEN ‘W’.

    * Yellow led

            CLEAR s_excel.

            MOVE 1          TO s_excel-sheet_nro.

            MOVE w_row      TO s_excel-row_nro.

            MOVE 7          TO s_excel-column_nro.

            MOVE ‘n’        TO s_excel-value.

            MOVE ‘Webdings’ TO s_excel-fontname.

            MOVE ‘FFFF00’   TO s_excel-char_color.  “Yellow

            APPEND s_excel  TO it_excel.

          WHEN OTHERS.

    * Red led

            CLEAR s_excel.

            MOVE 1          TO s_excel-sheet_nro.

            MOVE w_row      TO s_excel-row_nro.

            MOVE 7          TO s_excel-column_nro.

            MOVE ‘n’        TO s_excel-value.

            MOVE ‘Webdings’ TO s_excel-fontname.

            MOVE ‘FF0000’   TO s_excel-char_color.   “Red

            APPEND s_excel  TO it_excel.

        ENDCASE.

    (0) 
  3. Manohar B

    Hi Jabin,

     

    Helpful blog .

    Indeed i am looking for coloring the particular cell as you mentioned  above , passing values to it_excel .

    Could you please help me how i can insert this cell coloring logic in the above code ” In the loop gt_final , if i want to give back ground color ” Green,red and yellow based message type in a particular cell .

     

     

    Thanks and Regards,

    Manohar.

    (0) 

Leave a Reply