Skip to Content
author's profile photo Former Member
Former Member

Query regarding Excel attachment to mail

Hi all,

I am passing spool no. and download path to 'RSPO_DOWNLOAD_SPOOLJOB' to the function module. I am getting the file stored at specified path in 'RAW' format. Now using GUI_UPLOAD to get the excel file data into internal table i_texts.

This excel gets attached to the mail. Since data is in RAW format, I have to pick line by line data. So I am not able to get the data column by column and data appended to the attached mail as line by line. So data redability at column level is not there.

If someone has worked on this type of requirement to get the spool no. data convertd to excel format and attached as an mail.

Please suggest your solutions regarding this...

regards,

Brijesh Patel

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jun 07, 2006 at 01:09 PM

    While using the fucntion module RSPO_DOWNLOAD_SPOOLJOB

    give the file name with the file name as .xls.

    This will dowload as a excel file.

    ID : <Spool

    Number>

    FNAME: C:\DOCUMENTS AND SETTINGS\RAVIT\DESKTOP\TEST321.XLS

    Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi,<b>

      first save the excel file as tabdelimited file </b>

      Try using GUI_UPLOAD in this way

      V_FILENAME = P_FILE.

      CALL FUNCTION 'GUI_UPLOAD'

      EXPORTING

      FILENAME = V_FILENAME

      FILETYPE = 'ASC'

      HAS_FIELD_SEPARATOR = '|'

      TABLES

      DATA_TAB = ITAB

      EXCEPTIONS

      FILE_OPEN_ERROR = 1

      FILE_READ_ERROR = 2

      NO_BATCH = 3

      GUI_REFUSE_FILETRANSFER = 4

      INVALID_TYPE = 5

      NO_AUTHORITY = 6

      UNKNOWN_ERROR = 7

      BAD_DATA_FORMAT = 8

      HEADER_NOT_ALLOWED = 9

      SEPARATOR_NOT_ALLOWED = 10

      HEADER_TOO_LONG = 11

      UNKNOWN_DP_ERROR = 12

      ACCESS_DENIED = 13

      DP_OUT_OF_MEMORY = 14

      DISK_FULL = 15

      DP_TIMEOUT = 16

      OTHERS = 17.

      Regards,

      Santosh

      Message was edited by: Santosh

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2006 at 01:14 PM

    Hi Ravi,

    Ihave passed the path as .xls only. Data is stored but not at the column level what it should have done.

    regards,

    Brijesh Patel

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2006 at 01:26 PM

    use this function module to convert,

    RSAB_CONVERT_RAW_TO_CHAR to convert from Raw to Char

    Regards

    srikanth

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2006 at 01:46 PM

    Hi all,

    I tried out this options but it seemed that its not working. Please suggest some FM that can be able to get the Excel format similiar to the normal internal table level data.

    regards,

    Brijesh Patel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.