Problem - Column title not appearing in excel sheet

[Former Member]

Hi Gurus,

I am working on a report where I need to add two fields in the output ( Excel format). I have included the fields in the output structure.While debugging my final internal table has both the new headers and their value.But both the heading and data are not appearing in the output because the contents in the internal table are converted to XML and it is converted to excel.Any suggestions to find the locus where it has gone wrong.

[Former Member]

Hi,

How come the internal table values are gettin converted to XML ?? ...Are you doing it...

Any way.. use the function module GUI_DOWNLOAD.......

Make sure you transfer the contents of the internal table which you want to transfer to another internal table, in which the fields should be of type STRING or CHAR.

Let me know if its workin.

Regards.

[Former Member]

Nope.It is developed by someone else.They are passing the internal table values and headers to XML and then it is converted to excel output.

[Former Member]

Well in that case, take a field which is already present in the excel output developed by them. Find all the places in the code where that particular field is being used, and try to use the same logic for your fields also........

[Former Member]

Thanks