getting blank column when downloading spreadsheet?

[Former Member]

hai  fnds...any one help for the below issue

  i have developed ALV report used ( layout also in that ).displaying 19 fields in the  output. but when i am downloading spread sheet iam getting one blank column in spread sheet.(but all 19 fields are comming ). i dont know why i am getting second  column is blank? but otherthan spreadsheet format is not getting any blank column.

here for the purpose of change layout and save layout i am using

DATA: gv_boxnam         TYPE slis_fieldname   value  'VENUM'.

VENUM field which is in internal table but not displaying the output. is this any problem?

Suppose if i take   DATA: gv_boxnam         TYPE slis_fieldname   value  'VBELN'. which is in internal table and displaying the output..in this case i m not getting the VBELN in the output..i am getting only 18 fields in the output.

Thanks,

Raghu.

[Former Member]

hai  fnds...any one help for the below issue

  i have developed ALV report used ( layout also in that ).displaying 19 fields in the  output. but when i am downloading spread sheet iam getting one blank column in spread sheet.(but all 19 fields are comming ). i dont know why i am getting second  column is blank? but otherthan spreadsheet format is not getting any blank column.

here for the purpose of change layout and save layout i am using

DATA: gv_boxnam         TYPE slis_fieldname   value  'VENUM'.

VENUM field which is in internal table but not displaying the output. is this any problem?

Suppose if i take   DATA: gv_boxnam         TYPE slis_fieldname   value  'VBELN'. which is in internal table and displaying the output..in this case i m not getting the VBELN in the output..i am getting only 18 fields in the output.

Thanks,

Raghu.

[Former Member]

try this:

concatenate all the data in a string type table seperated by commas.

move this new table to the excel.

i hope it will work fine then