Packt+ | Advance your knowledge in tech

You're reading from SAP ABAP Advanced Cookbook Featuring over 80 sophisticated recipes, this is a superb tutorial for ABAP developers and consultants. It teaches you advanced SAP programming using the high level language through diagrams, step-by-step instructions, and real-time examples.

Product type Paperback

Published in Dec 2012

Publisher Packt

ISBN-13 9781849684880

Length 316 pages

Edition 1st Edition

Languages

ABAP

Concepts

Data Analysis

Author (1):

Rehan Zaidi

View More author details

Table of Contents (22) Chapters

SAP ABAP Advanced Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

1. ABAP Objects

2. Dynamic Programming FREE CHAPTER

3. ALV Tricks

4. Regular Expressions

5. Optimizing Programs

6. Doing More with Selection Screens

7. Smart Forms – Tips and Tricks

8. Working with SQL Trace

9. Code Inspector

10. Simple Transformations

11. Sending E-mail Using BCS Classes

12. Creating and Consuming Web Services

13. SAP Interactive Forms by Adobe

14. Web Dynpro for ABAP

15. Floorplan Manager

Index

Downloading into Excel made easy using simple transformations

In this recipe, we will see how we can use simple transformations in order to download the contents of an internal table into Excel format. The advantage of this method is that the Excel file will contain the desired font size and colors without any programming effort required.

We will first create a sample Excel file in XML format. Then, we will upload it via the transformation editor XSLT_TOOL and generate a transformation accordingly. (The Excel XML and the transformation language may be mixed, thus the Excel XML is converted into a transformation.) The generated transformation will serve as a template representing our Excel file format. We will make slight changes in it and call it in our ABAP program in order to generate the Excel file.

The primary emphasis of this recipe is to generate an XML string containing the content of the Excel data in XML format. The download part of the XML will not be shown.