
	Home > Ask the SAP software/management Experts > Application development Questions & Answers > How can we manipulate an Excel report through ABAP?

Ask The SAP Expert: Questions & Answers

EMAIL THIS

How can we manipulate an Excel report through ABAP?

EXPERT RESPONSE FROM: Matthew Billingham

		Pose a Question

		Other SAP Categories

		Meet all SAP Experts
		Become an Expert for this site

Digg This!

StumbleUpon

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?

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

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Application development
	How to implement SAP BADIs
	How to correct an SAP ABAP dump with an oversize condition
	Creating a function group for an SAP ABAP table maintenance generator
	How can I get an ABAP program displaying Excel data to wrap text?
	How to read an SAP transaction in an ABAP code
	How to create Include programs in the ABAP editor
	Defining a structure in a report
	Deleting entries from a dynamic table
	Is there a 'load of program' option in report generation?
	Validating table fields

SAP Web applications

How to do additional dialog processing after SAP COMMIT WORK statement

SAP TechEd Demo Jam 2009: Winners use beer keg in demo

SAP CTO expects today's SAP applications to be running in 2020

SAP TechEd 09 keynoters: Managing change today like trying to board a speeding train

How can I get an ABAP program displaying Excel data to wrap text?

An ABAP user wants to learn XI

SAP exec discusses Imagineering, the future of development

The stars of TechEd: SAP application demos

Validating table fields

The difference between field groups and internal tables

SAP ABAP

How to do additional dialog processing after SAP COMMIT WORK statement

SAP TechEd Demo Jam 2009: Winners use beer keg in demo

How to implement SAP BADIs

Tips on SAP ABAP

Using subclasses to develop applications that run on different releases of SAP

How to find a piece of SAP ABAP code without debugging

Configuring SAP EDI for sales orders

How to correct an SAP ABAP dump with an oversize condition

How can I get an ABAP program displaying Excel data to wrap text?

How to read an SAP transaction in an ABAP code

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
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SAP White Paper Topics

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2009, 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.