09-17-2008 9:34 AM
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.
09-17-2008 1:20 PM
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
09-17-2008 2:18 PM
09-17-2008 2:41 PM
Hi Ajay,
you can use WS_EXCEL function module.
Regards
Ihsen ABROUG
09-17-2008 3:22 PM
09-17-2008 3:28 PM
exactly this function module works fine into presentation server
09-18-2008 4:22 AM
Hi ajay,
use this function module hope it will be use full for u....
ALSM_XL_2_INTERNAL_TABLE.
Regard's
Shaik.