on 02-18-2015 3:24 PM
Hi Friends ,
In my current project we are suppose to download the data from internal table to CSV file format excel(xls and xlsx are not allowed).
my concern is I am able to download the data but first column is getting blank .
for your information i am adding the sample code .
data : str type string,
xstr type xstring.
do 3 TIMES.
CONCATENATE str 'singh2' 'singh2' cl_abap_char_utilities=>newline INTO str SEPARATED BY ','.
ENDDO.
CALL FUNCTION 'SCMS_STRING_TO_XSTRING'
EXPORTING
text = str
IMPORTING
buffer = xstr.
CALL METHOD cl_wd_runtime_services=>attach_file_to_response
EXPORTING
i_filename = 'Dashboard.csv'
i_content = xstr
i_mime_type = 'TEXT/CSV'
i_in_new_window = abap_false
i_inplace = abap_false.
my concern is i am able to download in CSV file but first column is gertting blank.
output
--------------------------
col1 col2 col3 col4
singh2 singh2
singh2 singh2
singh2 singh2
expexcted output
--------------------------
col1 col2 col3 col4
singh2 singh2
singh2 singh2
singh2 singh2
output should start from column 1 but it is starting from column 2 leaving column1 blank.
kindly let me know if nay solution is there
Thanks,
Harish Singh.
If any solution please let me know ...
How we can show data from the first column ...
Thanks,
Harish .K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.