I have created a program to download the team calendar of each organization in an excel file .
My problem is that I dont want to show "sheet1" , "shee2", "sheet3" empties. I wanna delete them, or at least hide them.
I have surf thru SDN with no succeed.
What I have is :
CREATE OBJECT h_excel 'EXCEL.APPLICATION'. CALL METHOD OF h_excel 'Workbooks' = h_mapl. SET PROPERTY OF h_excel 'Visible' = 1. CALL METHOD OF h_mapl 'Add' = h_map. loop of the pages..... ............ GET PROPERTY OF h_excel 'Sheets' = iv_sheet . CALL METHOD OF iv_sheet 'Add' = h_map. SET PROPERTY OF h_map 'Name' = 'Month XXXX' . GET PROPERTY OF h_excel 'ACTIVESHEET' = worksheet. ................ endloop.
Thanks for your help!