on 06-22-2015 12:31 PM
Hello everyone,
i use the Class zcl_excel_worksheet with the Method bind_table.
The problem is that the excel file is created with filters in the Header line. But i need a excel_file without any filters.
The only way it seems to work is, thatyou set each cell with the method -> set_cell manual.
Is there any other solution ????
Thanks
bye
Johannes,
Which version are you using?
In the newest version is it possible to remove the filter using the table settings
ls_table_settings-nofilters = abap_true.
Please check ZDEMO_EXCEL3 for more details.
Regards,
Ivan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ivan,
thanks for your help and sorry for cross posting, i first posted there and than saw that you should post question into the forum.
However, right now i can't see the Version but i want to share my solution :
If i remember correct the Version is from the year 2010 ... or s.t. like that.
So if you have a itab and want to create a xslx. file with filter use the Methode :
bind_table
if you want no autofilter set use the Method
set_table
regards,
Johannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.