Home > SAP FAQs > SearchSAP.com expert FAQ > SearchSAP.com FAQs > SAP ABAP FAQ > SAP ABAP FAQ > How can we manipulate an Excel report through ABAP?
FAQs: SearchSAP.com expert FAQ:
EMAIL THIS
 START   SEARCHSAP.COM FAQS   
SearchSAP.com FAQs


SAP ABAP FAQ
<< PREVIOUS | NEXT >>

How can we manipulate an Excel report through ABAP?

Matthew Billingham EXPERT RESPONSE FROM: Matthew Billingham

Pose a Question
Other SAP Categories
Meet all SAP Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 22 June 2005
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?

>
EXPERT RESPONSE
You can use OLE to manipulate Excel objects, through the DOI classes. This is documented in the SAP help.


Sound Off! -   Be the first to post a message to Sound Off!


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


<< PREVIOUS | NEXT >>
VIEW ALL IN THIS CATEGORY

RELATED CONTENT
Application development
Is there a 'load of program' option in report generation?
Deleting entries from a dynamic table
Defining a structure in a report
Validating table fields
The difference between field groups and internal tables
Unicode check error fix
Creating a screen for grid display
Migrating test programs from ECC 4.6 to 6.0
Creating a field exit for a data element
Methods for uploading SAP data

SAP Web Applications
SAP exec discusses Imagineering, the future of development
Is there a 'load of program' option in report generation?
Deleting entries from a dynamic table
Defining a structure in a report
Validating table fields
The difference between field groups and internal tables
Unicode check error fix
How SEM relates to BI/BW
Methods for uploading SAP data
Error when reading XML files in SAP

SAP ABAP
Is this the quickest way to find a BADI?
ABAP Objects in SAP Workflow to provide improved performance
Easily debug error messages in SAP processes
Accessing private attributes in ABAP Objects
Is there a 'load of program' option in report generation?
Deleting entries from a dynamic table
Defining a structure in a report
How can ABAP developers survive in a NetWeaver era?
Validating table fields
The difference between field groups and internal tables
SAP ABAP Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Application Link Enabling  (SearchSAP.com)
R/2  (SearchSAP.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsBlogsTipsAsk the ExpertsWebcastsWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2000 - 2008, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts