ComponentOne Excel for .NET
In This Topic
    Setting Print Area in a Sheet
    In This Topic

    To set print area (or range) in XLSheet, use the following code to add an instance of the required XLCellRange to C1XLBook.NamedRanges collection.

    Dim sheet As XLSheet = C1XLBook1.Sheets (0)
Dim range As XLCellRange = New XLCellRange (sheet, 0, 2, 0, 4) 
C1XLBook1. NamedRanges.Add ("Print_Area", range)

    XLSheet sheet = C1XLBook1.Sheets(0);
XLCellRange range = new XLCellRange(sheet, 0, 2, 0, 4);
C1XLBook1.NamedRanges.Add("Print_Area", range);