Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Add Columns .. imp..

Former Member

‎02-01-2008 5:46 AM

0 Kudos

Hi Techis

my prg is to download values from sap into excel sheet n that sheet is having heading like customer , address, city .. etc

now i added two columns in it and nw i want to update excel file so that i will get heading for this colunm but thing is that

i am getting value thru gui_download but column heading is not coming... pls help me ..

imp my excel file is getting stored at folder as i had given path into gui_download function.

Pls help me out..

Rewards will b awarded ...

Thanks

Santosh

2 REPLIES 2

former_member201227
Active Participant

‎02-01-2008 5:54 AM

0 Kudos

Hi,

First download the heading to the specified file location.

Then, download the values to the same file in append mode.

Set the import parameter APPEND to 'X'.

Now, the values will be appended to the same excel.

Best Regards,

Sharmila

Former Member

‎02-01-2008 6:27 AM

0 Kudos

Hi,

You can also pass the Headings for the fields using another structure and give it in the FIELDNAMES parameter under tables.

bye