Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excel sheet format in CL_DOCUMENT_BCS

Hi all,

I am using this CL_DOCUMENT_BCS to send internal table data in excel through mail, that is
working fine.

My problem is when i open the excel sheet through mail, it is displayed as below.

But i want the excell to dispay with the necessary colum width as below.

Kindly advice me what need to be done.

Former Member
Former Member replied

Hi,

The code for this is already there.

You can see how the column headings are in Bold.

Just copy that style(Header) into a new one and remove the code for adding the color and use that style for Sub total and total.

Also, for Center Justified, I had given the statement to add for right justification above.

Change the Header style by having a look at these.

Thanks,

Shambu

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question