How to create Read Only Excel In c# MVC ?

 I hope this may help you.

 

// The Logic of Excel Sheet Read..

if (Request.Files["fileupload1"].ContentLength > 0)

{

string extension = System.IO.Path.GetExtension(Request.Files["FileUpload1"].FileName);

string path1 = string.Format("{0}/{1}", Server.MapPath("~/UploadExcel"), Request.Files["FileUpload1"].FileName);

if (System.IO.File.Exists(path1))

System.IO.File.Delete(path1);

Request.Files["FileUpload1"].SaveAs(path1);

string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path1 + ";Extended Properties=Excel 12.0;Persist Security Info=false";

using (OleDbConnection excel_con = new OleDbConnection(excelConnectionString))

{

excel_con.Open();

 

string sheet1 = excel_con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null).Rows[0]["TABLE_NAME"].ToString();

DataTable dtExcelData = new DataTable();

 

//[OPTIONAL]: It is recommended as otherwise the data will be considered as String by default.

 

dtExcelData.Columns.AddRange(new DataColumn[4]

 

//Whenever Data Columns Are Read.

 

{ new DataColumn("Hours", typeof(float)),

new DataColumn("Date", typeof(DateTime)),

new DataColumn("Description",typeof(string)),

new DataColumn("Id",typeof(int)) });

using (OleDbDataAdapter oda = new OleDbDataAdapter("SELECT * FROM [" + sheet1 + "]", excel_con))

{

oda.Fill(dtExcelData);

}

excel_con.Close();

If you use spire.xls, you can easily create an Excel file and lock the worksheets in it. Here is the guidence. 

 

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Lock-Easily-Lock-Excel-Worksheet-in-C-VB.NET.html 

Refere below articles

1) http://www.c-sharpcorner.com/UploadFile/dbb82e/read-data-from-excel-filexlsxlsxcsv-in-Asp-Net-mvc/

2) http://www.mitechdev.com/2016/10/How-to-read-and-display-excelfile-in-mvc-webapplication.html

3) http://www.c-sharpcorner.com/blogs/upload-and-read-excel-file-in-mvc1

 

All The Best