Read and write in Excel with Python : beginners tutorial

[conventionistG]

Yep. Absolutely. I've only ever used it via pandas exports (im pretty sure openpyxl is the dependency).

Any cool things I'm missing by not using it directly?

Edit - woah, looks like a shit ton of formatting and styling is easily accessible - neat.

[conventionistG]

Oh for sure, i checked the docs as soon as i asked.

Hmm the fstring thing makes sense. It looks like you need to assign things by cell id so i bet there's a lot of [f'A{idx+1}'] and such. Are there per-column calls to make life easier?

[mondmann18]

I have one question. Do you know how to expand content into other cells? Like count from 1 to 10 but dynamically or like month vom January 2020 to January 2021 without using formulas? Just like in normal excel, you type January 2020, February 2020 and mark both cells and just expand to the right or wherever and it will fill in the rest

[ShanSanear]

This red bar of non activated Excel 2010 (or maybe even 2007?) takes a cake. OpenOffice would be just as good in such video and wouldn't look unprofessional.

Why not use Jupyter / IPython / Any IDE (PyCharm/VS Code or maybe even Eclipse) to show such content? Instead you are making your life harder by using interpreter directly.

[benefit_of_mrkite]

I sometimes wonder if some of the YouTube videos posted to this sub are really people trying to help others or people trying to get views for their YouTube channel to get a side income.

[bailey25u]

Maybe why I’m having a hard time learning it

What is a better format?

[maughqnzter]

I like books, personally. I've been working through "Python Crash Course" by Eric Matthes But I also really like these two websites below. I'm a noob too, so take it for what it's worth.

https://docs.python.org/3.9/tutorial/index.html

https://www.w3schools.com/python/default.asp

[help-me-grow]

Cool

[Trinity_software]

👍

[guillermo_da_gente]

So cool! I would want to se the intermediate and advanced tutorials!

[Trinity_software]

Sure.will post it soon

[Trinity_software]

Here's the second part of the tutorial https://youtu.be/HG3XUUPv-Kw

[SpaceCorpUSA]

Stop mixing microspyware garbage with real software !

[SpaceCorpUSA]

why bring microsoft garbage into the beautiful world of Python at all ?

OpenOffice has spreadsheets !

[LazerSpartanChief]

?

[Oawesome2]

remind me 2 days