‎2017 Apr 06 3:07 PM
Dear Friend,
I am Downloading Data from cl_hrpayna_gui_alv_tree to EXCEL using XLSX Work Bench.
It working fine while not changing the format or layout,
While adding layout with color, its getting Dump, error show in attachment.



Sudarshan D
‎2017 Apr 07 8:55 AM
Hi, Sudarshan! It seems your SAP GUI version (maybe You are using 7.30) doesn't work fine with MS Excel . Please, update SAP GUI to latest version and notify if the problem will stay on.
Best regards, Igor.
‎2017 Apr 06 5:25 PM
As the short dump says, an ABAP programming error that must be solved by the owner of SAPLZZXLWB.
‎2017 Apr 07 8:47 AM
Hi Horst Keller,
I tried but no response,
I am getting error as below,
actual line code. on Program.
WHILE offset < max_length AND zip+offset(4) = '504B0304'.
Normal assignment it takes,
zip+offset(4) = '504B0304'.
but I am coloring the layout and assigning to TREE. Its getting,
zip+offset(4) = 'D0CF11E0'.
goes to dump without filling Table to display.
Note:
Just want to know is that version problem of EXCEL.
Sudarshan D
‎2017 Apr 07 10:02 AM
Igor Borodin is the author of this free tool. You've got a response.
‎2017 May 27 12:03 PM
Thanks you!!!
Yes I got Response.
Problem is about SAP GUI version.
Thank you again!!!
Sudarshan 🙂
‎2017 Apr 07 8:55 AM
Hi, Sudarshan! It seems your SAP GUI version (maybe You are using 7.30) doesn't work fine with MS Excel . Please, update SAP GUI to latest version and notify if the problem will stay on.
Best regards, Igor.