Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Chart Namespace / SpreadChart Class / GenerateFromCellRanges Method / GenerateFromCellRanges(SheetView,CellRange[],Boolean) Method
The sheet view.
The cell ranges.
if set to true, the processing switches rows and columns automatically, if necessary.

In This Topic
    GenerateFromCellRanges(SheetView,CellRange[],Boolean) Method
    In This Topic
    Generates a chart from cell ranges.
    Public Overloads Sub GenerateFromCellRanges( _
       ByVal sheetView As SheetView, _
       ByVal cellRanges() As CellRange, _
       ByVal autoSwitch As Boolean _
    Dim instance As SpreadChart
    Dim sheetView As SheetView
    Dim cellRanges() As CellRange
    Dim autoSwitch As Boolean
    instance.GenerateFromCellRanges(sheetView, cellRanges, autoSwitch)
    public void GenerateFromCellRanges( 
       SheetView sheetView,
       CellRange[] cellRanges,
       bool autoSwitch


    The sheet view.
    The cell ranges.
    if set to true, the processing switches rows and columns automatically, if necessary.
    The category parameter is for the category cell range; the seriesName parameter is for the series name cell range; and the data parameter is for the data cell range. The sheetView parameter is how the three cell ranges relate to the SheetView. This function can be used to rebuild a chart.
    This example uses the GenerateFromCellRanges method.
    FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart(typeof(FarPoint.Web.Chart.BarSeries));
    chart.GenerateFromCellRanges(FpSpread1.Sheets[0], new FarPoint.Web.Spread.Model.CellRange(1, 0, 6, 1), new FarPoint.Web.Spread.Model.CellRange(0, 1, 1, 3), new FarPoint.Web.Spread.Model.CellRange(1, 1, 6, 3), true);
    Dim chart As New FarPoint.Web.Spread.Chart.SpreadChart(GetType(FarPoint.Web.Chart.BarSeries))
    chart.GenerateFromCellRanges(FpSpread1.Sheets(0), New FarPoint.Web.Spread.Model.CellRange(1, 0, 6, 1), New FarPoint.Web.Spread.Model.CellRange(0, 1, 1, 3), New FarPoint.Web.Spread.Model.CellRange(1, 1, 6, 3), True)
    See Also