Setting alternative row color in an Excel file in ASP.NET Web(Classic) Forms.

 IWorkbook workbook = application.Workbooks.Open(fileName, ExcelOpenType.Automatic);  
 IWorksheet sheet = workbook.Worksheets[0];
 
// Alternative row coloring for the Entire sheet can be achieved by     sheet.Range["$1:$1048576"].conditionalFormats
 
// Applying alternative row coloring for UsedRange.        
 IConditionalFormats condition = sheet.UsedRange.ConditionalFormats;
 IConditionalFormat condition1 = condition.AddCondition();
 condition1.FormatType = ExcelCFType.Formula;
 condition1.FirstFormula = "MOD(ROW(),2)=0";
 condition1.BackColorRGB = Color.LightGray;
 

 Dim workbook As IWorkbook = application.Workbooks.Open(fileName,     ExcelOpenType.Automatic)
 Dim sheet As IWorksheet = workbook.Worksheets(0)
 
' Alternative row coloring for the Entire sheet can be achieved by     sheet.Range["$1:$1048576"].conditionalFormats
 
' Applying alternative row coloring for UsedRange       
 Dim condition As IConditionalFormats = sheet.UsedRange.ConditionalFormats
 Dim condition1 As IConditionalFormat = condition.AddCondition()
 condition1.FormatType = ExcelCFType.Formula
 condition1.FirstFormula = "MOD(ROW(),2)=0"
 condition1.BackColorRGB = Color.LightGray
 

// Applying alternative row coloring for specific range.
IRange range = sheet[3, 1, sheet.UsedRange.LastRow, sheet.UsedRange.LastColumn]; 
IConditionalFormats condition = range.ConditionalFormats; 
IConditionalFormat condition1 = condition.AddCondition(); 
condition1.FormatType = ExcelCFType.Formula; 
condition1.FirstFormula = "MOD(ROW(),2)=0"; 
condition1.BackColorRGB = Color.LightGray;