officewriter - Password protected excel -

can create password protected excel workbook or sheet 'officewriter' api? requirement create pwd protected excel programatically (c#) out having install office in servers. have tried openxml when password protected file showing corrupted , not opening. let me know if possible 'officewriter'.

note: work softartisans, makers of officewriter.

yes, possible password protect excel workbook programmatically officewriter.

if using our excelapplication api programmatically manipulate workbook, can protect workbooks , worksheets.

workbook.protect(string) protect structure of workbook supplied password. example, users won't able add or remove worksheets without password.

worksheet.protect(string) write-protects worksheet users cannot modify worksheet in excel without entering password.

excelapplication xla = new excelapplication(); workbook wb = xla.open("myworkbook.xlsx");  wb.protect("workbookpassword"); wb.worksheets["sheet1"].protect("worksheetpassword");  xla.save(wb, "myworkbook_output.xlsx"); 

if using our exceltemplate api bind data template contains placeholder markers, can set exceltemplate.encryptpassword encrypt workbook given password using rc4 encryption.

 exceltemplate xlt = new exceltemplate();  xlt.open("template.xlsx");  ...  xlt.encryptpassword = "mypassword";  xlt.process();  xlt.save("output.xlsx");