[Excel Package] Cell_WriteRangeWithFormat Format Not Working

[Excel Package] Cell_WriteRangeWithFormat Format Not Working

  
Forge Component
(4)
Published on 2 Aug by Carlos Alfaro
4 votes
Published on 2 Aug by Carlos Alfaro

Hi,

I tried to use the Cell_WriteRangeWithFormat action specifying a format with background color and bold text, but format works only for first cell and not for entire range. Please see attachment for sample data

Junaid Ahmed Syed wrote:

Hi,

I tried to use the Cell_WriteRangeWithFormat action specifying a format with background color and bold text, but format works only for first cell and not for entire range. Please see attachment for sample data


Can you share me a screen shot or better OML file ?. Need to see what are the parameters that you are passing.

Here is the local variable I am using to set format


And here I am using that variable


Finally here is what I get in excel