Other API Samples

Live SpreadsheetGear API Samples

Range Samples Formatting and Other Cell Features Borders

Demonstrates setting various border style options such as LineStyle, Weight and Color; as well as affecting specific border edges or all edges at once.

// Create a new workbook and some local variables.
SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
SpreadsheetGear.IWorksheet worksheet = workbook.ActiveWorksheet;
SpreadsheetGear.IBorder border;

// Setup range to change borders.
SpreadsheetGear.IRange range = worksheet.Cells["B2:D8"];

// EXAMPLE 1: Set top border style.
{
    // Get a reference to the top border of the range.
    border = range.Borders[SpreadsheetGear.BordersIndex.EdgeTop];

    // Set the border LineStyle, Weight, and Color.
    border.LineStyle = SpreadsheetGear.LineStyle.Continuous;
    border.Weight = SpreadsheetGear.BorderWeight.Thick;
    border.Color = SpreadsheetGear.Colors.Blue;
}

// EXAMPLE 2: Set left border style.
{
    // Get a reference to the left border of the range.
    border = range.Borders[SpreadsheetGear.BordersIndex.EdgeLeft];

    // Set the border LineStyle, Weight, and Color.
    border.LineStyle = SpreadsheetGear.LineStyle.Continuous;
    border.Weight = SpreadsheetGear.BorderWeight.Medium;
    border.ThemeColor = SpreadsheetGear.Themes.ColorSchemeIndex.Accent1;
}

// EXAMPLE 3: Set bottom border style.
{
    // Get a reference to the bottom border of the range.
    border = range.Borders[SpreadsheetGear.BordersIndex.EdgeBottom];

    // Set the border LineStyle, Weight, and Color.
    border.LineStyle = SpreadsheetGear.LineStyle.Continuous;
    border.Weight = SpreadsheetGear.BorderWeight.Thin;
    border.ThemeColor = SpreadsheetGear.Themes.ColorSchemeIndex.Accent2;
    border.TintAndShade = -0.5;
}

// EXAMPLE 4: Set right border style.
{
    // Get a reference to the right border of the range.
    border = range.Borders[SpreadsheetGear.BordersIndex.EdgeRight];

    // Set the border LineStyle, Weight, and Color.
    border.LineStyle = SpreadsheetGear.LineStyle.Double;
    border.Weight = SpreadsheetGear.BorderWeight.Thick;
    border.Color = SpreadsheetGear.Color.FromArgb(255, 0, 0);
}

// EXAMPLE 5: Set inside horizontal borders style.
{
    // Get a reference to the inside horizontal borders of the range.
    border = range.Borders[SpreadsheetGear.BordersIndex.InsideHorizontal];

    // Set the border LineStyle, Weight, and Color.
    border.LineStyle = SpreadsheetGear.LineStyle.Continuous;
    border.Weight = SpreadsheetGear.BorderWeight.Thin;
    border.ColorIndex = 23;
}

// EXAMPLE 6: Set inside vertical borders style.
{
    // Get a reference to the inside vertical borders of the range.
    border = range.Borders[SpreadsheetGear.BordersIndex.InsideVertical];

    // Set the border LineStyle, Weight, and Color.
    border.LineStyle = SpreadsheetGear.LineStyle.Continuous;
    border.Weight = SpreadsheetGear.BorderWeight.Thin;
    border.Color = SpreadsheetGear.Colors.Black;
}

// EXAMPLE 7: Set all borders at once.
{
    // Get a reference to the range to change borders.
    range = worksheet.Cells["B10:D16"];

    // Get a reference to the inside vertical borders of the range.
    SpreadsheetGear.IBorders borders = range.Borders;

    // Set the border LineStyle, Weight, and Color.
    borders.LineStyle = SpreadsheetGear.LineStyle.Continuous;
    borders.Weight = SpreadsheetGear.BorderWeight.Medium;
    borders.Color = SpreadsheetGear.Colors.Orange;
}
Run This Sample
Render Image

Generate an image representation of the results of this sample, which uses the SpreadsheetGear.Drawing.Image class to convert ranges, charts and shapes to images.


Download File

Download an Excel Open XML Workbook (*.xlsx) file with the results of this sample.

Related Samples