How do I change border style

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

How do I change border style

Postby ctseng123 » Fri Jun 24, 2011 10:21 pm

I have a question about border line style.
If I want to change border to only upper and down lines.
For example:
----------
$4000.00
_______

Thanks!
ctseng123
 
Posts: 12
Joined: Sun May 22, 2011 10:25 pm

Re: How do I change border style

Postby Justin Weng » Mon Jun 27, 2011 2:58 am

Dear ctseng123,
Thanks for your inquiry.
Here is a sample code.
Code: Select all
//all sheet style
sheet.Range.Borders[BordersLineType.EdgeTop].LineStyle = LineStyleType.MediumDashDotDot;
sheet.Range.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.SlantedDashDot;
//specify a cell
sheet.Range["B9"].Style.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.MediumDashed;
Justin
Technical Support / Developer,
e-iceblue Support Team
User avatar
Justin Weng
 
Posts: 110
Joined: Mon Mar 28, 2011 5:54 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests