Skip to Content
Author's profile photo Thanga Prakash Thanga Raj

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.

/wp-content/uploads/2016/01/4_871121.jpg

/wp-content/uploads/2016/01/5_871124.jpg

/wp-content/uploads/2016/01/5_871124.jpg

/wp-content/uploads/2016/01/5_871124.jpg

The output below has default colors in the rows and columns as below.

/wp-content/uploads/2016/01/5_871124.jpg

These colors are defaulted or hard-coded in the system as in the below report.

2.JPG

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.

2.JPG

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.

2.JPG

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice one.. 🙂

      Author's profile photo Thanga Prakash Thanga Raj
      Thanga Prakash Thanga Raj
      Blog Post Author

      Thanks Naveen 🙂