Read and validate data of Excel file in Angular 2+

Question

Hi all, I have and upload file component in angular 6. I am using xlsx for data reading and converting to json but do not have idea about how to validate the data i am uploading according to my requirement.

Maen Badwan · Answer

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( "
" )); }); } 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 Ranwa · Answer

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