Skip to Content
0
Former Member
Jun 21, 2011 at 05:08 AM

XLS Download using Dataset.

25 Views

Hi Experts,

I am working on SAP version 4.6B

I've a query. During download on Application Server in XLS format using DATASET, the complete data appears in one column in XLS file and has to first convert into Text to Columns for proper display. Is there any option using DATASET, to get it download in separate columns as we donwload using simple download function in forground?

I am writing the code as below:

OPEN DATASET N_FILE FOR OUTPUT IN TEXT MODE MESSAGE MSG1.

IF SY-SUBRC EQ 0.

LOOP AT FINAL3.

TRANSFER FINAL3 TO N_FILE.

ENDLOOP.

CLOSE DATASET N_FILE.

ELSE.

WRITE:/10 'Process Failed'.

ENDIF.

Thanks in advance for expert comments.

Best Regards,

Anil