topic Re: Right alignment in excel attachment in Application Development and Automation Discussions

Right alignment in excel attachment

VishwanathV — Tue, 17 Oct 2023 09:37:11 GMT

Hello,

I'm generating excel attachment for email using cl_bcs class in ABAP and without using XML technique. Almost everything is fine with excel fiel, except for alignment of data in few of the cells of this excel file. Is there a way to force the alignment (Left, Center, Right) on the desired cells of this file through ABAP without using XML technique. By default, any numeric value is currently displayed with Right alignment and any character value is displaying with Left alignment. The customer wants to see certain character values with the Right Alignment.

Re: Right alignment in excel attachment

RaymondGiuseppi — Tue, 17 Oct 2023 10:01:09 GMT

Okay you don't use a XML tool to create the Excel.

So which tool did you use?

Re: Right alignment in excel attachment

VishwanathV — Tue, 17 Oct 2023 10:30:36 GMT

I'm concatenating itab data into a string variable, converted it into binary format and passing the same to the method attachment of the object generated for the class cl_document_bcs=>create_document.

Re: Right alignment in excel attachment

Sandra_Rossi — Tue, 17 Oct 2023 13:03:53 GMT

So, I guess you use something like CSV or tab-separated values, which do not permit any rich content (anything which is not a value).

If you want to include rich content, you must use a rich format like Office Open XML, XMLSS, etc.