Excel中插入图表咨询

请问Spread输出Excel时，能否根据数据做一些图表（例如柱状图之类）一起输出到Excel中，
如果可以的话，能否提供一下简单的实现代码

另外求教，输出的Excel是否能够隐藏指定行显示

谢谢！

通过这样的代码可以添加图表：

1. FpSpread1.Sheets[0].RowCount = 10;
   
2. FpSpread1.Sheets[0].ColumnCount = 10;
   
3. FpSpread1.Sheets[0].Cells[0, 1].Value = "c1";
   
4. FpSpread1.Sheets[0].Cells[0, 2].Value = "c2";
   
5. FpSpread1.Sheets[0].Cells[0, 3].Value = "c3";
   
6. FpSpread1.Sheets[0].Cells[1, 0].Value = "s1";
   
7. FpSpread1.Sheets[0].Cells[2, 0].Value = "s2";
   
8. FpSpread1.Sheets[0].Cells[3, 0].Value = "s3";
   
9. FpSpread1.Sheets[0].Cells[4, 0].Value = "s4";
   
10. FpSpread1.Sheets[0].Cells[1, 1].Value = 1;
    
11. FpSpread1.Sheets[0].Cells[2, 1].Value = 2;
    
12. FpSpread1.Sheets[0].Cells[3, 1].Value = 3;
    
13. FpSpread1.Sheets[0].Cells[4, 1].Value = 4;
    
14. FpSpread1.Sheets[0].Cells[1, 2].Value = 7;
    
15. FpSpread1.Sheets[0].Cells[2, 2].Value = 8;
    
16. FpSpread1.Sheets[0].Cells[3, 2].Value = 9;
    
17. FpSpread1.Sheets[0].Cells[4, 2].Value = 10;
    
18. FpSpread1.Sheets[0].Cells[1, 3].Value = 13;
    
19. FpSpread1.Sheets[0].Cells[2, 3].Value = 14;
    
20. FpSpread1.Sheets[0].Cells[3, 3].Value = 15;
    
21. FpSpread1.Sheets[0].Cells[4, 3].Value = 16;
    
22. FarPoint.Web.Spread.Model.CellRange range = new FarPoint.Web.Spread.Model.CellRange(0, 0, 4, 4);
    
23. FpSpread1.Sheets[0].AddChart(range, typeof(FarPoint.Web.Chart.ClusteredBarSeries), 200, 200, 0, 0, FarPoint.Web.Chart.ChartViewType.View3D, false);
    
24. 
    

复制代码

同时，如果想在导出时隐藏名列，只需将该列的设置为不可见就可以：
FpSpread1.ActiveSheetView.Columns[0].Visible = false;

非常感谢

不客气