Data Transfer from Internal table to Application server in excel

[Former Member]

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.

[Former Member]

I am uploading into presetation server

[Former Member]

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]

Even after , Dowload i am not getting full data

[Former Member]

Hi Ajay,

you can use WS_EXCEL function module.

Regards

Ihsen ABROUG

[Former Member]

I am uploading into presetation server

[Former Member]

exactly this function module works fine into presentation server

[shadow]

Hi ajay,

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

ALSM_XL_2_INTERNAL_TABLE.

Regard's

Shaik.