Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

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