Skip to Content

Regarding Excel Merge and Line feed

Hi Guys ,

I have made a report where the output can be extracted to excel using OLE.

Problem is report will leads to Time-out as there are huge no.of records are processing into it so i have to go for a background job.

I came to know OLE wont help me in Background job for extracting the report as per the desired formatted output like merging and providing line feed (Alt+ ENTER) in a cell.

Is there any other way is possible to acheive this format ouput in excel via the background job.

kindly suggest me on this.

Thanks in advance

Gurumoorthy

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 28, 2013 at 11:28 AM

    Hii Gurumoorthy,

    its correct that ole can't be used in background mode.

    try using the following fms for desired output:

    RSPO_DOWNLOAD_SPOOLJOB - it will download the file in the spool

    and thereafter you can display the excel output using FTBU_START_EXCEL.

    You can alternatively make use of a class ABAP2XLSX which can be run in background too.

    if you want the output in formatted way,you can make use of html fms like:

    www_itab_to_html_headers which populates column headings

    www_itab_to_html_layout which populates column properties

    and then to prepare the html from internal table using the fm www_itab_to_html

    and then use gui_download .

    other than the above SAP_CONVERT_TO_XLS_FORMAT or open_dataset method.

    Hope it helps!!!!

    Thanks!!!!!

    Alora Sahu

    
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 04, 2013 at 06:01 AM

    Hi Alora ,

    Thanks for the Idea, I have done a zdevelopment using spool request number genrated and created a dynamic work area to get those values and mapped with OLE codes. it was successful.

    Thank you .

    Guru.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 11, 2019 at 11:42 AM
    -1

    can you please post the sample code , which you have did.

    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.