Skip to content

Python In Office

Use Python to automate office tasks

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

Latest Posts

Amazon Price Drop Notification Bot (part 1)

October 17, 2021 Jay Bot automation, Python, Web Scraping

This is part 1 of the Amazon Price Drop Notification Bot series. The name says it all. Stay tuned for[…]

Read more

How To Use Virtual Environment And Jupyter Notebook

October 13, 2021 Jay Intermediate, Python

In this short tutorial, we’ll talk about how to use a Python Virtual Environment (venv) and the Jupyter Notebook. We’ll[…]

Read more

Python Xlsxwriter Create Excel Part 4 Conditional Formatting

October 8, 2021 Jay Intermediate, Office Automation, Python

The Python xlsxwriter library is capable of creating all sorts of conditional formatting for our Excel file. Let’s take a[…]

Read more

Python Data Visualization & Exploration With Plotly

October 4, 2021 Jay Beginner, data visualization, Python

We’ll talk about data visualization & exploration with a Python library called plotly. There are many plotting libraries within the[…]

Read more

Python Xlsxwrite Create Excel Part 3 (Format, Sparkline & Chart)

September 30, 2021 Jay Intermediate, Office Automation, Python

Building upon our previous file, we’ll use Python xlsxwriter library to beautify our boring-looking Excel spreadsheet by adding formatting, sparkline,[…]

Read more

Python Xlsxwriter Create Excel Part 2 (Formula, Link & Named Range)

September 24, 2021 Jay Intermediate, Office Automation, Python

Xlsxwriter is a powerful library that can recreate most of the features of Excel, including formula, link, and named range.[…]

Read more

Use Python Xlsxwriter To Create Excel Spreadsheet

September 20, 2021 Jay Beginner, Office Automation, Python

In this tutorial, we’ll use Python to create a high-fidelity Excel spreadsheet. “High-fidelity” means that the Python-generated Excel spreadsheet will[…]

Read more

How To Connect And Work With SQLite Database Using Python sqlite3

September 4, 2021 Jay Database, Intermediate, machine learning, Office Automation, Python

Today we’ll talk about how to connect and work with the SQLite database using Python. In case you have never[…]

Read more

How To Connect And Work With MS Access Database Using Python pyodbc

April 29, 2021 Jay Database, Python

Python can connect to and work with a wide variety of database applications, MS Access database is one of them.[…]

Read more

Create Free Audiobooks! – Convert Text To Audio In Python

April 10, 2021 Jay Python

In just 10 minutes, you’ll learn how to create an audiobook by converting text to audio files in Python. The[…]

Read more

Posts pagination

«Previous Posts 1 … 11 12 13 14 15 … 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