Write Data with formatting information
Submitted by harrydev on Sun, 06/15/2014 - 14:18We can pass the formatting information to Excel by overloading the constructor which takes an additional object containing the cell format information.
Formatting is required when ever you want to distinguish cell content with other cell contents. Generally, when we update the test cases in excel sheet, we keep all "PASS" in green color and Failed in Red color just to highlight the content.
The below syntax and example program helps to write data into excel sheet using formatting styles