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: 

How much memory of data can be downloaded into an excel file cell?

Former Member
0 Kudos
90

Hi There,

I am having a comment field which is char type. I am downloaidng the data from Internal table into EXCEL file cell.

It is not getting download completely. Maximum it is allowing 1024 characetrs into a cell. Is there any other way to

download the morethan 1024 characters?

Could you please suggest me to resolve this issue?

Regards,

Chaitanya A

5 REPLIES 5

Former Member
0 Kudos
46

Please try using Data type LCHR.

sathyags
Active Participant
0 Kudos
46

Hello Chaitanya,

Greetings.

Have you checked the content of the internal table before downloading it to excel?

If it has all the characters, then please check the excel row height (right click on the row and choose row height, by default the number would 180 (points) increase it to 400 (maximum would be 409 i guess) and check whether the entire content is visible.

Thanks and Regards

Sathya

anup_deshmukh4
Active Contributor
0 Kudos
46

Use OLE Automation for downloading your file in that case you can Get more on OLE automation in the below link

hear is the sample code link

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP-OLEAutomationusing+MS-Excel

one more PDF for same

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCFESDE6/BCFESDE6.pdf

Edited by: Anup Deshmukh on Mar 31, 2010 8:39 AM

0 Kudos
46

Hi All,

I am not getting the data into excel from Internal table even after using field type as LCHR.

Regards,

Chaitanya A

OttoGold
Active Contributor
0 Kudos
46

What about this option: /people/otto.gold/blog/2010/02/11/happy-reporting-with-excel-ii

Regards Otto