c# - Paste rows from one sheet to another with paste link option -
i able paste rows 1 worksheet using:
sourcesheet.usedrange.copy(); destinationsheet.usedrange.pastespecial( excel.xlpastetype.xlpastevalues, excel.xlpastespecialoperation.xlpastespecialoperationnone, false, false);
but want changes made cells in source sheet should reflected in destination sheet. (paste link option in excel) how in c#?
Comments
Post a Comment