I am not able to set the cell formatting via the use of the SetFormatting method. Settings such as the font name, height, color, fill pattern forecground color and fill pattern are not getting applied.
I wrote code similar to the example provided for…