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.

Mon Jun 23, 2008 9:19 pm

Hi,
I'm trying to add a double lined border to my worksheet, that is only on the top, and left line of the cell, none of your examples have a border in them, please explain how to do this.

Thank You

chadmilden
 
Posts: 1
Joined: Mon Jun 23, 2008 9:13 pm

Tue Jun 24, 2008 8:28 am

Maybe this could help:

Code: Select all
Workbook workbook = new Workbook();
CellStyle borderStyle = workbook.Styles.Add("borderStyle");
borderStyle.Borders[BordersLineType.EdgeLeft].LineStyle = LineStyleType.Double;
borderStyle.Borders[BordersLineType.EdgeRight].LineStyle = LineStyleType.Thin;
borderStyle.Borders[BordersLineType.EdgeTop].LineStyle = LineStyleType.Double;
borderStyle.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.Thin;

pb
 
Posts: 14
Joined: Fri Jun 20, 2008 11:05 am

Return to Spire.XLS