Skip to Content

[abap2xlsx] Wrong data or empty cells when filling template

Jun 29, 2017 at 06:05 PM


avatar image


as described in the link below we have a problem filling an existing excel file with data. In my code the data is handled correctly to the excel classes but some of the cells are overwritten by one other value. Seems to be randomly but using the same data again the same cells will be overwritten. We will start looking into the excel classes but maybe some of you had the problem before.

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lasse Bultmann Jun 30, 2017 at 07:53 AM


we found the problem. Attached you can see two screenshots.
In the method "CREATE_XL_SHAREDSTRINGS" only the cell value is compared to delete adjacent duplicates. Additionally you have to comapare the data type


code-before.png (12.0 kB)
code-after.png (10.7 kB)
10 |10000 characters needed characters left characters exceeded