topic Re: Problem while exporting ALV column header to excel sheet. in Application Development and Automation Discussions

Problem while exporting ALV column header to excel sheet.

Former Member — Mon, 10 Aug 2009 06:42:14 GMT

Hi,

I am able to export an ALV grid details to an excel sheet. But the ALV column headers when exported to excel sheet are getting truncated.

For eg: if my column header in ALV grid is displayed as 'Material' then the column header in excel sheet is 'Mater' only. Remaining portion is getting truncated.

How can I view the entire column header text?

Kindly assist.

Thanks.

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Mon, 10 Aug 2009 06:45:09 GMT

Hi,

Just expand the column width in the excel, you will be able to see the entire column description.

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Mon, 10 Aug 2009 06:59:28 GMT

I am able to view the ALV column header in the ALV by expanding the column. The problem doesn't lie here.

After exporting the ALV grid to excel sheet, the individual column header text is getting truncated in the excel sheet (And not in the grid itself).

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Mon, 10 Aug 2009 07:08:30 GMT

Hi,

Well i asked you to expand the column width in the excel after exporting the ALV to the excel. What you mean by trunctated? Is "Material" is only being displayed as "Mater" within column width or the value getting exported itself is 'Mater"?

Regards,

Vik

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Mon, 10 Aug 2009 09:30:08 GMT

Hi Vik,

I have expanded the column width in excel but the result is the same. Unable to view the complete column header.

Any idea what can be done?

Thanks.

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Tue, 11 Aug 2009 11:30:39 GMT

check the following blogs

/people/alvaro.tejadagalindo/blog/2009/02/05/excel-ole-and-abap--create-fancy-reports

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Wed, 26 Aug 2009 09:50:29 GMT

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Wed, 26 Aug 2009 09:50:34 GMT

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Thu, 20 Jan 2011 05:01:30 GMT

I have the same problem with you, when user export to excel. I fixed it by using

w_layo-colwidth_optimize = 'X'. <<<<<<<<<<<<This

perform generate_fcat_reftab
    using 'PRUEFLOS' 'T_INPUT' '' '' 'Inspection Lot' 0.

form generate_fcat_reftab  using    p_fieldname
                                    p_tabname
                                    p_ref_tabname
                                    p_ref_fieldname
                                    p_output_text
                                    p_output_lenght.
  clear w_fcat.
  w_fcat-fieldname = p_fieldname.
  w_fcat-tabname   = p_tabname.
  w_fcat-ref_fieldname = p_ref_fieldname.
  w_fcat-ref_tabname = p_ref_tabname.
  w_fcat-seltext_s = p_output_text.
  w_fcat-seltext_m = p_output_text.
  w_fcat-seltext_l = p_output_text.
  w_fcat-outputlen = p_output_lenght.
  w_fcat-ddictxt = 'L'. <<<<<<<<<<<<<<<<<<This
  append w_fcat to t_fcat.

endform.

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Tue, 14 May 2013 08:53:22 GMT

Thanks Pen-ek,

I was facing the same issue:

Doing this

w_layo-colwidth_optimize = 'X'. <<<<<<<<<<<<This

and this

w_fcat-ddictxt = 'L'. <<<<<<<<<<<<<<<<<<This

It solved.

Regards,

Ani

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Tue, 14 May 2013 08:57:25 GMT

Hi,

You are right. It happens in excel. For that you need to pass the refrence field and refrence table to the fieldcat and also small medium and large text. This will surely solve your problem.

w_fcat-ref_fieldname = p_ref_fieldname.

w_fcat-ref_tabname = p_ref_tabname.

w_fcat-seltext_s = p_output_text.

w_fcat-seltext_m = p_output_text.

w_fcat-seltext_l = p_output_text.

w_fcat-outputlen = p_output_lenght.

Regards -

Makarand

Re: Problem while exporting ALV column header to excel sheet.

Former Member — Tue, 18 Jun 2013 10:24:25 GMT

Do not pass header name in seltext_s and seltext_m in the fieldcatalog. Pass it only in seltext_l.