(Java Class 10 Live Class Recording): Excel POI API + Maven Setup Secrets Selenium Tester Must Know

Welcome to Class 10 of our Selenium with Java Full Course! In this live recording, we cover two game-changing topics - reading Excel files using POI API and complete Maven setup from scratch. These are essential skills for building real-world automation frameworks. 🎓 What You'll Learn: ✅ What is an API and why it matters in automation ✅ Reading data from Excel file using POI API ✅ Why we need Maven for automation projects ✅ What is Maven Repository and how it works ✅ Understanding POM.xml structure and dependencies ✅ How to install Maven into Eclipse IDE ✅ How to give Maven Path in Environment variables ✅ Check that Maven is installed in system or not ✅ Make first Maven project from command prompt ✅ Run first Maven project successfully Timestamps: 00:01 - Introduction to POI API for Excel data reading 01:12 - What is an API? Explanation with example 04:13 - Downloading and including POI API jar files 08:32 - Exploring POI API features for Excel 14:26 - Reading Excel file path and setup in Java 16:10 - Using XLReader to get row and column count 18:46 - Reading Excel cell data with row and column indexes 23:46 - Looping through Excel rows and columns to print data 31:20 - Correcting row and column indexing for Excel data 32:15 - Introduction to Maven and its purpose 34:46 - Using pom.xml to manage dependencies in Maven 36:44 - Searching and adding Selenium dependency in Maven 37:40 - Structure and content of pom.xml explained 39:04 - Downloading and setting up Maven on Windows 41:48 - Configuring environment variables for Maven 43:11 - Adding Maven bin folder to system PATH 44:33 - Verifying Maven installation via command prompt 45:12 - Creating Maven project using command line 47:34 - Selecting archetype version for Maven project 51:50 - Providing groupId and artifactId for Maven project 53:35 - Importing Maven project into Eclipse IDE 55:48 - Cleaning up default files and creating new class 57:42 - Managing Maven dependencies for POI Excel project 01:01:32 - Compiling Maven project and resolving errors 01:03:45 - Copying Excel test data and project file setup 01:05:33 - Creating Maven project via Eclipse wizard 01:06:24 - Adding source files and updating Maven project 01:08:46 - Understanding dependency management across projects 01:10:08 - Advice on following setup steps carefully 01:12:00 - Acknowledging complexity and gaining confidence 01:13:12 - Importance of compatible dependency versions 💻 Tech Stack: • Java Programming • Apache POI API • Maven Build Tool • Eclipse IDE • Command Prompt/Terminal 👥 Perfect For: • Automation testing beginners • QA Engineers building frameworks • SDET aspirants • Selenium framework developers 📚 Course Playlist:"https://www.youtube.com/playlist?list=PLSL-R5NJocjjxVd-b5aSzTQPdeU5fviU2" 🔔 Subscribe for more live Java & Selenium classes! maven maven maven poi poi poi excel excel excel automation automation automation framework framework framework #maven #apachepoi #excelautomation #mavensetup #pomxml #seleniumwithjava #liveclass #javaprogramming #automationtesting #qaengineer #sdet #testautomation #maveninstallation #seleniumframework #eclipsemaven