It’s safe to assume Style.Fill.BackgroundColor and Style.Font.Color are both of type ExcelColor, so just use the same SetColor() method you used to set the background color. rowRngprogramParamsRange.Style.Font.Color.SetColor(Color.Red);
Look closely at the two lines: worksheet.Cells[“A32:D32”].Style.Fill.PatternType = ExcelFillStyle.Solid; worksheet.Cells[“A32:D33”].Style.Fill.BackgroundColor.SetColor(Color.CornflowerBlue); The second line has D33 instead of D32 so if D33 is not set yet it would throw that error.
Not sure why but none of the above solution work for me. So sharing what worked: public void readXLS(string FilePath) { FileInfo existingFile = new FileInfo(FilePath); using (ExcelPackage package = new ExcelPackage(existingFile)) { //get the first worksheet in the workbook ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; int colCount = worksheet.Dimension.End.Column; //get Column Count int rowCount = worksheet.Dimension.End.Row; … Read more