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

problem while downloading data into excel

Former Member — Fri, 16 Jan 2009 13:07:13 GMT

Hi ABAPers,

Im using OLE to download entries from internal table to excel.

One of the entry in internal table is of length 18 i.e account no. = 123456789876543212,type c(18)

My problem is that when this entry get downloaded in excel it gets printed as exponent.

i.e1.23457E+17.

How can i print account no. in the same format.

please help.

thanks in advance.

regards,

Lokesh

Re: problem while downloading data into excel

Former Member — Fri, 16 Jan 2009 13:11:30 GMT

The data is getting dowonloaded properly.

Just open your Excel file, select the column and select menu Format=>Cells

Change Category to NUMBER and change DECIMALS PLACES to 0.

I think this will solve your problem.

regards,

Jinson

Re: problem while downloading data into excel

Former Member — Fri, 16 Jan 2009 13:24:25 GMT

Hi Jinson,

Thanks for your reply.

But i do not want to do it manually.i want it will automatically comes like that.

regards,

Lokesh

Re: problem while downloading data into excel

Former Member — Thu, 12 Mar 2009 06:44:41 GMT

Hi Lokesh,

The solution for your problem is that download the table in MHTML format which can be seen when you click Spreadsheet.Then open the MHTML file in Excel. The problem will be solved.

I think this problem is answered very late but still it will help others with this problem

Regards

Andrew