We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Outer Borders for XlSio

As far as I can tell, you can only set styles and borders that will apply to individual cells and not outer borders for ranges of cells.  So if I want to create

Example of a border style: 

Style bordered = workbook.styles.add('bordered');

bordered.borders.all.lineStyle = LineStyle.thin;

sheet.getRangeByName('A1:H10').cellStyle = bordered;

This gives every individual cell a thin border around it, as desired.

However, if I want to display a LineStyle.thick around just the outer borders of this box (A10:C10) with the inner cells having the thin border, I need to create 5-9 total styles? (depending on other requirements).  Or is there a better way to define cell specific border styles and then Range outer border styles...in a way consistent with how excel itself treats this?

1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team November 23, 2022 08:52 AM

Hi Bryan,

Syncfusion Flutter XlsIO do not have support for applying outside borders to a range as requested. As of now, borders must be applied individually to meet your needs. 



Live Chat Icon For mobile
Up arrow icon