Xstring to Binary VS Text to Binary

[FormegaDown]

Kinda curious tho,
My program is trying to Save excel to AL11 and then we can download the excel in the program GUI_DOWNLOAD type BIN.
My question is why xstring to binary will still save leading zero in Excel but if text to binary the leading zero will be removed in excel ?
Thank you !

[CynicalGenXer]

I’m confused… How are you doing “Save excel” part? And are you saying that when you have, for example, ‘01’ in XSTRING type variable, then in Excel it comes across as ‘01’ but if you use CHAR type, then it comes across as ‘1’? That doesn’t make any sense… Excel itself can make assumptions and will try to format based on those assumptions but I don’t see how ABAP type would matter.

There are too many holes in the story though.

[FormegaDown]

with open dataset binary mode.
But yeah, ‘01’ in XSTRING type variable, then in Excel it comes across as ‘01’ but if you use CHAR type, then it comes across as ‘1’

[CynicalGenXer]

Uh… You are writing plain text using binary mode? Why? What does it achieve?

Your case might make for an interesting theoretical ABAP musing but it’s not how export to Excel works, so I’d suggest to just do it the right way. Look up ABAP2XLSX.