The ABAP2XLS framework is a nice framework to speed up the development time and options to work with XLS from ABAP.
Follow the instructions on the ABAP2XLS github site to download and install. Also install the demo programs.
Run program ZABAP2XLSX_DEMO_SHOW to see the demo programs:
Double clicking on a program will show the coding on the right hand side and also start the demo program. In this case generating xls with multiple tabs with just a few lines of coding.
There are many options possible. Just look at the demo programs and re-use the coding.