Set Default Font while rendering spreadsheet to images
Contents
[
Hide
]
Please use the ImageOrPrintOptions.DefaultFont property to set the default font while rendering spreadsheets to images. This property will only be effective when the default font of the workbook could not render your characters. The default font specified with ImageOrPrintOptions.DefaultFont property is used for all those cells which have invalid or non-existent fonts.
Set Default Font while rendering spreadsheet to images
The following sample code creates a workbook, adds some text in cell A4 of the first worksheet, and sets its font to invalid or non-existent font. Then, it takes two images of the worksheet. The first image is taken by setting the ImageOrPrintOptions.DefaultFont property to Courier New and the second image is taken by setting the ImageOrPrintOptions.DefaultFont property to Times New Roman.
This is the output image after setting the ImageOrPrintOptions.DefaultFont property to Courier New.
This is the output image after setting the ImageOrPrintOptions.DefaultFont property to Times New Roman.
Sample Code