topic Re: export internal table to excel... in Application Development and Automation Discussions

export internal table to excel...

Former Member — Thu, 02 Feb 2006 09:55:41 GMT

Hello everyone!

I have an ALV with one column like this:

netwr LIKE vbrp-netwr

In the ALV Catalog, i allready tried this options:

  CLEAR fieldcat_linha.
  fieldcat_linha-fieldname = 'NETWR'.
*  fieldcat_linha-ref_tabname = 'VBRP'.
*  fieldcat_linha-ref_fieldname = 'NETWR'.
  fieldcat_linha-reptext_ddic = text-126.
  fieldcat_linha-decimals_out = '2'.
  APPEND fieldcat_linha TO fieldcat_tab.

The problem is, when i export this to an excel file, i get 2 decimals only in values like this: '1.000,00'

If the value is '200,00' the export returns only '200' in the excel file. Does anyone know how to round this problem?

Thank you.

Message was edited by: Nuno Santos

Re: export internal table to excel...

Former Member — Thu, 02 Feb 2006 10:17:07 GMT

I dont think this is the problem with ABAP. Try changing the customising settings for excel from control panel.

Ankur Bhandari

p.s Rewqard appropriate points if the answer helped

Message was edited by: Ankur Bhandari

Re: export internal table to excel...

Former Member — Thu, 02 Feb 2006 11:35:13 GMT

You probably need to reference the currency code in the field catalog. If the field in your table is called WAERS....

fieldcat_linha-currency = 'WAERS'.