Hello everyone,
I need to download Internal table data to excel with a column header line.
My Code is as follows:
TYPES: BEGIN OF y_hdr,
head(30) TYPE c,
END OF y_hdr.
Data: t_hdr TYPE STANDARD TABLE OF y_hdr.
Fill internal table t_adrcdata
fill the header table t_hdr
CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
filename = C:\test.xls
filetype = 'DBF'
IMPORTING
TABLES
data_tab = t_adrcdata
fieldnames = t_hdr
EXCEPTIONS
file_write_error = 1
no_batch = 2
This code gives me a row with column headers.
However they are all truncated after 10 chars.
The truncation is independent of column data length. Data could be of length 2,5 or 40 but the header always displays upto 10 chars.
Keeping the filename as test.xls, when I download it in ASC format instead of DBF the headers are of proper length.
What could I be doing wrong?
I know this topic has been discussed before but my question is pertaining to DBF Format download. The reason I chose DBF format is because it downloads the data in DB format and does not give in to Excel formatting.
FOr example in ASC format:
1, A field of type Char(12) used to get downloaded into excel without the leading zeros. 000012345678 --> 12345678
2. Date in format dd-MMM-yyyy in a char(11) field used to get downloaded to excel in dd-MMM-yy format.
When I chose DBF, this issue was resolved. However, the column headers got truncated at 10 chars.
Please feel free to recommend any other way of downloading to Excel and preserving format if this method is incorrect/ there is a better way.