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: Python Automation

Automate files, Excel and email with Python.

Python for Office Automation: The Complete Starter Guide

Python for Office Automation: The Complete Starter Guide

15 Oct 2022 Β· Python Β· 3 min read

Python for Office Automation: The Complete Starter Guide

Use Python to automate everyday office work: set up Python, handle files and folders, read and write Excel, create Word reports, send emails safely,…

Read article β†’
15 October 2022 by Atul Vij Python, Python Automation

Merge 100 Excel Files into One with Python (in 10 Lines)

Merge 100 Excel Files into One with Python (in 10 Lines)

5 Jun 2022 Β· Python Β· 2 min read

Merge 100 Excel Files into One with Python (in 10 Lines)

Combine every Excel file in a folder into one sheet with Python and pandas β€” with a source column, header checks and a summary.

Read article β†’
5 June 2022 by Atul Vij Python, Python Automation
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
Β© 2026 Atul Vij Β· AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? β†’