How To Read and Write Excel data in java using Apache POI

[@manavurumanaprapancham7669]

Thanks for the video, I hope I don't forget in future

[@ibrexg]

Thanks for your effort. It would be nice to have a related git repository so one can try to build the project and check if it works and report bugs.

[@rafatkinvadanti]

when i have downloaded zip file from link you have wrote , i did not find any jar files to inserted inside project !! why ? how did you do that ?

[@ankitshukla5800]

Well explained!!

[@mohammedafkir8713]

Very useful video.

[@Abdullah_11110]

but why adding music 😢

[@protechbeach]

Thank you for your feedback. :)

[@protechbeach]

Thank you for your feedback. :) . considered in the next post!

[@SuryareddyKANCHAM]

Thank you sir ,for your clear explanation and could you please do video on real time application on same read and write Excel

[@SineQuaNon1]

That is a great video. Thanks.

[@protechbeach]

You are welcome! Thanks for your feedback

[@akshaymetkari]

Very Nice Explanation. how do i write the data in next row if data is already present in that row

[@jordimassamuna3009]

I liked the video, please can you make this kind of video using Swing. Please.

[@singiri697]

Can you please share the github repository if you have please

[@sumanthpai6100]

here row and coloumn number each time you are specifying , how to read and write to dynamic row and coloumn number , this is what is required in real time projects

[@aashutoshojha3668]

Hello sir Can share the source code And which editor you use in the video

[@shinsu2172]

thanks

[@dremuafework1893]

i couldn't import after i added the files to lib folder please help,am using vs code.

[@vaibhavdemewar97]

Hello i am not getting binary distribution option but I am getting source distribution but when i download it after that I am not getting jar files in that folder so what I can do now

[@tusharkumar66]

Same bro! How to solve this problem?

[@faxi3734]

same

[@NganNguyen-qd4oo]

u could scroll down to Release Archive section -> Binary Artifacts -> find poi-bin-5.2.3-20220909.tgz. That's the version that has jar files

[@vaibhavdemewar97]

@@NganNguyen-qd4oo Actually I am not getting the path can please share if possible

[@protechbeach]

www.apache.org/dyn/closer.lua/poi/release/src/poi-src-5.2.3-20220909.zip Can you please check this? It works

[@sqb8980]

Hi if we want to do this using maven what dependencies do i add

[@protechbeach]

org.apache.poi poi 5.2.3

[@errollaabhishek315]

The background music is disturbing.

[@protechbeach]

Thanks for your feedback. will consider your feedback in next videos.

[@_xtemper_]

"ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console..." even if the file is closed

[@GokulGajapathi]

3:45

[@eutotiltadocara]

In my code it always goes to cath If in my code cath " e.printStackTrace(); " it shows the error " Cannot get a STRING value from a NUMERIC cell " and if I change the " e.printStackTrace(); " to " e.getCause().printStackTrace(); " it shows the error " Cannot invoke "java.lang.Throwable.printStackTrace()" because the return value of "java.lang.Exception.getCause()" is null " is it the version of something that is wrong?

[@protechbeach]

Hi Joab, Issue in your try block code. Can you ping your try block code here or you can mail me

[@eutotiltadocara]

@@protechbeach Thanks for answering me '-' , I'll leave the code below, but it's practically the same as the video try { FileInputStream file = new FileInputStream("E:\\tiltado.xlsx"); Workbook wb = WorkbookFactory.create(file); Sheet s = wb.getSheet(SheetName); Row r = s.getRow(RowNum); Cell c = r.getCell(ColumNum); data = c.getStringCellValue(); }catch (Exception e) { System.out.println("LerExcel deu catch amigão"); //e.printStackTrace(); e.getCause().printStackTrace(); }

[@protechbeach]

@@eutotiltadocara Solution 1: Open excel sheet >> Ctrl+a >> rightclick >> Formate cells >> Under number tab select 'Text' >> Click on OK . run script again. it will work Solution 2: replace, data = c.getStringCellValue(); this line with below two line DataFormatter formatter = new DataFormatter(); data= formatter.formatCellValue(c.getStringCellValue());

[@eutotiltadocara]

​@@protechbeach Thanks for you time '-' I managed using your second option, but I had to take off the ' getStringCellValue() ' Thanks Obrigado my code worked and it looked like this DataFormatter formatter = new DataFormatter(); data= formatter.formatCellValue(c);

[@zstar8397]

Hey hope you are doing alright just I wanna say that GOD loved the world so much he sent his only begotten son Jesus to die a brutal death for us so that we can have eternal life and we can all accept this amazing gift this by simply trusting in Jesus, confessing that GOD raised him from the dead, turning away from your sins and forming a relationship with GOD.