topic Re: Conversion to excel file in Application Development and Automation Discussions

Conversion to excel file

Former Member — Wed, 10 Jun 2009 09:46:53 GMT

I was converting data from my internal table to a file on my desktop

I am using FM 'SAP_CONVERT_TO_XLS_FORMAT' for the same.

But the issue when the data gets converted, it removes leading 0's from it due to which we are not able to interpret the data into another system.

How to get data with leading 0's ?

Please help

Former Member — Wed, 10 Jun 2009 09:57:23 GMT

Hi,

Try GUI_DOWNLOAD with file type DBF.

Former Member — Wed, 10 Jun 2009 12:23:42 GMT

Hi Varun,

check these links :

abaplovers.blogspot.com/2008/04/simple-sap-abap-alv-report.html

reg

siva

Former Member — Thu, 11 Jun 2009 07:24:00 GMT

Hi,

By using this FM "SAP_CONVAER_TO_XLS_FORMAT" we can convert the data to excel format.

if u want put leading zero's u use this FM: 'CONVERSION_EXIT_ALPHA_INPUT'

Regards,

seshu...