ClosedXML: remove/change alternating row color?

Question

Here's my code so far (VB):

Dim wb As New ClosedXML.Excel.XLWorkbook()
wb.Worksheets.Add(dTable, "export")
wb.SaveAs(location)

How can I remove just styling of the alternate rows (defaults to light blue)

Answer 1

Assuming you want to skip the header row, something like this should work before the save.

For i As Integer = 2 To wb.Worksheets.Worksheet("export").Rows.Count
     wb.Worksheets.Worksheet("export").Row(i).Style.Fill.SetBackgroundColor(XLColor.White)     
Next