To return more than one value from a function in Python is impossible. What do you mean? What are yo...
Google Sheets Google Sheets is Google's version of Microsoft Excel. The fundamental difference is th...
Inserting rows With OpenPyXL you can insert rows into a worksheet with the worksheet method insert_r...
There is a way to iterate over Excel tables with OpenPyXL. The functionality has changed in newer ve...
Counting the number of PDF pages Do you need to count the total number of pages in your pdf files?
Rotating PDF files with PyPDF2 and Tkinter Introduction Sometimes we need simple tools to get the jo...
To autofill a column with weekdays in Excel we do not need any shortcuts at all.
Saving a finished report or table in Excel is easy. You choose "SaveAs" and save the sheet as Pdf. D...
Splitting Pdfs with Python In this post, we are going to have a look at how to split all pages from ...
For anybody searching for a great Keypress capture software, that also is free, check out Carnac
I have finally published my first course, Control Excel with Python & OpenPyXL!
Here is a short video on how to map XML schemas to Excel.
Introduction Using Python is wonderful. In fact, it so wonderful that you sometimes want other, non-...
Introduction How to run a multi-thread in Python - While coding, we sometimes want the program to do...
How to refine your Google search; Common search techniques Why do you need to improve your Google se...
Tkinter: Changing tk.Button text with Stringvar() and trace_add In this example, we will see how we ...
Creating a button in Tkinter In this article, we will explore how to create a simple button in Tkint...
Creating and formatting a chart automatically in Excel with VBA Using Excel involves creating a lot ...
Searching for text in PDF files with pypdf2 Portable Document Format (PDF) is wonderful as long as y...
How to search for files on your computer faster with Python When I use the Windows Explorer search w...
Playing Super Mario theme music with Python - Are you a music composer that likes the sound from you...
How to read folder file contents into a text file with Python - Do you need to take all existing fil...
Create folders from a text file, line by line with Python - Do you sometimes need to create a lot of...
Printing dates in Python with the datetime module - Today we are going to dive into the datetime mod...
Draw your initials in Paint with PyAutoGUI! - Do you like drawing your initials? Did you know you ca...
Calling a Sub from a Sub in VBA - When you are creating macros you sometimes want to run other funct...
Excel, VBA, and the Worksheet.Change Event - Do you have users that change a worksheet, and at each ...
Creating a simple file dialog box with Tkinter - Have you come to a point when you want to avoid run...
How do you copy an Excel 2016 formula without changing the cell references?- Have you copied a range...
You have one Excel workbook. You have several sheets in the workbook. You have one summary table on ...
I have always wanted to build Graphical User Interface (GUI) applications but felt that the learning...