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

Passing An Internal Table Data to EXcel(OLE)

Hi,

In one of our Requirements we need to output the data of an internal Table into Excel Sheets using OLE.

Any help on how we pass the Data in the Internal Table into the EXCEL using the OLE.

Thanks in advance,

Arunava

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Oct 18, 2005 at 05:29 PM

    Sure, please check out this weblog.

    /people/rich.heilman2/blog/2005/09/12/manipulate-excel-with-ole-abap

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2005 at 05:29 PM

    Hi,

    check these links...

    below links might help you

    http://help.sap.com/saphelp_erp2004/helpdata/en/59/ae3c98488f11d189490000e829fbbd/frameset.htm

    an easy reference for ole automation.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/c1d54348-0601-0010-3e98-bd2a2dcd9e6c

    reward points for helpfull answers and close the thread if your question is solved.

    regards,

    venu.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2005 at 07:01 PM

    Hi Rich and Venu,

    Thanks for the Inputs. I have been able to put my data in the Internal Tables into Two EXCEL Worksheets in the Same EXCEL file.

    The Only 2 points where I have been stuck is

    1. Format : Certains Columns of Table has Numeric Data with Leading Zeros. Now when I am opeing the EXCEL using OLE. The Numbers dont show the leading Zeros as the EXCEL cells have a Default Format. These Values Can displayed with Leading Zeros if I can change the Default FORMAT to TEXT.

    --> How Can I set this FORMAT to TEXT in my EXCEL

    2. Page Breaks: Also in the Excel That if Printed by the User there is Requirement where after Every Material Details that is printed out there needs to be a Page Break.So that every Set of Material Details gets Printed in a Different Page.

    --> How Can I achive this in OLE.

    Thanks again,

    Arunava

    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.