REACT – Read Excel using Sheet JS
Hey guys!! if you learn something new or my video helps with your project. you can now buy me a coffee. if(cup.coffee=EMPTY) { developer.brain=OFF}
Thank you…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Thank you. All the tutorials were not working. I think i was not importing the XLSX correctly
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.
How to make header bold in excel using xlsx ?Thank you?
Only your approach worked for me. Thanks for sharing this video.
Lifesaver! Thank You. It worked without any hiccups.
may i know how do i link my pictures from excelsheet in react
excelent!!! question, to do the reverse process and download it, how would it be done?
Thanks for the video, that was perfect to me!
Thank you very much! Great video, it worked!
Thanks brother, Great work!!
Bro how can exclude the header in the JSON array if yes how?
Thank you❤️❤️
great~
Found it useful check it out
https://youtu.be/d4kt_L5ybXo
Is the xls sheet available that you used for this project?
Thank you! It really helped me 🙂
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.
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'});"
Thanks that's really helpful
nice video bro!!! can you make a video on how to send this csv to mongodb with the help of node
tks bro
Do you know how to convert this code to async/await ?
If we have url of xls.
thank you
Nice video. However, package.json is not having the xlsx dependency.
How to do the same using components and props
data is not for the second column showing error in console as "Each child in a list should have a unique "key" prop '
can you please tell me how to send this data to API.
Thanks that's really helpful
thanks for the video. really helpfull.
It is very useful, thank you!
Thanks a lot 🙂
@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.
nice
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
you have solved my project 🙂 thank you!