Using Python And Openpyxl For Excel Spreadsheet With Equations, Formatting, And Charts

Hi everyone!

Today I'm showing you how to generate an excel spreadsheet with formatting, equations and charts using Python and openpyxl. I will show you how to add headers, data and worksheets to your excel workbook. Then I will show you how to add equations like sums and generate a chart based off of this data. This could be useful in presenting your data to stakeholders if you are already processing your data in Python.

My code for this is available on GitHub:
https://github.com/chelseafarley/pyth...

And you can find full documentation here:
https://openpyxl.readthedocs.io/

You’ve clearly come here to learn and a free audible trial allows you to increase your learning potential in situations where you may be hands free like at the gym or on your commute. It allows you to spend more time on theory when you aren’t able to watch a screen, so that you can maximise your screen time to pick up technical skills. Try it for free today:
https://amzn.to/49NX6Xe

// ABOUT ME
My name is Chelsea and I started studying software engineering in 2010. I have been working commercially full time since 2014 and have been in various positions from graduate developer to tech lead to solution architect.
I'm a full stack developer with a lot of experience in C# and Javascript but my passion is for mobile development; specifically native iOS development and cross platform using React Native.

I always have many things on the go and am always trying out a new side hustle and failing at it; perhaps you can learn from my mistakes!

Please like and subscribe if you enjoyed this video and want to see more like it!
Have any suggestions on topics you would like to learn more about? Please suggest them in the comments... I would love to help you out while doing a bit of learning myself!

// PRODUCTS USED
I use the following products in the creation of my videos:

Boya MM1 Microphone - https://amzn.to/3uupmOB
A reasonable quality and reasonably sturdy but cost effective microphone that can be used by both DSLR cameras, mobile phones and laptops

Canon 18-55mm Lens - https://amzn.to/3QYYdLk
A kit lens but a decent quality lens for beginners getting used to a DSLR

Canon EOS Rebel T7 with 18-55mm Lens - https://amzn.to/3GdRPuq
This is the kit I started with it includes the lens linked above and is a great starter camera.

I love Apple devices... These are the ones I use for my channel content creation:

Apple iPhone 13 - https://amzn.to/3G8pHcl
A good all round phone, good for Apple development and recording videos with enough high quality features but at a cheaper price point than the pro versions.

Apple MacBook Pro - https://amzn.to/3MUuPV8
A nice portable computer for working from anywhere and perfect for iOS development

Apple iPad Air - https://amzn.to/49LvYrY
Really easy to use for graphic design if required for logos as part of my app development or editing the videos on the go.

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week!

//CONTACT:
Please contact me at: hello@tripwiretech.com

//CRAVING MORE:
You can find links to all my different sites and social media over on Linktree: https://linktr.ee/misscoding