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

downloading to excel using an internal table with a string field.

Former Member
0 Kudos

Dear All,

when i try to download values to excel,

if the field is of type string in the database table and fulstops(.) are used in the values, then even if there are more fields in the row, the data next to the fullstop is being displayed in the next row in the excel.

for example there are 4 fields and second field value is 'xyz abc....', then the third and fourth fields are being displayed in the next row in the excel sheet.

how to resolve this?

thanks in advance.


Former Member
0 Kudos

Hi Sharmila,

There is something callled a Delimiter in excel. Check where you need to break the Statement and download the values to excel. This is found in the data tab of excel. You can set the Delimiter there you have an option of previewing your data there.