topic Re: excel sheet in Application Development and Automation Discussions

excel sheet

Former Member — Fri, 31 Aug 2007 10:15:22 GMT

hello,

how can i get all the fields of the table into excel sheet..

when iam displaying the record i get only a few fields onto my local file..how can i get all the fields is there anything i wanna change in the settings..it is not programming thing..

just transering the fields using system-> save-> local file.

plz advise..

regds

Re: excel sheet

former_member188827 — Fri, 31 Aug 2007 10:22:22 GMT

in se11.after executing for a particular entry..when u get the record...

click on Settings menu...>format list..>Choose fields.

check if all da checkboxes are selected or not..

if not click on select all button or f9 key...

plz reward points if it helps

Message was edited by:

abapuser

Re: excel sheet

Former Member — Fri, 31 Aug 2007 10:25:21 GMT

hi,

go system->list->save->local file->spreadsheet.

all the fields will save in exacl file.

rewards if helpfull

regds,

paras

Re: excel sheet

Former Member — Fri, 31 Aug 2007 10:27:33 GMT

no its not working that way

Re: excel sheet

Former Member — Fri, 31 Aug 2007 10:31:22 GMT

Function module EXCEL_OLE_STANDARD_DAT can be used to start Excel with a new sheet and transfer data from an internal table to the sheet.

Re: excel sheet

Former Member — Fri, 31 Aug 2007 10:32:03 GMT

Hi,

Copy all the data from the table to an internal table and call the FM alsm_excel_to_internal_table to download the data from internal table to excel....

Reward points if helpful............

Regards,

Sree.

Re: excel sheet

former_member188827 — Fri, 31 Aug 2007 10:32:13 GMT

which table entries are u trying to save?

are all ur fields checked in the settings...>format list..>choose fields..

and did u save it via..

system..>list..>save..>local file

Re: excel sheet

Former Member — Fri, 31 Aug 2007 10:32:59 GMT

hi,

before saving in local file just check your table width.if its 250 then only some fields will come. change it 1250 then all fields will come in local file.

Paras

Re: excel sheet

kiran_k8 — Fri, 31 Aug 2007 10:33:14 GMT

Sudheer,

You will be able to get the data stored in the table into an excel file but not the table itsefl.

go to se 12

give vbak (for ex)

click on technical settings

press f8

you will get the output

this you can export it to excel file as mentioned in the above threads,but not table itself.

K.Kiran.

Re: excel sheet

Former Member — Fri, 31 Aug 2007 10:37:41 GMT

yh, iam changing still i cant get the all fields..

thanks

Re: excel sheet

Former Member — Fri, 31 Aug 2007 12:46:35 GMT

i did it manually..thanks for all of you guyz n galz if theres any..

closing this thread