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, 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
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
-
Justin Weng
-
- Posts: 110
- Joined: Mon Mar 28, 2011 5:54 am