Loading

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

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

Nimish Saxena

Nimish Saxena

9y878Learn iOS Programming

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

3 Replies

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

Maen Badwan9y ago
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
0
Ibrahim Siddique9y ago
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);
}
}

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