Excel formatting is incorrect when downloading from report list

[Former Member]

Hi Team,

We have a strange problem where the display in the general list output of report is correct, but when we actually download the same data into Excel(xml) format few fields are being merged into one cell.

Navigation from the report output: (Menu: List-> Save/send -> File - > Spredsheet)

Can anybody suggest the way to avoid these merging of values of different columns into once cell.

The values are actually merging at the material description field (MAKTX), it is pulling all the other next field values into one cell when the material descriotion field is ending with characters , or / etc.

Thanks in advance.

Regards,

Ram

[Former Member]

Hi,

I think you are using the fm gui_upload......

Pass the paramter value ie field_seperator = 'X'....

Hope it solves your problem

Regards

Ramakrishna Pathi

[Former Member]

Hi Ramakrishna,

Thanks for your reply. Here the report output is a normal write statement in the internal table loop.

We got the correct output in the report list output. But when we try to download it into the excel file as mentioned in my query(navigation). Few fields are merging into one cell.

Rg,

Ram

[Former Member]

Hi K B,

send me the sample code so that we can able to provide the solution for your requirement

Regards

Ramakrishna Pathi

[agnihotro_sinha2]

hi,

If you are using GUI_DOWNLOAD then, use 'DBF' in the FILETYPE field and try.

ags.

[raviahuja]

Hi,

For a custom report, you would face this problem. I also face this problem and the solution i got was:

I used function modules to download my internal table to an excel file. I needed to restructure my original data into a new internal table before i passed it to the function module to download that internal table to an excel. It was a bit of coding but output was as per the format client needed.

If you try this, it would work.

Regards,

Ravi