Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overloads Sub GenerateFromCellRanges( _ ByVal sheetView As SheetView, _ ByVal category As CellRange, _ ByVal seriesName As CellRange, _ ByVal data As CellRange, _ ByVal autoSwitch As Boolean _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SpreadChart Dim sheetView As SheetView Dim category As CellRange Dim seriesName As CellRange Dim data As CellRange Dim autoSwitch As Boolean instance.GenerateFromCellRanges(sheetView, category, seriesName, data, autoSwitch) | |
| C# | |
|---|---|
public void GenerateFromCellRanges( SheetView sheetView, CellRange category, CellRange seriesName, CellRange data, bool autoSwitch ) | |
Parameters
- sheetView
- The sheet view.
- category
- The category.
- seriesName
- Name of the series.
- data
- The data.
- autoSwitch
- if set to
true, the procesing will switch row and column automatically if it's necessary.
Example
This example uses the GenerateFromCellRanges method.
| C# | Copy Code |
|---|---|
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); FpSpread1.Sheets[0].Charts.Add(chart); | |
| Visual Basic | Copy Code |
|---|---|
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) FpSpread1.Sheets(0).Charts.Add(chart) | |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family