How to Convert Excel file into JSON by using Angular | JavaScript | JSON

[@GauravSharma-gr4bs]

Thanks for sharing the technique, it's easy to understand and descriptive.

[@Maverick_x-e1j]

woah amazing friend, this works for me 100%, I think just add how to drop a file(because for me didn't work or maybe it's just adding something in the html) and it will be the most complete video about this topic thanks

[@azamnawaz5836]

Nicely Done Bro

[@kalaivanik8076]

Will it work for multiple sheets as well ?

[@MrChakri80]

The expiry date is not showing the correct format. How can we resolve this date and time format issue?

[@vamshichekka2892]

Can you please tell me how to access the JSON object out of that method. Even though I assign it to global variable, but it is not accessible after the method.. please help me here

[@BillMoman]

Do you know if there is a way to convert the Json to a typed object. I tried sheet_to_json, but the json is still just an object and it doesn't know that it is MyModel. It knows it from an intellisense standpoint because typescript is loosely coupled. However, when I try to validate the model using class-validator, it doesn't validate anything because it doesn't know the actual model to look at. I'm trying to do it as generically as possible so I can reuse the code. In other words, I don't want to use Object.assign(MyModel, jsonObject) in order to get it to work because I need MyModel to be generic.

[@soumyajeetbai]

readAsBinaryString is deprecated ⚠️ please tell what can be the alternative to use any method

[@JAVIERALONSOROJASBUTRON]

buscaste alguna solucion? searched you a alternative?

[@kiranbegari811]

can you share the how to convert the excel to json data with using the react please tel me

[@manojradharapu4688]

How to validate the values after reading? Suppose in your excel file you are having InsVal - its value should be number but what if user enter a-z characters ? How to handle

[@alradiation5417]

why u dont have any error in "let binaryData = event.target.result" that the object is possibly null

[@vishnuvirat2501]

Bro How to use in Require js. In Require Js it's showing error.

[@LeandroTercette]

new subscriber here !

[@nandagopalsutradhar5200]

excellent job

[@JohnPico2020]

gracias, muy buen video :)

[@sonidosdetranquilidad]

Thank you

[@randallerasmus]

Nice job man, you have another subscriber! Would you mind showing how to generate the converted json file to folder on the project and not in the dom

[@MYPECOV4Media]

Hi bro u can share ur project plz? nice tutorial

[@cirquolus]

Amazing

[@nandagopalsutradhar5200]

100% working...

[@CodePro-Jayanth]

Thanks and pls subscribe to my channel

[@vinithkumar2319]

Thanks a ton ;

[@aguadepueblaparatodos862]

Like