Skip to content

Python In Office

Use Python to automate office tasks

  • Home
  • About
  • Beginner
  • Intermediate
  • Advanced
  • Resources
  • Privacy Policy

Category: Office Automation

We provide a series of tutorials on how to automate office tasks such as data manipulation in Excel, sending Outlook emails, or creating Word documents.

outlook calendar meeting python

Get Outlook calendar meeting data using Python

August 5, 2020 Jay Advanced, Office Automation, Python

Recently I made a little program to get Outlook calendar meeting data using Python. The program was a result of[…]

Read more
python-command-line-interface-feature-img

Run Python script using Command-Line Interface (argparse)

July 29, 2020 Jay Advanced, Office Automation, Python

Because we are smart and efficient (read: lazy) workers, we want to find flexible and practical ways to run our[…]

Read more
split merge pdf python

Split and merge PDF files using Python

July 25, 2020 Jay Intermediate, Office Automation, Python

In this short tutorial, I will walk you through how to split and merge PDF files using Python. I once[…]

Read more

Automate Excel with Python xlwings

May 2, 2020 Jay Advanced, Office Automation, Python

In this tutorial, I will show you how to automate Excel with Python xlwings library. Excel is an awesome software[…]

Read more

Convert PDF to Excel with Python

April 28, 2020 Jay Beginner, Office Automation, Python

In this tutorial, we’ll take a look at how to convert PDF to Excel with Python. If you work with[…]

Read more

Move and rename Excel files in Python

April 22, 2020 Jay Beginner, Office Automation, Python

In this short tutorial, we’ll learn how to move and rename Excel files in Python. This method works for not[…]

Read more
large-elephant

How to open large csv or text files using Python

March 27, 2020 Jay Beginner, machine learning, Office Automation, Python

In this tutorial, we’ll learn how to open very large csv or text files using Python. My colleague once received[…]

Read more

Use Python to combine multiple Excel files into one master spreadsheet

March 26, 2020 Jay Beginner, machine learning, Office Automation, Python

In this short tutorial, I’ll show you how to use Python to combine multiple Excel files into one master spreadsheet.[…]

Read more

Posts pagination

«Previous Posts 1 … 5 6 7
Follow @jayzpio

Join our mailing list!

Recent Posts

  • How to Calculate Cosine Similarity in Python
  • How to Use LangChain and ChatGPT in Python – An Overview
  • Create A Mortgage Calculator using Python Pynecone and Plotly
  • Chatgpt in VScode
  • I migrated my WordPress site from Bluehost to Linode

Categories

  • Advanced
  • Beginner
  • Bot automation
  • Career Development
  • Computer Vision
  • data visualization
  • Database
  • Finance & Investing
  • Intermediate
  • machine learning
  • Office Automation
  • Python
  • R Programming
  • Web Development
  • Web Scraping
WordPress Theme: Poseidon by ThemeZee.
Go to mobile version