Spire.XLS is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Fri Jun 24, 2022 1:11 pm

Is there any way to get from cell it's border information.

While I'm debugging my software, I can inspect my variables and I can see that there's list with contains 6 items (each border type: top, left, right, bottom, diagonal up and down).
I can't figure anyway which would let me extract that information.

Eireannanl
 
Posts: 1
Joined: Fri Jun 24, 2022 12:57 pm

Mon Jun 27, 2022 7:56 am

Hello,

Thanks for your inquiry.

Please refer to the code below to get the border information. If there is any other question, please contact us.
Code: Select all
            CellRange range=sheet.Range["A3"];
            IBorder border=range.Borders[BordersLineType.EdgeTop];
Sincerely,
Andy
E-iceblue support team
User avatar

Andy.Zhou
 
Posts: 483
Joined: Mon Mar 29, 2021 3:03 am

Return to Spire.XLS