Formatting specific excel sheets in a loop (multiple files) using continental nodes

[pawanmtm]

Hi Arne,

Yes, it certainly helped in moving to next step in a proper manner. I have applied the configurations and respective nodes as suggested, it is processed.

Now we have 2 tag’s 1 for header and 2nd for column formatting, how do i use these in configuring the XLS Sheet Properties node as it allows only 1 tag or is there any different procedure to be followed, could you please suggest on this.

Regards,
Pavan

[arbe]

Hi Pavan,

I’m not sure what exactly you want to achieve with XLS Sheet Properties. Is it to freeze a window? Then I would suggest you define a 3rd tag via Rule Engine on the cell you want to freeze at. You could label this tag “freeze” and enter that value in the XLS Sheet Properties.

Best regards

Arne

[pawanmtm]

Hi Arbe,

I need to have the formatting settings to be applied to sheet 2 & 3, hence the use of XLS Sheet node, does that make sense? If not could you guide how it can be achieved?

Regards.
Pavan