Hi I have a few datatables (No DataSet). I have created a method which will write datatable to excel. after writing data from datatable to excel, I will again call the same method of excel generation and pass the datatable which will create excel worksheet and apped it to existing. For each datatable a worksheet will get created.
I am using the following way to create excel worksheet. [Click Here]
I want to apply formatting to it. Built in style "Table Style Medium 4". How is it possible in shortest and easiest way?
PS: Dont want to apply by each cell individually. want to apply to complete sheet.