[abap2xlsx] Wrong data or empty cells when filling template

Former Member — Thu, 29 Jun 2017 18:05:38 GMT

Hello,

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.

https://github.com/ivanfemia/abap2xlsx/issues/488

Thanks in advance.

Re: [abap2xlsx] Wrong data or empty cells when filling template

Former Member — Fri, 30 Jun 2017 07:53:01 GMT

Hello,

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

topic Re: [abap2xlsx] Wrong data or empty cells when filling template in Application Development and Automation Discussions

[abap2xlsx] Wrong data or empty cells when filling template

Re: [abap2xlsx] Wrong data or empty cells when filling template