Free Support Forum - aspose.com

Unable to put colour in alternate rows of a Excel file

Hi,
I am using Aspose.cell version 4.8.1.4
I am confused about How to add color
to the alternate rows of a excel sheet?
I have used smart markers in my Excel sheet.


I have attached the zip of project,excel sheet
in which marker is used
and SmartMarker1.xls the generated file from the project.


Please help me on this…

Hi,


Well, you have to use your own code using Aspose.Cells APIs (you should create Style objects and set the color attributes accordingly) to apply formatting to the alternative rows once your markers are processed and filled with data in the cells. See the topic:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/colors-background-patterns.html

Also, see the featured demos, especially check the demo, e.g see the Report Card sheet and check its source code for your reference:
http://www.aspose.com/demos/.net-components/aspose.cells/csharp/school-report.aspx

Thanks Amjad