REACT - Read & Parse Excel Sheets with SheetJS

Learn to use ReactJS to read excel sheets with the SheetJS package.
#ReactJS #SheetJS #ExcelReact

0:00 Intro
0:30 Create React App
1:14 Add Components
1:39 Add React-Router-Dom
2:50 Build Parse Excel Base Components
3:56 Install SheetJS and Add Sample Code
5:34 Add Component for Showing Filename on Upload
6:49 Parse Excel to JSON
8:35 Read Only first 'N' rows from sheetjs to JSON Object
9:40 Read As Array
10:40 Extract Headers from Excel sheet and display in Dropdown-list

[PreVlad]

Ive surched soooo long for this...man 2 days >.>

[rajmayekar]

thank you for the video was very helpful in developing my project

[andreihoffmannferreira]

Thanks for the video, it was great and very explanatory.

[amosgikunda]

I love your videos. Can you create a video on how to compare multiple sheets for differences (highlight differences). Thanks.

[niranjanbhamepatil]

Hey I have one question here. If my excel file has some styling like font weight bold and background color so can I read that properties too? Thanks for the video.

[kalki_onwheels]

Can you make a video on how to read multiple sheets from same workbook and display the data in table ?

[Officialsinghsolanki]

hey man. good stuff. Just that I was trying the same but I keep getting the undefined (reading 'book_new') error, do you maybe know how to resolve that?

[TejasMadhukarShukla]

can you help for excel to nested json create

[simonmoon]

Thanks for the video! It was very helpful! I hope I will figure out the rest by myself. Just 1 question pls - how can i add excel file in the project already so i dont have to upload it every time? If i move excel file to the React project folder - how can i make react get the data from there? Thanks!

[likoindrahartawan]

Can you do export/download to .xlxs with Table ? Thanks