Analysis for office (SAP plugin)

Help Studio
1

hello everyone,
we are looking into the possibility of automating some reports using analysis for office (SAP add-on for excel).

Have any of you had experience with this? Is it possible to run reports without having to interact with the excel ui but via certain activities?

Thanks

2

@andreus91

ideally we need to go with ui only as it opens some dfferent screens other than excel own window

if you are refereshing or using only excel tabs then you can try with macros and check…record a macro and see if all steps are recorded if so can run them

cheers

cheers

1 Like
3

it becomes quite unstable to interact via ui, no connector or script to interact with analysis for office?

4

@andreus91

That is what try to use macro and check

Cheers

5

if you have some C# experience you can try to do it using code.

look at this: help.sap.com/saphelp_boao22/helpdata/en/f2/710db86c9b1014bf2c9a7eb0e91070/frameset.htm

its for VBA but the interop for Excel uses a similar syntax so you should be able to convert it.