Topics

  • AI Tools (2)
  • AutoHotkey (1)
  • Automation (3)
  • Build Your Own LLM (5)
  • Charts & Dashboards (2)
  • Deep Learning (1)
  • Essbase (3)
  • Excel Formulas (11)
  • Excel VBA (104)
  • Formula Combos (5)
  • Fun Facts (8)
  • Google Workspace (1)
  • History (3)
  • Internet & Browser (2)
  • Java (2)
  • JavaScript (2)
  • LLMs (4)
  • Machine Learning (5)
  • Office Scripts (1)
  • Oracle EPM Cloud (1)
  • Oracle Smart View (3)
  • Outlook (4)
  • Phone (2)
  • Power Automate (2)
  • Power Query & Pivots (3)
  • PowerPoint (3)
  • PowerShell (1)
  • Productivity (3)
  • Prompt Engineering (1)
  • Python (4)
  • Python Automation (2)
  • R (2)
  • RAG & Agents (2)
  • Rust (1)
  • SAP (6)
  • SAP GUI Scripting (3)
  • Science (3)
  • Security & Privacy (2)
  • SQL (3)
  • Tech Tips (1)
  • Windows (3)
  • Word (3)

Recent posts

  • Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
  • 5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
  • SAP SE16N and SQVI: Pull Table Data Without ABAP
  • Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
  • LET and LAMBDA: Write Your Own Excel Functions (No VBA)
  • Why Do We Have Leap Years? (And Why 1900 Was Not One)

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips β€” plus wacky facts

Menu

Skip to content
  • Excel
    • Charts & Dashboards
    • Excel Formulas
    • Excel VBA
    • Formula Combos
    • Power Query & Pivots
    • Excel VBA Course
  • Office
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
  • AI & ML
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • RAG & Agents
    • Build Your Own LLM Course
  • SAP & Oracle
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
  • Automation
    • AutoHotkey
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • Tech Tips
    • Internet & Browser
    • Phone
    • Productivity
    • Security & Privacy
    • Windows
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • VBA Playground
    • Formula Lab
    • VBA Bug Hunt
    • Macro Recorder
    • SQL Playground
    • Date & Workday Calculator
    • Excel Shortcut Trainer
    • VBA Quiz
    • Formula Explainer
    • EMI & SIP Calculator
    • Regex Tester
    • CSV to SQL Converter
    • VBA Code Formatter
    • Office Shortcut Finder
  • About
  • Projects

Category Archives: Java

Java basics and working with files and spreadsheets.

Java Streams for Beginners: filter, map and collect Explained

Java Streams for Beginners: filter, map and collect Explained

28 Mar 2023 Β· Java Β· 1 min read

Java Streams for Beginners: filter, map and collect Explained

Java Streams let you process lists in a clear, declarative style. Learn filter, map, sorted, collect and groupingBy with a small sales example.

Read article β†’
28 March 2023 by Atul Vij Java

Read and Write Excel Files in Java with Apache POI

Read and Write Excel Files in Java with Apache POI

21 Apr 2018 Β· Java Β· 2 min read

Read and Write Excel Files in Java with Apache POI

A beginner-friendly guide to reading and writing .xlsx files in Java using Apache POI β€” with complete, working examples and common pitfalls.

Read article β†’
21 April 2018 by Atul Vij Java
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
Β© 2026 Atul Vij Β· AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? β†’