CODEWITHSUNDEEP
asposeaspose-cells
Dominik Kirschenhofer
Dominik Kirschenhofer

Reputation: 1205

Dynamic format in aspose.cells generated excel

Is it possible to create a conditional format or something like that where the format is depending on the value of the cell?

For example when there is "#000000" as cell value, the background color of the cell should be black.

It is possible to have a condition on the cell value but I did not find any example where the format is dynamic. And it is no Option to create a format for each possible hex-color =)

Upvotes: 0

Views: 1097

Answers (1)

shakeel
shakeel

Reputation: 1725

Yes it is possible to add such a conditional formatting dynamically using Aspose.Cells. Please add your desired conditional formatting using the Worksheet.ConditionalFormattings collection. It will be better if you create your conditional formatting using Microsoft Excel and then load your workbook using Aspose.Cells and observe the properties of your conditional formatting object by exploring Worksheet.ConditionalFormattings collection and then create the same conditional formatting object through code. If you find any difficulty, then please feel free to post in Aspose.Cells forum on Aspose Website.

Please also see this article for your help in working with conditional formatting.

http://www.aspose.com/docs/display/cellsnet/Conditional+Formatting

Note: I am working as Developer Evangelist at Aspose

Upvotes: 1

Related Questions