While downloading missing column data in excel

[former_member712994]

Hi All,

I have an ALV report using factory model method. Now when I am trying to download the output into an excel sheet one column data is missed out.

It is downloading a blank column with the heading.

The length of the column is 255 characters. Do we have any restrictions for the length?

If not help me out to solve this issue.

Thanks,

Subhashini.K

[davis_raja]

Dear Subhashini,

Just have a look at the order of the fields in the internal table which you are displaying in the output and the order of the fields in the field catalogue.

The download option may miss some data if the orders of the fields in the internal table and the field catalogue are not matching.

Regards

Davis

[former_member712994]

Hi Davisraja,

Even the order of field catalog is same as we are downloading. Even then it is not downloading the data.

Here the column heading is downloaded but not the data.

Will it be an issue if the column data have space in the beginning or starts with some special character?

Thanks,

Subhashini.K

[davis_raja]

Dear Subhashini,

Can you post the screenshot of the Excel file and the order of the fields in the internal table?

Regards

Davis

[Mohamed_Mukhtar]

Hello Subhashini,

Yes, there will be issues(example : distortion of excel columns) whiles downloading if a column is having special characters.

Replace those special characters with space and remove the left spaces before downloading to excel.

replace first occurence of '"' in wa_variable with space.
       shift wa_variableleft deleting leading ' ' .

Thanks

[former_member712994]

I have tried removing the special character and the leading space, even then it is not downloading the data.

Thanks,

Subhashini.K

[former_member712994]

Although the Coding Long Text have some data, after downloading the excel looks like this.

Thanks,

Subhashini.K

[davis_raja]

Can you please post your field catalogue code and the structure declaration code.