Spread基本知识（二）

Spread基本知识（二）
1.FpSpread控件,指定单元格获取焦点.
```
 Me.FpSpread1.ActiveSheet.SetActiveCell(1, 1, False)
```
最后一个参数如果为False则,选择新的单元格时,不清除已选择的对象.
2.FpSpread控件,锁定单元格,行,列.
```
  '锁定列
```
```
        Me.FpSpread1.ActiveSheet.Columns(0, 1).Locked = True
```
```
        Me.FpSpread1.ActiveSheet.Columns(3).Locked = True
```
```
 
```
```
        '锁定行
```
```
        Me.FpSpread1.ActiveSheet.Rows(0).Locked = True
```
```
        Me.FpSpread1.ActiveSheet.Rows(2, 3).Locked = True
```
```
 
```
```
        '锁定单元格
```
```
        Me.FpSpread1.ActiveSheet.Cells(4, 5, 6, 9).Locked = True
```
```
 
```
```
        '锁定区域的背景色
```
```
        Me.FpSpread1.ActiveSheet.LockBackColor = Color.Red
```
```
        '前景色
```
```
        Me.FpSpread1.ActiveSheet.LockForeColor = Color.Blue
```
3.FpSpread控件,增加行和列
```
   Me.ShowMesage(String.Format("当前有 {0} 行 {1} 列", Me.FpSpread1.ActiveSheet.Rows.Count,  
     Me.FpSpread1.ActiveSheet.Columns.Count))
```
```
        '增加列
```
```
  Me.FpSpread1.ActiveSheet.Columns.Add(Me.FpSpread1.ActiveSheet.Columns.Count, 1)
```
```
  '增加行
```
```
   Me.FpSpread1.ActiveSheet.Rows.Add(Me.FpSpread1.ActiveSheet.Rows.Count, 1)
```
```
   Me.ShowMesage(String.Format("现在有 {0} 行 {1} 列", _
```
```
    Me.FpSpread1.ActiveSheet.Rows.Count, Me.FpSpread1.ActiveSheet.Columns.Count))
```
4.FpSpread控件,删除行和列
```
      Me.ShowMesage(String.Format("当前有 {0} 行 {1} 列", Me.FpSpread1.ActiveSheet.Rows.Count, _
```
```
                    Me.FpSpread1.ActiveSheet.Columns.Count))
```
```
 
```
```
        Me.FpSpread1.ActiveSheet.Columns.Remove(10, Me.FpSpread1.ActiveSheet.Columns.Count - 10)
```
```
        Me.FpSpread1.ActiveSheet.Rows.Remove(10, Me.FpSpread1.ActiveSheet.Rows.Count - 10)
```
```
 
```
```
        Me.ShowMesage(String.Format("现在有 {0} 行 {1} 列", _
```
```
         Me.FpSpread1.ActiveSheet.Rows.Count, Me.FpSpread1.ActiveSheet.Columns.Count))
```
高压开关柜
|
开关114
相关阅读:
NUI四种提交数据方式c
除Hadoop大数据技术外，还需了解的九大技术
 svn提交报错：svn: Aborting commit:XXXXXremains in conflict
普元部署多个应用的方法(适用EOS6.5以上版本,且无需governor中添加应用)
C#根据html生成PDF
判断一个数值是否在一个逗号分隔的字符串中
 判断网站地址是否是http开头
 Date.prototype.format
C#实现XML与DataTable互转
 C#读取Excel表格数据到DataGridView中和导出DataGridView中的数据到Excel
原文地址：https://www.cnblogs.com/zqonline/p/1353918.html