topic Re: Problem while downloading data in excel in Application Development and Automation Discussions

Problem while downloading data in excel

former_member321825 — Mon, 18 Apr 2011 07:24:41 GMT

Hi,

Data in one of o/p columns is 0E000 but when I download the alv o/p in excel the value comes as '0.00E+00'

I guess it is taking Char E as exponential and hence converting in excel.

Please provide me a solution so that i can get the data as 0E000 in excel.

Edited by: Rachel@sap on Apr 18, 2011 10:22 AM

Re: Problem while downloading data in excel

Former Member — Mon, 18 Apr 2011 09:50:12 GMT

Hi Rachel,

The issue which you are discussing is related to excel. As per my knowledge & experience, you cannot do much about that.

In my opinion, just try to convince your client to put a (') at first position in the column which you are getting wrong output. In this way you can achieve the result. Even in my case I have made the client understand how to see the correct value in excel (i.e. by putting (') as the first character in the error column.

Hope this info will be sufficient to resolve the issue & close the thread.

BR,

Vinit

Re: Problem while downloading data in excel

Former Member — Mon, 18 Apr 2011 10:10:19 GMT

Hi,

Whilw downloading change the file type as 'DBF'



CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
    filename              = w_filename
    filetype              = 'DBF'                          "Use the file type as DBF
    write_field_separator = 'X'
  TABLES
    data_tab              = t_output.

Prabhudas

Re: Problem while downloading data in excel

Former Member — Mon, 18 Apr 2011 11:43:11 GMT

Hi Prabhu,

Thanks a lot. I am able to download the excel file as desired.

Just 1 query . what is full form of DBF????

Thanks & Regards,

Vinit

Edited by: vinit005 on Apr 18, 2011 1:43 PM

Re: Problem while downloading data in excel

Former Member — Mon, 18 Apr 2011 12:24:33 GMT

Hi Vinit,

'DBF' :

Data is downloaded in dBase format. Since in this format the data types of the individual columns are stored as well, you can often avoid import problems, for example, into Microsoft Excel, especially when interpreting numeric values.

Thanks and Regards,

Prakash K

Re: Problem while downloading data in excel

former_member321825 — Mon, 18 Apr 2011 12:48:46 GMT

Thank You.

I am downloading via ALV hence i am not using gui_download.

Could you please tell me how to resolve for alv download.

Re: Problem while downloading data in excel

OleHombre — Wed, 30 Oct 2013 06:03:54 GMT

Hi Rachel,

Try this.

Rather than using the 'Save to local file' option from ALV, opt for the Microsoft Excel/Spreadsheet button from the toolbar (CTRL+SHIFT+F7).

This will save in excel format.

Note: This download mode will not take into account any custom changes to subtotals/filtering/sorting etc.

You might also need to set the macro security options in excel to medium (for excel 2003) or tick trust VBA projects for macro settings in the excel trust center settings (excel 2007,2010 etc). Else you might receive 0K000 message for VEXCEL conversion.

See screenshot for details.