Hi,
Thanks for your inquiry.
Well, you have to use your own code to set the alternative filling color for the rows using Aspose.Cells APIs. In the latest versions of Aspose.Cells for .NET, you may set the the colors in the following way.
I have created a sample code for your need, kindly consult it.
Sample code:
Dim dt As New DataTable("MyData")
dt.Columns.Add(New DataColumn("MyField", GetType(String)))
dt.Columns.Add(New DataColumn("MyField2", GetType(String)))
Dim dr As DataRow = dt.NewRow()
dr("MyField") = "1"
dr("MyField2") = "ABC"
dt.Rows.Add(dr)
dr = dt.NewRow()
dr("MyField") = "2"
dr("MyField2") = "DEF"
dt.Rows.Add(dr)
dr = dt.NewRow()
dr("MyField") = "3"
dr("MyField2") = "MCF"
dt.Rows.Add(dr)
dr = dt.NewRow()
dr("MyField") = "4"
dr("MyField2") = "MCF"
dt.Rows.Add(dr)
dr = dt.NewRow()
dr("MyField") = "5"
dr("MyField2") = "JKG"
dt.Rows.Add(dr)
Dim designer As New WorkbookDesigner()
designer.Workbook.Worksheets("Sheet1").Cells("A1").PutValue("&=MyData.MyField(noadd)")
designer.Workbook.Worksheets("Sheet1").Cells("B1").PutValue("&=MyData.MyField2(noadd)")
designer.SetDataSource(dt)
designer.Process(False)
designer.Workbook.ConvertNumericData = True
Dim style1 As Style = designer.Workbook.Styles(designer.Workbook.Styles.Add())
style1.ForegroundColor = Color.Yellow
style1.Pattern = BackgroundType.Solid
Dim style2 As Style = designer.Workbook.Styles(designer.Workbook.Styles.Add())
style2.ForegroundColor = Color.Gray
style2.Pattern = BackgroundType.Solid
For i As Integer = 0 To designer.Workbook.Worksheets(0).Cells.MaxDataRow
For j As Integer = 0 To designer.Workbook.Worksheets(0).Cells.MaxDataColumn
If i Mod 2 = 0 Then
designer.Workbook.Worksheets(0).Cells(i, j).SetStyle(style1)
Else
designer.Workbook.Worksheets(0).Cells(i, j).SetStyle(style2)
End If
Next j
Next i
designer.Save("f:\test\out_msm2.xls", FileFormatType.Default)
I have also attached the output file here.
Thank you.
Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us
