Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Exporting to Excel - Pivot Table and Charts

Former Member

‎11-02-2015 3:18 PM

0 Kudos

Hi,

I have a requirement on exporting a report to excel.

On one sheet I must have a pivot table (the kind of pivot table that xxl creates), but on the other one bar charts according to the information (like what ole library does).

Is it feasible to achieve the requirement using only one book,I am asking these cause I have not found any information or example that ole can achieve this kind of pivot table ??? If it is, how?

Regards,

Silvia Anselmi

Preview file
46 KB
1 REPLY 1

roberto_vacca2
Active Contributor

‎11-02-2015 4:08 PM

0 Kudos

Hi.

Ole can do macros created in excel if this is your need.

A solution can be to feed a sheet on excel as DataSource (that could be hide) and on the other sheet your Pivot Table already formatted. A macro, launched from SAP, could finally reach your goal.

Anyway you can have a look at this standard report: SAPRDEMO_PIVOTINTERFACE

Hope to help.

Bye