string too long

[Former Member]

Hello ,

Requirement is to generate an excel file in DMS .

Data for this excel file is retreived from Tables , tables have very huge amount of data .

method used to generate the excel file is :--

1. we create a string by concatinating all the data from tables

but we get dump in creating this string, since we have large amount of data .

2 . create an Xstring

3 Convert that to binary

4. create an excel in DMS

Can anyone please suggest how can we avoid step 1.

OR

Any way by which we can merge two excels to generate one Excel

[Former Member]

Please look into code exchange project, might get some help:

[ABAP2XLSX|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

Thanks

[marcin_cholewczuk]

Hi,

That would mean that you'have more than 2GB of data (this is the maximum size of string as far as I know). Does it really make sense to prepare so big files? When user will try to load it into memory it will take ages and I'm pretty sure that with ~65k lines limit in excel it won't be possible to see all results. So maybe it would be better to split this file?

Best Regards

Marcin Cholewczuk

[Former Member]

why not GUI_UPLOAD into a binary table to start with? Or store as file on apps server and read into variable described as xstring?

Sounds like you're uploading as ASCII and then trying to convert to binary....unnecessary step, at least for me....

[marcin_cholewczuk]

He didn't write that he is readig data from file, but from table (probably DB Table).

I suspect that xstring also has a limit, so it won't change anything.