How do I create an excel file with locked (read-only) in C#

Question

I have data in data gried ,I am exporting data in excel ,but i am not able to do this with non-editable columns,please help.

Leon D · Answer

Hi, It's fairly simple to do this with Spire.Xls.dll, you can get it from NuGet (https://www.nuget.org/packages/Spire.XLS/), and then refer to the following code: Workbook workbook = new Workbook(); //Load file workbook.LoadFromFile( "Input.xlsx" ); //Get the first worksheet Worksheet sheet = workbook.Worksheets[0]; //Allow inserting rows and columns into the protected sheet sheet.Protect( "123456" , SheetProtectionType.InsertingRows | SheetProtectionType.InsertingColumns); DataTable dt = dataGridView1.DataSource as DataTable; //export datatable to excel sheet.InsertDataTable(dt, true , 10, 1); //save workbook.SaveToFile( "Output.xlsx" , ExcelVersion.Version2010);

Kanimozhi Shivakumar · Answer

Syntax for prectecting the Excel:- Protect( object Password, object DrawingObjects, object Contents, object Scenarios, object UserInterfaceOnly, object AllowFormattingCells, object AllowFormattingColumns, object AllowFormattingRows, object AllowInsertingColumns, object AllowInsertingRows, object AllowInsertingHyperlinks, object AllowDeletingColumns, object AllowDeletingRows, object AllowSorting, object AllowFiltering, object AllowUsingPivotTables ) Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; lApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Add(); xlWorkSheet = xlApp.ActiveSheet; Work sheet with password protection, Use below code:- xlWorkSheet.Protect( "passwordstring" , true , true , true , true , true , true , true , Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, true , true , Type.Missing); Work sheet without password protection, Use below code:- xlWorkSheet.Protect(Type.Missing, Type.Missing, true , Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); I think this code will help you out for your scenario.

Steven Peterson · Answer

Hey! Try to use ZetExcel.com. It is very easy o use and I can guarantee it will help you.