첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.
728x90
반응형
728x170

FarPoint.Win.Spread.SheetView sheetView = new FarPoint.Win.Spread.SheetView();

FarPoint.Win.Spread.Chart.SheetCellRange dataSheetCellRange     = new FarPoint.Win.Spread.Chart.SheetCellRange(sheetView, 0, 0, 1, 5);
FarPoint.Win.Spread.Chart.SheetCellRange locationSheetCellRange = new FarPoint.Win.Spread.Chart.SheetCellRange(sheetView, 5, 0, 1, 1);

FarPoint.Win.Spread.ExcelSparklineSetting excelSparklineSetting = new FarPoint.Win.Spread.ExcelSparklineSetting();

excelSparklineSetting.AxisColor        = Color.SaddleBrown;
excelSparklineSetting.ShowFirst        = true;
excelSparklineSetting.ShowHigh         = true;
excelSparklineSetting.ShowLow          = true;
excelSparklineSetting.ShowLast         = true;
excelSparklineSetting.FirstMarkerColor = Color.Blue;
excelSparklineSetting.HighMarkerColor  = Color.DarkGreen;
excelSparklineSetting.MarkersColor     = Color.Aquamarine;
excelSparklineSetting.LowMarkerColor   = Color.Red;
excelSparklineSetting.LastMarkerColor  = Color.Orange;
excelSparklineSetting.ShowMarkers      = true;

fpSpread1.Sheets[0] = sheetView;

sheetView.Cells[0, 0].Value = 2;
sheetView.Cells[0, 1].Value = 5;
sheetView.Cells[0, 2].Value = 4;
sheetView.Cells[0, 3].Value = 1;
sheetView.Cells[0, 4].Value = 3;

fpSpread1.Sheets[0].AddSparkline(dataSheetCellRange, locationSheetCellRange, FarPoint.Win.Spread.SparklineType.Line, excelSparklineSetting);
728x90
반응형
그리드형(광고전용)
Posted by icodebroker

댓글을 달아 주세요