Reduce code that refers to the same object?

Question

Here the code, would you have any way to reduce it? (Just for learning reasons)

worksheet.Row(1).Style.Font.FontColor = ClosedXML.Excel.XLColor.White;
worksheet.Row(1).Style.Font.Bold = true;
worksheet.Row(1).Style.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center);
worksheet.Row(1).Style.Alignment.SetVertical(XLAlignmentVerticalValues.Center);
worksheet.Row(1).Height = 32;

I thought of something like...

worksheet.Row(1)(.Style.Font.FontColor = ClosedXML.Excel.XLColor.White).Style.Font.Bold = true;

But it doesn’t work :/

Answer 1

It doesn’t really work and it doesn’t make any sense. The most you could do is:

var objeto = worksheet.Row(1).Style;
objeto.Font.FontColor = ClosedXML.Excel.XLColor.White;
objeto.Font.Bold = true;
objeto.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center);
objeto.Alignment.SetVertical(XLAlignmentVerticalValues.Center);

I put in the Github for future reference.

Obviously you could have another object without the Stype to catch the Height and could also have one that had together the Font or the Aligment. But there’s no gain.

I’d avoid that until I’m sure you’ve mastered all the consequences. This, the way it is, without considering the context, will work, but a more complex example may not work the way you expect.

This is a normal repetition that does not cause problems, it is not a case for DRY.