How to import excel file in my html page in MVC?

Question

Ibrahim Siddique · Answer

find below action [HttpPost] public ActionResult Upload(HttpPostedFileBase file) { var resultModel = new UploadTrainingReturnViewModel() { ValidTrainings = new List (), InvalidTrainings = new List (), ErrorMessage = string.Empty }; try { if (file == null) { ModelState.AddModelError("File", "File is required"); return View(); } if (Path.GetExtension(file.FileName).Equals(".xlsx") || !Path.GetExtension(file.FileName).Equals(".xls")) { IExcelDataReader excelReader; if (Path.GetExtension(file.FileName).Equals(".xls")) excelReader = ExcelReaderFactory.CreateBinaryReader(file.InputStream); else excelReader = ExcelReaderFactory.CreateOpenXmlReader(file.InputStream); excelReader.IsFirstRowAsColumnNames = true; DataSet result = excelReader.AsDataSet(); var model = new List (); excelReader.Close(); var lstValidTraning = new List (); var lstInvalidTraning = new List (); try { foreach (DataRow training in result.Tables[0].Rows) { if (training.IsNull("CourseTitle")) continue; if (!lstValidTraning.Any(a => a.CourseId.Equals(training[1].ToString()) && training[1].ToString()!=null)) { var uploadtraning = new UploadTrainingViewModel { CourseTitle = training[0].ToString(), CourseId = training[1].ToString(), CourseVersion = training[2].ToString(), CourseDomain = training[3].ToString(), CourseCode = training[4].ToString(), CourseSchool = training[5].ToString(), CourseCategory = training[6].ToString(), CourseProficiencyLevel = training[7].ToString(), CourseEvent = training[8].ToString(), RequestManager = training[9].ToString(), DisplayForLearners = training[10].ToString(), CourseLinkDesc = training[11].ToString() }; if (TryValidateModel(uploadtraning)) lstValidTraning.Add(uploadtraning); else lstInvalidTraning.Add(uploadtraning); } } try { if (lstValidTraning.Any()) { // saves data using servics uploadStatus = trainingServices.UploadTraning(lstValidTraning); resultModel.ValidTrainings.AddRange(lstValidTraning); resultModel.ErrorMessage = "Traning data uploaded."; } } catch (Exception ex) { l resultModel.ErrorMessage = "Error at upoad Traning data."; resultModel.InvalidTrainings.AddRange(lstInvalidTraning); return View(resultModel); } } catch (Exception ex) { resultModel.ErrorMessage = "Error at upoad Traning data."; resultModel.InvalidTrainings.AddRange(lstInvalidTraning); return View(resultModel); } } return View(resultModel); } catch (Exception ex) { return View(resultModel); } }

Maen Badwan · Answer

If you mean you want to display Excel files in your ASP.NET MVC application, you can check the HTML5/JavaScript document viewer control from LEADTOOLS. For example, the following code shows how you can initialize the document viewer control and load the Excel file: window.onload = function () { // Init the document viewer, pass along the panels var createOptions = new lt.Documents.UI.DocumentViewerCreateOptions(); // We are not going to use elements mode in this example createOptions.viewCreateOptions.useElements = false ; createOptions.thumbnailsCreateOptions.useElements = false ; // Set thumbnailsContainer createOptions.thumbnailsContainer = document.getElementById( "thumbnailsDiv" ); // Set viewContainer createOptions.viewContainer = document.getElementById( "documentViewerDiv" ); // Create the document viewer this ._documentViewer = lt.Documents.UI.DocumentViewerFactory.createDocumentViewer(createOptions); this ._documentViewer.view.preferredItemType = lt.Documents.UI.DocumentViewerItemType.image; var _this = this ; //Load an Excel document var url = "http://demo.leadtools.com/images/pdf/Book1.xlsx" ; lt.Documents.DocumentFactory.loadFromUri(url, null ) .done( function (document) { // Set the document in the viewer _this._documentViewer.setDocument(document); }) .fail( function (jqXHR, statusText, errorThrown) { alert( "Error loading document: " + errorThrown) }); } More details can be found here: https://www.leadtools.com/help/leadtools/v19m/dh/javascript/doxui/documentviewer.html https://www.leadtools.com/help/leadtools/v19m/dh/javascript/to/displayingdocumentsleadtoolsjavascript.html

Rajkiran Swain · Answer

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