Exemplos de Microsoft.Office.Interop.Excel.Insert em C# (CSharp)

Exemplo n.º 1

Arquivo: tmio_DS2XL.cs Projeto: tormoz70/Bio.Framework.8

 private Excel.Range addFirstCol(ref Excel.Range pRng, Excel.Range vCurCol) {
   int vCurColN = vCurCol.Column;
   int vCurRowN = vCurCol.Row;
   int vCurRowsN = vCurCol.Rows.Count;
   vCurCol.Insert(Excel.XlInsertShiftDirection.xlShiftToRight, true);
   Excel.Range vNewCol = ExcelSrv.getRange(vCurCol.Worksheet, vCurCol.Worksheet.Cells[vCurRowN, vCurColN],
                                                      vCurCol.Worksheet.Cells[vCurRowN + vCurRowsN, vCurColN]);
   vCurCol.Copy(vNewCol);
   vCurCol.ColumnWidth = vNewCol.ColumnWidth;
   return vCurCol;
 }