Apache POI Tutorial Part8 - How To Read Data from Database and Write into Excel #ApachePOI

Super

thank you. it helped :)

Hiii sir, im facing one error, please help me with this...
Exception in thread "main" java.lang.NullPointerException: Cannot invoke "org.apache.poi.xssf.usermodel.XSSFRow.getCell(int)" because the return value of "org.apache.poi.xssf.usermodel.XSSFSheet.getRow(int)" is null

Nice explanation sir, I have got work to fetch data from multiple tables into excel using Java. Can you please help me out sir. It will be really grateful of you. How can I reach you for my doubts?

Awesome 👌👌👌👌

very simple and very helpful..................👌👌👌👍👍👍

I need to iterate headers in excel can anyone suggest

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/collections4/ListValuedMap
at net.javaguides.login.database.DatabaseToExcel.main(DatabaseToExcel.java:22)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections4.ListValuedMap
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 1 more

ie.error in "XSSFWorkbook workbook = new XSSFWorkbook();"

Please let me know how to resolve this exception.

hello sir, please help me out
can we get same output with this approach
for(int i=1; i<=NumOfRow;i++) {
row = sheet.createRow(i);

for(int k=0; rs1.next() && k<NumOfCol;k++) {

row.createCell(k).setCellValue(rs1.getString(k+1));
}
}

Thank you sir.. My all doubts are cleared. I've searched number of times for this particular result & finally my wait is over. You are amazing.. Keep it up....

Sir how to fetch multiple table record to excel sheet

Hello sir,
I want get the data from two tables having same schema compare two tables if the values are different in any of the column we need to push the data into excel

thank you sir

Thank you

Thnk you so much sir...your videos r so informative

Thank you for the vedio pavan sir

Sir pls make series of selenium with C# and related frameworks as well pls pls. Thanks 😊

Sir pls make series of selenium with C# and related frameworks as well pls pls. Thanks 😊

Sir pls make series of selenium with C# and related frameworks as well pls pls. Thanks 😊

Sir pls make series of selenium with C# and related frameworks as well pls pls. Thanks 😊