REACT - Read Excel using Sheet JS

[@niyongaboeric]

Only your approach worked for me. Thanks for sharing this video.

[@Samlama8848]

No problem

[@niteshlimbu5745]

Lifesaver! Thank You. It worked without any hiccups.

[@ilyasrodi1551]

Thank You Sam !!!! FANTASTIC TUTO !!!!!

[@anwarahmedsiddiqui466]

data is not for the second column showing error in console as "Each child in a list should have a unique "key" prop '

[@lighttigerxiv]

Thank you. All the tutorials were not working. I think i was not importing the XLSX correctly

[@ErnestoBalanzar]

you have solved my project :) thank you!

[@BHVampireLF]

It worked like charm

[@bhanusharma2482]

Thanks brother, Great work!!

[@fernandofincatti5961]

It worked for me! Nice tutorial!

[@anishachoudhury_]

may i know how do i link my pictures from excelsheet in react

[@ShahbazKhan-zl2zt]

can you please tell me how to send this data to API.

[@andresdavid3754]

Thank you very much! Great video, it worked!

[@RavikiranGS]

How to make header bold in excel using xlsx ?Thank you?

[@jhoncar]

excelent!!! question, to do the reverse process and download it, how would it be done?

[@blendaguedes]

Thank you! It really helped me :)

[@kogantieswar5240]

@Sama Lama , Hi first of all thanks for your valuable work. What if i have two or more sheets in excel and i need to store all three sheets data. Thanks.

[@kalyanperla9767]

Thank you❤️❤️

[@ChronologicalLogic]

hmm tried this, and the workSheet is created correctly (in debugger view), but the XLSX.utils.sheet_to_json() doesn't seem to be able to parse the workSheet for whatever reason - just returns an empty array :/ I can create my own parser, but tbh, I would want to avoid that

[@veronicabarrientos2893]

Thanks for the video, that was perfect to me!

[@McTrachos]

Hi, sorry about the question but, i replicate your code and your excel file in my code. but if I try to use it I have this error "Error: Unsupported file undefined ", do you know why? is from this line "const wb = XLSX.read(bufferArray, {type:'buffer'});"

[@Ops_pops]

iam gettting an error as : Module not found: Error: Cannot find file: 'xlsx.mjs' does not match the corresponding name on disk: './node_modules/XLSX/xlsx'. anyone can help me with this.Thank you in advance.

[@garikmelqonyan9130]

Thank you man. It really got the job done!

[@JayCutler22]

Do you know how to convert this code to async/await ?

[@trailslug893]

Is the xls sheet available that you used for this project?

[@diEGo41657]

Thank you brother, you helped me a lot :D

[@anwarahmedsiddiqui466]

How to do the same using components and props

[@MohamedNazeem98]

great video and explanation thanks alot dude

[@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 and apply same on my table? Thanks for the video.

[@ShahbazKhan-zl2zt]

thanks for the video. really helpfull.

[@umairmuhammadabbas3929]

Thanks that's really helpful

[@a1034a]

great~

[@erkany6753]

It is very useful, thank you!

[@chientauc1223]

tks bro

[@bhojakrahul5880]

If we have url of xls.

[@sauravsatpathy5407]

Bro how can exclude the header in the JSON array if yes how?

[@Samlama8848]

use shift on an array

[@rideonwheels7028]

thank you

[@errinwright]

Can this be used to upload Excel file data to firebase collection database?? You're the 🐐 🐐 🐐

[@sweat_gamer5540]

Nice video. However, package.json is not having the xlsx dependency.

[@muzamilhussain2550]

your video is very helpful for me but I have got one error warning while running my project and I'll able to display only one record. This error warning will show in console.log "Warning: validateDOMNesting(...): Text nodes cannot appear as a child of ". So, please help me what I can do right now. Thanks

[@Samlama8848]

Hello, I have added GIT repo. Please have look in description. Thanks

[@muzamilhussain2550]

@@Samlama8848 Ok Thanks

[@hajramohammadshahid4893]

How can I read an excel sheet using its url ?? (Google Spreadsheets) Sir please let me know , it's urgent. Thank you

[@robinalexander19950]

nice video bro!!! can you make a video on how to send this csv to mongodb with the help of node

[@Samlama8848]

Sure!! Thanks for suggestion

[@digvijaysingh8376]

ITs working thanksss

[@muzamilhussain2550]

Sorry to disturb you I have one more question. We are able to define the range of columns and rows in reactjs or not??? I mean A1: A6 columns data are shown in this column like so...

[@Samlama8848]

I think easy way to get data from A1:A6 is read the excel files and read response between A1:A6 which is 6 length array ignore rest array or you can check Sheetjs for documentation.

[@rroossyyiidd]

Thanks a lot :)

[@swaniketchowdhury]

Great video, thank you. BTW how can I also get the headers?

[@rムel]

@Swaniket, please did you later figure it out? help I'm look for the same solution

[@bhanusharma2482]

@@rムel did you find out?

[@rムel]

@@bhanusharma2482 ahaha no, I later had to use papaParse, it automatically makes the first row the headers xD

[@meghanaorugunta976]

Thanks for the video. What if I don't want to display the table headers till the excel file is loaded ? To further explain, could you please tell how to display the whole table only after the data is loaded ?

[@Samlama8848]

you can use if and else on table and check if data is available or not. thanks

[@UmairAhmad27]

You can use the ternary operator. items.length > 0 &&

[@SushilKhekare]

want to read directly from folder without any propmt.

[@okumuoriaro4994]

Did you find a way? Been searching for the exact same thing

[@mamadoualphabarry4538]

nice

[@vutiendung1100]

Thanks that's really helpful