How to restrict the BuiltInCellStyleName.Heading1 upto column used

GemBox.Spreadsheet
1

Hi team,

I want to restrict the heading style upto the header are available for perticular worksheet.
I have used the below for header style as per document:
worksheet.Rows(0).Style = workbook.Styles(BuiltInCellStyleName.Heading1)

Could you please suggest in above problem.
Attached one snapshot as well.

Header
Header599×630 56.4 KB

2

Hi Girish,

Try this:

worksheet.Cells.GetSubrange("A1:B1").Style = workbook.Styles(BuiltInCellStyleName.Heading1)

Does this solve your issue?

Regards,
Mario