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

Same bro! How to solve this problem?

same

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

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

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

but why adding music 😢

Thank you for your feedback. :)

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

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

@@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(); }

@@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());

​@@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);

org.apache.poi poi 5.2.3

You are welcome! Thanks for your feedback

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