参考代码:
- FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
- FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
- DialogResult dlg;
- fpSpread1.Location = new Point(10, 10);
- fpSpread1.Height = 200;
- fpSpread1.Width = 400;
- Controls.Add(fpSpread1);
- fpSpread1.Sheets.Add(shv);
- fpSpread1.ActiveSheet.ColumnCount = 4;
- fpSpread1.ActiveSheet.RowCount = 4;
- string fileName;
- fileName = "..\\..\\bin\\savespreadstream.xls";
- dlg = MessageBox.Show("Do you want to save to an Excel-formatted file??", "SaveExcel", MessageBoxButtons.YesNo);
- if (dlg == DialogResult.Yes)
- {
- fpSpread1.ActiveSheet.SetValue(0, 0, 20);
- fpSpread1.ActiveSheet.SetValue(1, 0, 30);
- fpSpread1.ActiveSheet.SetFormula(2, 2, "Sum(A1,A2)");
- fpSpread1.SaveExcel(fileName);
- }
复制代码
请问楼主是否是刚刚接触 Spread?推荐阅读,会加快你对 Spread 一些基本用法的掌握:
http://www.gcpowertools.com.cn/products/redirect.aspx?r=9 |