I have a requirement to create an XLS file (no XLSX / tab-delimited format) on Application Server.
I tried the below approach:
lv_appserverfilename = <application server file path>/testfile.xls
1. OPEN DATASET lv_appserverfilename FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.
2. Loop at the internal table, concatenate all fields in the work-area (using CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB as field separator) and transfer the record to application server using the TRANSFER command.
3. CLOSE DATASET lv_appserverfilename.
But this generates a TAB delimited file and not an .XLS file. And the requirement is to create an XLS file.
Appreciate your thoughts/inputs to address this issue.