...
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.
Adding an ExcelWriter Reference in Visual Studio
...