public static void AddPermission() { Excel.Application ExcelApp = new Excel.Application(); Workbook ExcelWorkBook = null; ExcelApp.Visible = true; ExcelWorkBook = ExcelApp.Workbooks.Open(@"C:\Workspace\OneModernize\April\Mywork\excelAccesssNet\TFSStatus.xlsx"); /// add excel path ExcelWorkBook.Activate(); ExcelWorkBook.Permission.Enabled = true; DateTime dtExpireDate = DateTime.Now.AddDays(1); /// Add user mail xxx@cognizant.com ExcelWorkBook.Permission.Add("xxx@cognizant.com", MsoPermission.msoPermissionFullControl, ExpirationDate: dtExpireDate); ExcelWorkBook.Close(); ExcelApp.Quit(); Marshal.ReleaseComObject(ExcelWorkBook); Marshal.ReleaseComObject(ExcelApp); }
How to set expiry date in excel file
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)