Read & write excel sheet data in Java using Apache POI

[@qavbox]

Latest tutorial on the excel read write, fetch data based on column header, maven project refer kzbin.info/www/bejne/o6HXpKuVpZqfarc

[@edluigi_954]

Thank you so much, man. Your code really helped me out!

[@padmadevan3119]

Thank you so much. It helped me.

[@vinodpimple946]

This code is not working for xls file format, can you please help?

[@pradeepjadhav9035]

After reading one excel sheet ,how to write same data in another excel sheet?

[@panendran8920]

Can you explain how to convert large text file to excel file

[@asheeshkumartripathi414]

How to handle when we have null values in between excel cells

[@trowlmusic5969]

Doesn't work for Poi 4.0, get errors when trying to create a workbook. Need additional JARs

[@qavbox]

refer to this latest tutorial which uses maven project, no need of manual jar files, kzbin.info/www/bejne/o6HXpKuVpZqfarc

[@fathi7946]

Thanks soo much.it helped me.lot

[@mrcoin5305]

I executed same code but getting errors with file not found

[@qavbox]

Can you check if you have provided proper path

[@qavbox]

You can refer to this one as well kzbin.info/www/bejne/o6HXpKuVpZqfarc

[@JudenB2]

did this work for the radio/checkboxbutton in Excel ?

[@dtrilochandora6158]

Thanks for sharing video ...I need one help ,how to remove rows and columns from the excel sheet ? pls help me

[@tarluck]

Hi , first i'll thank you for your video, i tried to import apache hssfworkbook etc... i added the my project many JAR's file POI_...... but unfortunately , the import didin't succed, i use jdev 11g , please guide me to the solution, wich Jar do i use for this version of jdev thanks

[@qavbox]

Hello, can you follow this to get the excel poi library using maven project instead importing the jar files manually kzbin.info/www/bejne/mavUoZ-reqmoqs0

[@qavbox]

You can refer this tutorial for the latest version of excel poi kzbin.info/www/bejne/o6HXpKuVpZqfarc

[@tarluck]

@@qavbox thanks , i'll try

[@joshuvar4540]

tq bhai

[@lokeshdohare4872]

I 'm getting noclassdeffounderror.. What to do? Need urgent solution...

[@qavbox]

There could be many reasons of this error, make sure u have one main method or testng.xml includes proper testng class to run, still getting error? then post ur code block

[@lokeshdohare4872]

qavbox Here is my code... package collegepredictor; import java.io.FileInputStream; import java.io.FileOutputStream; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; public class CollegePredictor { private static Workbook wb; private static Sheet sh; private static FileInputStream fis; private static FileOutputStream fos; private static Row row; private static Cell cell; public static void main(String[] args) throws Exception { fis = new FileInputStream("C:\\Users\\Lokesh\\Desktop\\College Predictor\\cut off marks.xlsx"); wb = WorkbookFactory.create(fis); sh = wb.getSheet("General"); int noOfRows = sh.getLastRowNum(); System.out.println(noOfRows); for(int i=1;i

[@The_Sanatan_Supreme]

@@lokeshdohare4872 did you solve the error?

[@lokeshdohare4872]

Dipendra Sharma no I didn't

[@ajtiny71]

I also get this error..

[@1996Pinocchio]

Can you do a video on POI version 4.0? :)

[@jefferyira1917]

A tip: watch series on InstaFlixxer. Been using them for watching lots of of movies during the lockdown.

[@jazielaugustine8139]

@Jeffery Ira Yea, I've been using instaflixxer for since november myself =)

[@aldenaldo5472]

@Jeffery Ira Definitely, I've been using InstaFlixxer for years myself :)

[@princeronald162]

@Jeffery Ira Definitely, I've been watching on InstaFlixxer for since december myself :D

[@niketanmishra4410]

I saved my project in c drive and getting error for file not found exception

[@qavbox]

Can you try creating a folder under c drive and then try, sometimes putting under c drive may not get direct access

[@LalitMetkarofficial]

can we get the formatted value example : if you have some bold text in the cell then what to do in case of that to get the formatted style???

[@qavbox]

You just need to call Worksheet.getrow(0).getcell(0).getStringCellValue()

[@theanonymous1449]

Thank you so much for this osam video

[@letstalk241]

nothing is visible..

[@yashaswiniSmile]

Thank you :)

[@saregama5]

your tutorial doesn't makes sense to me as I have 20 rows and 20 columns to deal with. Take cell count too and apply 2 For loop.

[@akhilahakeem27]

Hello,could you please me the "for loop" for it...it's urgent .Thanks in advance :)

[@ajtiny71]

Please help me with the package..

[@qavbox]

Please elaborate what assistance you need with package?

[@ajtiny71]

Do I need to import something for the package? Or I just need to name one?

[@qavbox]

@@ajtiny71 refer here on how to get the package qavalidation.com/2015/03/selenium-excel-read-and-write-apachepoi.html/

[@zulemairiarte2136]

it works for android?

[@qavbox]

Zulema Iriarte This is applicable for any project if u r using Java.

[@zulemairiarte2136]

i mean, somehow Android Studio use Java, but idk if this can work for android, sure Android Studio have other methods than java no, just asking..