How to create Read Only Excel In c# MVC ?

Question

Hi Friend need help ? How to create Read Only Excel In c# MVC ?

Pooja Dixit · Answer

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();

Uehara Ayaka · Answer

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

Rupesh Kahane · Answer

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