We are trying to set all of the content in the first row to have bold text. However, when we use this code, every other row has bold text. Does anyone have any ideas for working around this? I tried looping back through after this code and setting the other rows to have regular text, but then all cells in the table lose the bold style.
for (int i = 0; i < results.Columns.Count; i++)
{
sheet.Cells[0, i].Style.Font.Bold = true;
hlink = sheet.Hyperlinks.AddHyperlink(0, i);
hlink.Text = dr[i].ToString();
hlink.ActionType = HyperlinkActionType.CellCommand;
hlink.CellCommand = "CustomSort_" + results.Columns[i].ColumnName;
}