Guest User

Untitled

a guest
Nov 20th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. activeSheet.Copy(Type.Missing, activeSheet);
  2.  
  3. var outputSheetIndex = activeSheet.Index + 1;
  4.  
  5. var outputSheet = (Worksheet)application.Sheets[outputSheetIndex];
  6.  
  7. var startCell = outputSheet.Cells[1, 1];
  8. var endCell = outputSheet.Cells[output.Count(),
  9. properties.Length + 1];
  10.  
  11. var writeRange = outputSheet.Range[startCell, endCell];
  12.  
  13. writeRange.Insert(XlInsertShiftDirection.xlShiftToRight);
Add Comment
Please, Sign In to add comment