Work Automation – Writing data to an Excel Spreadsheet

Using to the Openpyxl library we will be writing data to an Excel spreadsheet, the data in this example is that taken via input. We start by defining our workbook and sheet which are pre-existing. I have introduced a Count variable which is incremented by 1 each time input is entered, this is used toContinue reading “Work Automation – Writing data to an Excel Spreadsheet”

Python docx – Writing to a Word document

In this write up we will be going through the adding of paragraphs via Python. The script takes input and writes a new paragraph each time. To begin with we import the docx library and the initiate a new document (This is a Word docx file with no content). We then make use of theContinue reading “Python docx – Writing to a Word document”

Work Automation – email send out via Python (Outlook Servers)

This project has been done before on this site, the only difference here is we’ll be making use of Outlook servers In this script we make use of the Python SMTP library which defines an SMTP client session object that can be used to send mail. The Outlook server we will be accessing can beContinue reading “Work Automation – email send out via Python (Outlook Servers)”

Python Selenium – Logging in to LinkedIn using a web driver

In this project we will use Selenium and a Chrome web driver to log in to a LinkedIn account. Prerequisite of the project is that you have a LinkedIn account and a Chrome web driver stored on your machine. You may download the web driver by clicking here, note that it needs to match yourContinue reading “Python Selenium – Logging in to LinkedIn using a web driver”

Nord VPN – Python location switcher

The following script will take a specified location as input and then attempt to connect to a Nord VPN server in the location entered. The prerequisite of this script is Nord VPN must be installed on your machine; the script will check your machine automatically for the Nord program files. This script is especially idealContinue reading “Nord VPN – Python location switcher”

Work Automation – Bulk email send out via Python (Gmail Servers)

This project has been done before on this site, the only difference here is we’ll be making use of Gmail servers to send our bulk instead. Before we start ensure that you have a list of recipients saved to an xlsx file containing the names and email addresses of our recipients. we begin by openingContinue reading “Work Automation – Bulk email send out via Python (Gmail Servers)”

Work Automation – Bulk email send out via Python

As part of this project we will be creating a Python script that will make use of an Excel spreadsheet containing a list of recipients i.e. their names and emails. The script will fetch this data and use it to carry out a bulk email send out. Before we start ensure that you have aContinue reading “Work Automation – Bulk email send out via Python”

Work Automation – Stop your machine idling, Working from home

If you work from home, you may need to sometimes get away without anyone realising. If your job is anything like mine, you’ll have applications that track your idleness. Ever turned to an orange status on Microsoft Teams? Or on the Spark messenger application? In this post using AutoIt we create a script that willContinue reading “Work Automation – Stop your machine idling, Working from home”

C# Application to Firebase – Inserting Data

Inserting data within Firebase database through use of a C# application. In this post we’ll be going through the inserting of data via a C# application to Googles firebase database. Before you start, ensure you have created a project within Firebase. We will be connecting to the Firebase database through use of web requests. ToContinue reading “C# Application to Firebase – Inserting Data”

C# Application to Firebase – Updating Data

Updating data within Firebase database through use of a C# application. In this post we will cover updating data in Firebase using a C# application. Do ensure you have created a database project within Firebase and have the link to your database ready. A web request will be used to carry out the functionality andContinue reading “C# Application to Firebase – Updating Data”