Change the color of the cell in the Spreadsheet XXL download
In SAP sample ALV report BCALV_GRID_01, when the output is downloaded into spreadsheet XXL format. Colors appear for the key rows and column headings with default color.
In this blog we are going to see how to change those default colors to user defined.
Go to transaction SE38, execute the report BCALV_GRID_01. Click on Export –> Spreadsheet –> XXL –> Table –> Microsoft excel.
The output below has default colors in the rows and columns as below.
These colors are defaulted or hard-coded in the system as in the below report.
The system looks for the user defined colors from table COLORSEXC, if there is no user default then it uses the default color codes 12 and 36.
Lets try by maintaining the table COLORSEXC to use the user defined colors.
Refer to the below link for the color codes used in excel.
Color Palette and the 56 Excel ColorIndex Colors
We will use color code 32 and 34.
Now execute the report again and download it into XXL format as explained earlier and it downloaded with the user defaults colors maintained in the table.
Nice one.. 🙂
Thanks Naveen 🙂