Read and validate data of Excel file in Angular 2+

You can upload and view Excel files using LEADTOOLS HTML5/JS Document Viewer control. You can check an online demo here:
https://demo.leadtools.com/JavaScript/DocumentViewer/

For example, the following JS code shows how you can load and view an Excel file using LEADTOOLS HTML5/JavaScript Document Viewer control:

lt.Document.DocumentFactory.serviceHost = "http://localhost:20000"; // or wherever your host is
lt.Document.DocumentFactory.servicePath = ""; // the path to the root of the service, which is nothing for this example lt.Document.DocumentFactory.serviceApiPath = "api"; // Routing occurs at "/api", unless you change the routing in the DocumentsService
var url = "https://AddressOfYourWebSite.com/files/MyFile.xls";
lt.Document.DocumentFactory.loadFromUri(url, null)
.done((document) => {
documentViewer.setDocument(document);
})
.fail((jqXHR, statusText, errorThrown) => {
// Get more information from LEADTOOLS
var serviceError = lt.Document.ServiceError.parseError(jqXHR, statusText, errorThrown);
lt.LTHelper.log(serviceError);
// Show an alert about what the issue is
var lines = [];
lines.push("Document Viewer Error:");
lines.push(serviceError.message);
lines.push(serviceError.detail);
lines.push("See console for details.")
alert(lines.join("\n"));
});
}

To use the document viewer control with Angular2 application, check the following thread:
https://www.leadtools.com/support/forum/posts/t12485-How-To--Use-the-Document-Viewer-in-an-Angular2-Application

Note that I am not sure exactly what do you mean by "validate the data". Do you mean you want to get specific data from the Excel file after loading and viewing it?

2 Replies

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

Maen Badwan7y ago
You can upload and view Excel files using LEADTOOLS HTML5/JS Document Viewer control. You can check an online demo here:
https://demo.leadtools.com/JavaScript/DocumentViewer/

For example, the following JS code shows how you can load and view an Excel file using LEADTOOLS HTML5/JavaScript Document Viewer control:
lt.Document.DocumentFactory.serviceHost = "http://localhost:20000"; // or wherever your host is
lt.Document.DocumentFactory.servicePath = ""; // the path to the root of the service, which is nothing for this example   lt.Document.DocumentFactory.serviceApiPath = "api"; // Routing occurs at "/api", unless you change the routing in the DocumentsService

var url = "https://AddressOfYourWebSite.com/files/MyFile.xls";

lt.Document.DocumentFactory.loadFromUri(url, null)
.done((document) => {
documentViewer.setDocument(document);
})
.fail((jqXHR, statusText, errorThrown) => {
// Get more information from LEADTOOLS
var serviceError = lt.Document.ServiceError.parseError(jqXHR, statusText, errorThrown);
lt.LTHelper.log(serviceError);
// Show an alert about what the issue is
var lines = [];
lines.push("Document Viewer Error:");
lines.push(serviceError.message);
lines.push(serviceError.detail);
lines.push("See console for details.")
alert(lines.join("\n"));
});
}
To use the document viewer control with Angular2 application, check the following thread:
https://www.leadtools.com/support/forum/posts/t12485-How-To--Use-the-Document-Viewer-in-an-Angular2-Application

Note that I am not sure exactly what do you mean by "validate the data". Do you mean you want to get specific data from the Excel file after loading and viewing it?
Sanwar Ranwa8y ago
Hello

Please check these Links

https://stackoverflow.com/questions/47151035/angular-4-how-to-read-data-from-excel

https://stackoverflow.com/questions/47151035/angular-4-how-to-read-data-from-excel?noredirect=1&lq=1

https://www.grapecity.com/en/blogs/flexgrid-client-side-importingexporting

https://github.com/angular/angular/issues/14083