...

The optional modifier allows that data marker to be ignored on data binding. If you have a column that may be empty, the optional modifier allows you to bind the data set regardless. It is used like this:

Conditional Formatting

[ExcelTemplate|] will persist conditional formatting in a template. In this tutorial, conditional formatting is applied to the "Other" table. It sets negative numbers to be red and bold. Image Added

Adding an ExcelWriter Reference in Visual Studio

...