Creating API for Dumping Excel data to MYSQL using Spring Boot || Hindi

[@ammoj8164]

Hii I am from Nasik..I am working on live project and this video resolve my all issues .video was Mindblowing ..Thanks sir..keep helping Us.I have subscribed your channel..and thanks again.

[@praveenkumarm629]

It was of extreme help. No one has posted such detailed content. Thanks much! Worked too good for me.😃

[@PRATIK-v2l]

Hi, I am working in a project and tomorrow it will go in production. My manager asked me to implement this feature by today EOD. This video really helped me to match the deadline.

[@nishigandhabajare5356]

Sir thank you so much 🙂 i am very happy with this video because after watching this video I am totally understand how to import data to database from Excel ...... your teaching techniques is excellent sir...

[@saurabhmishra1732]

Sir video dekhne se pahle hi like kar diya 🌺💕 love u lot thanku🙏💖

[@unemployedcse3514]

this vedio internally includes many java concepts nice ❤

[@simliauddya4210]

Thanks to this video I understood this concept so well!!! The way to explain is really well ,this was a great help!!

[@satyendrapratapsingh4281]

Thank you so much. It was very helpful.

[@trivendrakumar4825]

Sir awesome video, i am From Chhattisgarh

[@ShravanMukkera-u3l]

learned a lot from ur videos bro thanks a lot

[@chiranjeevvats3039]

Nice video Durgesh bhai👌👌

[@FaithandFun-w6q]

Wonderful content friend 😍 Well done! Thank you for sharing.. 🙏

[@renishdhaduk]

Hi, I have this project related question. My program is same as this program but only difference is I have more than 100 columns in this. This way is perfect for storing value in database.

[@bhuvneshkumarsharma4826]

Thank you so much sir for this type of learning topics I am from Bareilly UP

[@MDJAHID-d7e9o]

Very Gelpful For me Thank you Sir

[@music_in_my_blood]

sir aap bta dijiye ki spring ke liye kis kis chiz ki jrurat hai

[@MDJAHID-d7e9o]

Very Helpful for me Thank you

[@ananysharma8483]

Thanks alot durgesh sir

[@genie_logicielle]

it's a very nice lesson❤ but it will be more than very nice if you make your video in English. You should create two versions one in your language and the other in the world language.

[@mrrishiraj88]

Great project... obviously! Because it's from your House. 👍

[@shubhamagarwal2998]

Awesome 🔥...plz try to make video SQL server and hikari instead of MySQL and jpa Thanks

[@ishikajain1556]

Hey Sir ! Your explanation is very nice but I am eclipse use and finding it difficult to do same in latter, So you please make a video with eclipse addressing the same problem.

[@mrrishiraj88]

I'm going to implement it soon! Thanks.

[@maheshrevaskar7658]

Sir ji, ye Intellij ka plugin kaunsa hai rang birangi ?? Nice tutorial

[@prashantpatil-wq1lt]

Thank you for the video

[@khajahussainmd1797]

this videos help lot Thanks lot

[@AdityaAwasthi-ye8vg]

This video really helped me.Can you write junit code for this video

[@dhirajkumarlll]

Nice Explanation

[@mohdshahban6261]

Excellent

[@danielmagar5196]

Wonderful... Fantastic.. Thanks a lot but can you also make a video on how to retrieve the same data in excel format?

[@amanpandey4550]

what about the edge case, when cell contains null values

[@muhammadhashim6177]

You can apply validation while reading excel.

[@EanasEanu]

thank u so much for this wonderful video. i hav eone doubt, whenever i upload new excel file it is replacing the existing data in DB. how to resolve that? pls assist

[@dhirajkumarlll]

Hey Buddy it is because you have an primary key in your entity class. If you want to add new records just add new product ID in the your input excel

[@hansrajdagar609]

Thank you so much sir🙂

[@niyazkhan164]

Super

[@foddiebyage9696]

Be continue

[@TechAndroJavaOfficial]

Happy diwali🕯 🌺❤❤🌹

[@kartikeytiwari3574]

thnx bhai

[@niketdubey115]

Thank You soo Much , But i am not able to get the 2nd part of this video sir please help me out .

[@dhirajkumarlll]

What exactly troubled you in the second part let me know?

[@VijayYadav-ij1bf]

when a column is blank or null in a row inputstream doesn't treat it as a column and ignore it so the data size of row decreases which results in conflicts

[@harithaharitha3081]

Thank you so much...

[@rohiniam4650]

i have followed your code with different dataset but not able to upload .xlsx file even though i enabled the external file read tab in postman setting, please help how to run the post request with .xlsx file.

[@sunnykosle8865]

Nice 👍

[@mohitrathore8466]

maja aa gaya sir

[@kanchanborse3316]

can we see excel file content on frontend using spring boot

[@rahul-sinha]

Sir if we want that everytime when we upload the new excel, its entries only get added with the previous uploaded entries as well, So that everytime when we upload new excel our previous records don't get delete from database. For this what changes we need to do sir in the code ? Please explain in your next video. -Thanks in advance

[@aayushigoyal8337]

Use patch or put instead of post

[@rahul-sinha]

@@aayushigoyal8337 Thanks buddy. By d way it's already resolved 👍

[@umangsontakke7480]

@@rahul-sinha How you resolved for appending the data into database without deleting previous data from database?

[@umangsontakke7480]

@@aayushigoyal8337 patch or put not working, any other solution to append excel data into database

[@shubhamarora7966]

Hello Sir, I am not able to find your basic java playlist. Please also help me to guide as I am new to your channel and bit confused, from where to start? Please help me, What should be sequence of learning (JDBC, Servelet, Spring, Hibernate...), If I am interested for backend Development / Java Development. Please help me.

[@infooussama9634]

thank you very halpful

[@huzaifaejaz]

Having an issue with my code while uploading an Excel file. The code isn't recognizing blank cells and is instead pulling data from adjacent cells, which is causing a bit of a data mess! Any suggestions or solutions would be greatly appreciated! Thanks in advance!

[@Ajeet-talk]

Happy Diwali 🔥🔥🔥🔥

[@aarjutripathi4160]

Sir tutorial on Kafka plz

[@sunnykosle8865]

Yes sir pls make videos on Kafka basic to advance

[@Ajeet-talk]

Nyc brother

[@omkarbhedodkar6962]

If i dont have postman then how can give path of excel file in url ?? Plz help

[@proxy5061]

how to write data into exel??? from END point

[@gopalwaghule6396]

in my code "data" is throwing NullPointerException // cause it did not getting file name dynamically and looking for file name as data.xsls ???? why

[@dikshaaj3605]

sir if I have 200 column name of table then how will do?

[@vaibhavasharma2774]

Database to excel ka bhi banao sir

[@shubhangideore3006]

I only need to create only one button using which the above program is invoked and excel file should be created and which is downloaded file any solution for that.

[@pritigupta4019]

How to validate these excel fields

[@dhirajkumarlll]

Code is working good but still I am getting "Failed to perform cleanup of multipart items" Exception. Although the fix is the upgradation of the spring version but I could not find the reason why.

[@chetanmustoor282]

Cannot invoke "org.apache.poi.xssf.usermodel.XSSFSheet.iterator()" because "sheet" is null what to do for this

[@sarankumarv4874]

Give sheet name present in the Excel document

[@medoune89]

Hello Sir, how can i add ExcelHelper when i'm using jhipster ?

[@AjitShekhawatTechTalk]

Hello sir, I'm getting some issue..., DB table mai excel ki last row he add ho rahi hai sirf Or jab ki maine list ki length bhi check karke dekh li.. Vo 15 he hai Mgr Jpa repository method save se last row he save horhi h Mujhe kuch bhi smjh nahi aarha aisa kyu horaha h Pls help me....

[@shutter_buggies]

Yh. Project maine banaya h , but not api using jdbc and excel (csv)

[@070-cse-pavankumar.s.m2]

how to put content type in if else

[@shwetasm7607]

I am trying the same code but the database is postgresql but data is not inserted into the table

[@apoorvarai5002]

how to map if one of the column in the excel sheet contains foreign key of another table

[@dhirajkumarlll]

Hey Check with Hibernate mapping where you can map in the entity class with the help of annotations like @OneToOne, @OneToMany and @ManyToMany and so on. After mapping keep the helper logic same as shown in the video.

[@praneshvk18]

How to add additional excel sheets data to MySql workbench? can you explain or can anyone share link or source code

[@streetfootball2651]

Muje XL ko db mai upload nahi karna bas usko read karna hai in springboot I tried your method but it is giving me error stating that "Package should contain content type part [M1.13]"

[@adityapratapsingh4873]

Sir how to convert http request to https request and how to create certificate for https for securing own website in spring boot please make one tutorial 🙏🙏🙏

[@girishsinghrathore6134]

Durgesh sir mera table nahi ban rha hai postgres use kar rha hu help me

[@chetanmustoor282]

sir im getting this error what to do == Required request part 'file' is not present]

[@vkvlogs413]

How can we create 2 sheet

[@preetisharma7602]

Sir quality shai ni dikahti vedio me. And show hota hai quality unavaible

[@shraygupta5671]

How to send this api request using angular

[@gouravsoni1700]

If one of the cell is empty then it is not working

[@manitejavanam5047]

how to download products .xlxs file plss help

[@yashalwar]

Sir this is not working. It is taking sheet as null. Please Help sir!

[@dikshaaj3605]

agr mere paas 100 column name kaa excell sheet h..or jo m entity class bnaungi to 100 column name bnaana hogaa kyaa....anybody help me ??

[@crackossgaming]

How to Export db data to excel

[@skobedullah3842]

sir if no of columns increases or decreases or data-types changes in our excel sheet is there any way to get that column and save it into DB dynamically... or we have to create entity class for each sheet of different row and data-types and mapped it every time...

[@ammoj8164]

during set data you can set in any entity class..so its your logic how you want to set data...and then apply save method on each entity class.

[@themrambusher]

yar excel format tho .xls bhe hota ha but is code se wo invalid bata raha ha.. excel file ke teen format hote hana xls, xlsx, xlsm so why you have choosen code for only one format .xlsx

[@manitrends7996]

What shortcut u have used for return "XSSFWORKBOOK workbook" as you have just write the method @21:55 . please help

[@LearnCodeWithDurgesh]

Alt + enter

[@manitrends7996]

@@LearnCodeWithDurgesh thanks a lot

[@حامدنیکبخت-ن5ع]

please add subtitle

[@sahil968rajpal]

Mera localdate wla data ni jara🙂

[@ma....5307]

Please provide PDF Generation thanks.

[@pshobha7783]

Data truncation: Data too long for column 'team' at row 1. I am getting error like this. How can i solve this?

[@ammoj8164]

please increase your size of column for varchar..and issue will be resolve.

[@dhirajkumarlll]

@@ammoj8164 I Agree

[@manidixit6713]

Why r u using wrapper class like Integer Or Double instead of primitive data type like int, double in your entity class?

[@mayankshivhare4843]

It will not affect too much but It is always good practice to follow oops concept which is based on class and objects. also in some cases Java does not allow primitive types to be used like in collections. although because of autoboxing concept we feel it is using primitives as well.

[@akshattiwari801]

what if we dont know the name of the sheet then what???

[@sarankumarv4874]

Yes we can give. By using the method workbook.getSheetName

[@shahidanwar6254]

somebody plz help me....how to make a reporting project in springboot using dynamodb.

[@bhuvaneshwarib72]

I saw this video,I don't know hindi,I have have doubt on helper class, in helper class contenttype. Equals after you write like applicationvnd.openxmlformats-officedocument like this could you explain this in English

[@tempork9824]

what is the max limit it can handle?

[@muhammadhashim6177]

it is not even able to handle 1000 rows efficiently, there are another ways to read excel.

[@gouravsoni1700]

Cannot invoke "org.apache.poi.xssf.usermodel.XSSFSheet.iterator()" because "sheet" is null at com.api.helper.Helper.convertExcelToListOfProduct(Helper.java:45) Please help

[@harikeshsingh93]

have you solved that

[@vedantzanjad]

@@harikeshsingh93 tell me the solution i am facing the same

[@yashalwar]

Same issue I am getting

[@yashalwar]

@@vedantzanjad Any solution ?

[@yashalwar]

@@harikeshsingh93 Any Solution?

[@kunying4037]

Thank you very much sir

[@subhranildutta1712]

getting error like java.lang.IlleagalStateException cant get a string value from a numeric cell............what should I do?