Skip to Content
0
Apr 23, 2015 at 05:53 PM

Create XLS file on Application Server (no tab-delimited format)

3641 Views

Hi,

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.

Thanks,

Prasanna