Skip to content

Python In Office

Use Python to automate office tasks

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

Category: Python

use-excel-and-python-together

Integrate Python with Excel – from zero to hero

August 12, 2020 Jay Beginner, machine learning, Office Automation, Python

LAST UPDATED: Nov 08 2021 When I first started this blog, I had one idea in mind – to share[…]

Read more
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

Python for Office 101

May 24, 2020 Jay Beginner, Python

Many people are scared of learning a programming language due to its learning curve. Indeed, even the basics of a[…]

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

pip is not recognized – How to fix it?

April 17, 2020 Jay Beginner, Python

‘pip’ is not recognized as an internal or external command, operable program or batch file. If that looks familiar then[…]

Read more
financial-data

Extract/Scrape financial data from websites using Excel & Python

April 7, 2020 Jay Advanced, Finance & Investing, Python, Web Scraping

Today I want to show you how to integrate Excel and Python. In a way that we can call Python[…]

Read more

Posts pagination

«Previous Posts 1 … 15 16 17 18 Next Posts»
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