Q

How can we manipulate an Excel report through ABAP?

Looking for ways to produce an Excel report from an SAP ABAP program into a pivot table format? Learn how here.

We have to produce an Excel report from an SAP ABAP program into a pivot table format, so the user can drill down to the line items detail, as well as having a summarized report. Do you know how to control the looks and the positioning of the pivot table through the ABAP program?
You can use OLE to manipulate Excel objects, through the DOI classes. This is documented in the SAP help.
This was first published in June 2005

Dig deeper on SAP Web applications

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close