Excel sheet format in CL_DOCUMENT_BCS
I am using this CL_DOCUMENT_BCS to send internal table data in excel through mail, that is
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.
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.