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

Problem while downloading data to Excel

Former Member — Mon, 18 Aug 2008 11:50:22 GMT

Hi,

We are using downloading functionality in our program. First field is Material Number.

When we have downloaded the data to excel sheet, some of the material numbers are getting converted to DATE format.

Example: 8-2210 is been shown as Aug-10

This is creating a problem when the data is viewed in an excel sheet.

Please help me out in this regard.

Regards,

Ramesh

GauthamV — Mon, 18 Aug 2008 11:53:50 GMT

hi ,

these kind of problems r happened due to some of excel settings.

it has nothing to do with abap.

if u check in some other system it might be right.

otherwise define ur fields in final internal table based on reference table and fieldname .

Former Member — Mon, 18 Aug 2008 11:54:22 GMT

Hello

Please convert all the Data in to Char Fields and then download...

Thanks and Regards

Pushkar Joshi

former_member585060 — Mon, 18 Aug 2008 11:56:59 GMT

Select all the cells of MATNR field in Excel sheet Right click and click on Format, select as number or General type.

Edited by: Bala Krishna on Aug 18, 2008 5:27 PM

Edited by: Bala Krishna on Aug 18, 2008 5:29 PM

Former Member — Mon, 18 Aug 2008 12:18:33 GMT

We have done all the possible solutions which were replied to the question but the problem is not yet solved.

While downloading, we have converted all fields to Char type.

After downloading if we change the format of the cells, it is giving junk data instead of actual material number.