Share Workbook getting checked on exporting excel from asp.net c# -
how uncheck "allow changes more 1 user @ same time." in share workbook in excel while exporting excel c#
i using "microsoft.office.interop.excel" exporting excel
i not 100% sure works. have test it.
create new class inherits excel.worksheet.
class myexcelworksheet : excel.worksheet { public bool multiuserediting { get; set; } }
then can create instace of myexcelworksheet instead of standard one. in example above added set; multiuserediting. allow change property.
myexcelworksheet myworksheet = new myexcelworksheet(); myworksheet.multiuserediting = false; xlworkbook.sheets.add(myworksheet);
while allow change property not if property used when file saved. have check yourself.
Comments
Post a Comment