series0.SeriesNameDataSource = new FarPoint.Win.Spread.Chart.SeriesDataField(fpSpread1, "DataFieldSeriesName", "Sheet1!$A$2:$A$2", FarPoint.Win.Spread.Chart.SegmentDataType.Text);
series0.XValues.DataSource = new FarPoint.Win.Spread.Chart.SeriesDataField(fpSpread1, "DataFieldValue", "Sheet1!$B$1:$E$1");
series0.YValues.DataSource = new FarPoint.Win.Spread.Chart.SeriesDataField(fpSpread1, "DataFieldValue", "Sheet1!$B$2:$E$2");
위 소스에서요 포뮬라 부분 ("Sheet1!$B$2:$E$2") 을 range 로 표시할 수 있는 방법이 없을까요?
예를 들면 Fpsprd.Sheets[0].Cells[0, 0, 1, 3] 이렇게요...
하여튼 현재는
FarPoint.Win.Chart.XYPlotArea PlotAreas = new FarPoint.Win.Chart.XYPlotArea();
for (int i = 1; i < row_cnt; i++)
{
FarPoint.Win.Chart.XYLineSeries series = new FarPoint.Win.Chart.XYLineSeries();
series.SeriesName = frm.fpSpread1.Sheets[0].Cells[i, 0].Text.Trim();
for (int j = 1; j < col_cnt; j++)
{
series.XValues.Add(Convert.ToDouble(frm.fpSpread1.Sheets[0].Cells[0, j].Value));
series.YValues.Add(Convert.ToDouble(frm.fpSpread1.Sheets[0].Cells[i, j].Value));
}
series.SmoothedLine = true;
FarPoint.Win.Chart.NoMarker noMarker = new FarPoint.Win.Chart.NoMarker();
series.PointMarker = noMarker;
PlotAreas.Series.Add(series);
}
이렇게 쓰고있습니다.