楼主你好,使用下面的代码测试吧,详细请参见注释,有疑问欢迎继续交流:
- //设置数据源
- DataTable dataSource = new DataTable();
- dataSource.Columns.Add("第一列", typeof(System.String));
- dataSource.Columns.Add("第二列", typeof(System.String));
- dataSource.Columns.Add("第三列", typeof(System.Int32));
- dataSource.Rows.Add("1", "1", "1");
- dataSource.Rows.Add("1", "1", "1");
- dataSource.Rows.Add("1", "1", "1");
- //设置单元格类型
- FarPoint.Web.Spread.TextCellType textCellType = new FarPoint.Web.Spread.TextCellType();
- textCellType.ShowEditor = true;
- this.FpSpread1.Sheets[0].RowCount = 4;
- //设置单元格 text 为当前时间
- this.FpSpread1.Sheets[0].Cells[0, 0].Text = System.DateTime.Now.ToString();
- //绑定单个 TextBox
- this.FpSpread1.Sheets[0].Cells[1, 0].Text = dataSource.Rows[0][0].ToString();
- this.FpSpread1.Sheets[0].Cells[2, 0].Text = dataSource.Rows[1][0].ToString();
- this.FpSpread1.Sheets[0].Columns[0].CellType = textCellType;
- //设置求和公式
- this.FpSpread1.Sheets[0].Cells[3, 0].Formula = "SUM(A2+A3)";
复制代码 |