C# 随笔

1.Range.End属性

//示例
mysheet.Cells[5, 5].Value = mysheet.Range["G65536"].End[Excel.XlDirection.xlUp].Row;

 2. 字典相关

//定义
Dictionary<string, string> Blocksheet = new Dictionary<string, string>(); 

//遍历
 foreach(string a in Blocksheet.Keys)
 {
     tablesheets[i]=Globals.ThisAddIn.Application.Worksheets[a];
     i = i + 1;
 }

 3. Sheet表数组定义

//定义
Excel.Worksheet[] tablesheets = new Excel.Worksheet[3];

4. 插入行列

//插入Range,往左移或者往下移
Range.Insert(Excel.XlInsertShiftDirection.xlShiftToRight);

5.得到最后一个单元格

tablesheets[i].UsedRange.Cells[tablesheets[i].UsedRange.Count]