SpringBoot Upload Excel and read as JSON

Uses Apache POI
Upload a Excel file and read it as JSON

[mickeyjava]

Responses may be delayed. Thanks for your support.

[leonardonam]

Thanks Mickey! You’ve saved my morning! It was very helpful your knowledge

[fishandfisherman]

Mickey, Oh my God, your video is so awesome, I was able to develop a complete processing system from Excel, Thank you and Keep up the good work!

[amarthyaseshu]

CSV & Excel series both helpful. Thanks for sharing!

[soumyakumarsahoo]

Hey sharan i was just searching for it. Though I didn't follow it completely I heard your voice and some old memories came up. The way you typing java 8 code I am motivated now to read it...

[Engineerschoicetutor]

In my case, the row datas are not well mapped..Means not properly mapped with the key..Why it is happening.

[poojamishra]

How can we do if values are combination of int, string and list in excel sheet?

[adamabdullah]

i have error like this i use apache poi version 4.1.1 . any suggestion ?

[ShahidKhan-tcpu]

Hi @Mickey, How to handle a big excel file around 100MB?
application is getting hanged for such case..
Please suggest

[vaibhavvishal]

waht are the version and names of the library downloaded in the start

[malaouitaoufik]

It's possible to show alerte if you have duplicate row id database

[ashishchoksi]

Is it possible to have ORM kind of thing with excel, like we do in Repository.
can we write class like :

@ExcelSheet("sheet-name")
class Emp {

@Cell("id")
int id;

@Cell("empName")
String empName;

}

[TheAyushmaan]

Current request is not a multipart request

facing this error.. please help

[pushp]

i think we need to remove the tempfile from server once data is uploaded. otherwise it will create huge number of files on multiple upload

[shodhikagupta]

Hi Mickey, I'm getting this compilation error while returning from service class.

Cannot infer type argument(s) for <R> map(Function<? super T, ? extends R>)

Any idea what is this? I've written the exact code from your repo but still getting this.. Please help!

[ajjai]

How to learn Java 8 implementation. The way you were using. 👌

[dusmantakumarmahanta]

Awesome video
How read the save json and convert it to List ??

[omniversal]

Hi. How do I write an object to a text file and then have a method which is able to download it in a Spring Boot REST api?

[manikantatangudu]

Hey Mickey, is something missing in code ? i tried to execute the code as is and am getting "Cannot get a NUMERIC value from a STRING cell" error with same sample file

[prasanthsainandyala]

Hi Mickey, how to deal with empty cells in excel here?