Format and Modify Named Ranges
Format Ranges
How to Set Background Color and Font Attributes to a Named Range
To apply formatting, define a Style object to specify the style settings and apply it to the Range object.
The following example shows how to set the solid fill color (shading color) with font settings to a range.
How to Add Borders to a Named Range
It is possible to add borders to a range of cells instead of just a single cell. The Range object provides a set_outline_border method that takes the following parameters to add a border to the range of cells:
- Border type, the type of border, selected from the BorderType enumeration.
- Line style, the line style, selected from the CellBorderType enumeration.
- Color, the line color, selected from the Color enumeration.
The following example shows how to set an outline border to a range.
How to Rename a Named Range
Aspose.Cells allows you to rename a named range for your need. You may get the named range and rename it by using Name.text attribute. The following example shows how to rename a named range.
How to Take Union of Ranges
Aspose.Cells provides Range.union method to take the union for ranges. The following example shows how to take union for ranges.
How to Intersect the Ranges
Aspose.Cells provides the Range.intersect method to intersect two ranges. The method returns a Range object. To check whether a range intersects another range, use the Range.intersect method that returns a Boolean value. The following example shows how to intersect the ranges.
How to Merge Cells in the Named Range
Aspose.Cells provides Range.merge() method to merge the cells in the range. The following example shows how to merge the individual cells of a named range.