@John.He , @amjad.sahi, @peyton.xu
// Example: Apply background color priority - Top, Middle, Bottom
Style topStyle = worksheet.Workbook.CreateStyle();
topStyle.ForegroundColor = Color.LightGreen;
topStyle.Pattern = Bac…...ApplyStyle(topStyle, new StyleFlag { CellShading = true...Rows[1].ApplyStyle(middleStyle, new StyleFlag { CellShading = true...