5 Minute Python Scripts - Automate Multiple Sheet Excel Reporting - Full Code Along Walkthrough

** Five Minute Python Tutorial **
Automate creating excel reports from multiple excels sheets using Python

Uses xlrd is read in excel sheets, get their data, and perform data analytics.

Kite helps fund the channel, thanks for checking them out and supporting me --

Ideas with this script:

Connect to Python Time and run at certain intervals throughout a day with changing data sets
Create custom reports that you can connect to any excel sheet using matplotlib
& Plenty More

Code for the for loop used in the video:

i =0
total =0

i = i +1
else:
pass

i = i +1
else:
pass

print(i)
print(total)

print(total/i)

Let me know in the comments below if you would like a certain Python tutorial. Thanks!!

[kmunson]

Perfect - not too beginner-ish, not too advanced - just right. Thanks for this.

[darrenlefcoe]

great video. couple of errors / differences (using windows10).


[1] filename requires full path.
import os
folder =
excelSheet1 = os.path.join(folder, 'testSheet1.xlsx')
[2] for row in range(1, nRow1)
the lowest value is 1 (not zero) for a row.


very helpful.
works.

[zezeandjr]

Came across your video by accident, but glad I did, thanks for the demo.

[Requestnetwork]

This was a great tutorial! Also if anyone has to automate this process for several more products rather than just "Key Lime", I found it easier to use dictionaries. For example...
Define product name as a dictionary
product_name = {}
then use product['product_name'] for the counter

[worldtraveler]

Thanks!! I’m just beginning my Python journey and really appreciate your work. As a DLP Engineer, I’ll be using this to automate scanning reporting.

[yiselllage]

I'm a beginner coding..been doing it for about a week, and I only understand close to 35% of what you are saying...but it looks super cool...hopefully in a month, I could understand much more..😁👌 thanks for the video

[mervynhann]

Great job Derrick. Thanks for creating and sharing this great Python content.

[nicolasscicolone]

Began learning Python this semester via the Brillant.org platform and various books I purchased on Amazon. Hoping to integrate the language into my knowledge of Excel. Thanks for your video!

[tbertw]

Derrick, Great video. Just enuff detail to help and you did not "beat it to death!!!". Good Balance. Tim

[clintongryke]

This is the video I have been looking for. Excellent; more, please.

[leica]

I love your videos - I've been spending ages trying to learn to do Python in order to do excel automation. If we're learning Pandas, is it better to skip these and to straight to the tutorials you did that use Pandas? Thank you so much for these tutorials, you've saved me hours and hours of trying to figure this out on my own.

[eveningswith]

Hi Derrick, great series of videos on creating an equivalent code to work with Excel files!

[muthuraja]

Thanks for sharing your knowledge in python using excel, please make videos how to do automation in python for excel work, like open excel copy paste, range select, delete row and columns, close work book, check the cell values, find active work book ect.. if your try this its relay help for more beginners

[joelrodriguez]

Wow this is amazing. Your video was the gateway l needed to connect my python skills with excel.

You are the greatest!

[Dankdan]

Thanks, great video.
Would you be able to make a video on how to turn a code like that into a standalone application as opposed to something which needs to be run through a terminal?
Thanks

[iftak]

Amazing video for startups...I see its been under a year...keep uploading more python scripts and others. I subbed

[vijayanandjayaramalingam]

Great Derrick. Can you please put a tutorial to compare two excel sheets using a unique key and highlight the difference between two sheets. For example compare two sheets before and after some data changes in excel

[arpsami]

Very easy to follow, even for a non-native English speaker. Where can I get your sample Excel files in your videos? Thank you

[darwinchan]

easy to follow, well explained, thumbs up!

[andycranston]

Hello Derrick. Thanks for introducing me to a great Python module - will definitely be using this and your example code will be a great reference point.