cancel
Showing results for 
Search instead for 
Did you mean: 

export to excel sheet

Former Member
0 Kudos

dear all

after export to excel sheet my table header data is coming different

ex( my table header is employee name ,contact details,username)

but after export to excel sheet.

ex(my excel header is fname,userid,uname)

and my table contact details contains mobile numbers(9198334687) in table they were working fine

but in excel they were coming in different in zigjag format ex(+90000ezy45)like this it was showing

but when i click on particular coloumn in excel on mobile number on top it was showing fine but where iam clicking it was showing zigjag manner

send me the code for these above requirements,

regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kishore,

Use the following blog to export from web dynpro to excel sheet.

http://wiki.sdn.sap.com/wiki/dosearchsite.action

And, the data within the cell in excel sheet is not displaying the same value as it actually contains as the size of the number is large and the format is changed to fit the excel sheet column width as standard excel functionality. Try fixing the format of the excel sheet column through code (specific node attribute passed), but I am not sure how to do that.

Regards,

Tushar Sinha

Answers (0)