I'm using this component to generate an excell file with auto generated worksheets.The component supports the usage of templates. Unfortunately, it is only supported for pre defined worksheet names.Is there anyway to implement a cell formatting?
If i am correct you want to write a fully formatted excel with control on every cell. I did this using ExcelPackage which allow you to write row by row and cell by cell.
Niels Favreau wrote:
Depends on which formatting do you need. You can create one template sheet with conditional formatting on the cells and use it by cloning the sheet.
Additionally the extensions allow you to edit them and write your own code for any additional requirment.