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
Showing results for 
Search instead for 
Did you mean: 

Data Transfer from Internal table to Application server in excel

Former Member
0 Kudos

Hi Experts ,

I am facing one problem to move data from internal table to application server in Excel formate .

I havve around 65 field , if i am creating file as string and passion data into file by open deta set in text mode its passing around 40 filed into application server ,rest filed is not move to file i check with both transaction CG3Y / CG3Z. and AL11 . and its showing me only 1cell with whole data .

I need to solve followwing problems

1 . All Columan should move into Application servar .

2. How can i move heading

3. is should disply one fiend in one cell .

I have searched in SDN also but not get proper result , if iam moveing data into binary mode its not able to interprate when i am dowin loading this file in presentation server .

Point will rewarded for right answer .

Regards

Ajay Pandey.

6 REPLIES 6

Former Member
0 Kudos

Hi Ajay,

Application Server have some restriction wont show all fields.. but wwhen u download that file in Excel sheet u can see all the fields.

Regs,

Sathish.J

Former Member
0 Kudos

Even after , Dowload i am not getting full data

0 Kudos

Hi Ajay,

you can use WS_EXCEL function module.

Regards

Ihsen ABROUG

0 Kudos

I am uploading into presetation server

0 Kudos

exactly this function module works fine into presentation server

shadow
Participant
0 Kudos

Hi ajay,

use this function module hope it will be use full for u....

ALSM_XL_2_INTERNAL_TABLE.

Regard's

Shaik.