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

ashish gupta

8y2.5kVisual Basic .NET

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Leon D8y ago
Accepted 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);
Steven Peterson6y ago
Hey! Try to use ZetExcel.com. It is very easy o use and I can guarantee it will help you.
Kanimozhi Shivakumar8y ago
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.