Introduction to OpenpyXL Library [ Python and Microsoft Excel ]

Рет қаралды 24,872

Күн бұрын

This is a quick introduction to "openpyxl" library.
You will be able to learn how to:
0- Introduction 00:00
1- Read from a single cell. 04:01
2- Read From Multiple Cells. 12:01
3- Create and Write on an Excel sheet. 19:22
4- Basic arithmetic operations. 30:33
Social Media
----------------------
Facebook : / bekbrace
Twitter : / bekbrace
Instagram : / bek_brace
/ theamirovic. .
DEV blog : dev.to/bekbrace
GitHub : github.com/BekBrace
Reach out: info@bekbrace.com
Join this channel to get access to perks:
/ @bekbrace

Пікірлер: 48

@williamthatsmyname 2 жыл бұрын

Once again with a real world programming example. Thanks my dude.

@BekBrace 2 жыл бұрын

Glad you liked it, my friend !

@metralios Жыл бұрын

This tutorial is straight forward and informative. Thanks

@BekBrace Жыл бұрын

Thank you very much for watching

@asha6175 2 жыл бұрын

Thanks Bek. It would be good to practice with a project

@BekBrace 2 жыл бұрын

Thank you Asha

@nkunam Жыл бұрын

thank you. I learnt something today 🙏

@BekBrace Жыл бұрын

This is great 👍

@monasser6 2 жыл бұрын

Thank you Bek for useful video

@BekBrace 2 жыл бұрын

Thank You :)

@samirmishra9946 2 жыл бұрын

You are great!:) Thanks for the tutorial.

@BekBrace 2 жыл бұрын

Thank you so much Samir 🙏🙂

@Netrouzt Жыл бұрын

Sangat Mudah dipahami bagi Pemula!! Walaupun saya belum fasih berbahasa Inggris.. Melihat video ini, semua orang mudah paham.... Terimakasih dari Indonesia 🇮🇩

@BekBrace Жыл бұрын

Thank you very much 😊

@user-mk6qi5ry3c 5 ай бұрын

Thank you for teach me a lot

@BekBrace 5 ай бұрын

My pleasure, friend 🙏😊

@vasanthkumarkallannavar7594 3 ай бұрын

Thanks Bek, any command that reads the charts which are plotted in the excel file read them and save them to the device as image or figure ? any help ?

@BekBrace 3 ай бұрын

Yes sure, I might create a comprehensive tutorial on the subject soon, stay tuned

@dennydraco 2 жыл бұрын

Great Video. Also wanted to ask you about where you got your command prompt graphics from.

@BekBrace 2 жыл бұрын

Thank You :) This is a link to a blog post I wrote on dev.to telling you how to customize your terminal like you want: dev.to/bekbrace/the-ultimate-powershell-terminal-guide-2li6

@lextrude 2 жыл бұрын

Thank you for the 'clear explanation. What can i do to read the result of a formula and not the fomula contained in the cell? I could not find a solution for this issue. I tried with the data_only set to True but it didn't work. Would appreciate the tip. :D

@BekBrace 2 жыл бұрын

Thank you for you kind comment :) I will try to find a solution for this, as I'm not an expert in openpyxl, but whoever finds a solution first tells the other - ok ?

@RecapPlus 10 ай бұрын

Thank so much.

@BekBrace 10 ай бұрын

You're welcome 🤗

@amitsangwan007 Жыл бұрын

Why did u import Workbook and openpyxl Can't u only import openpyxl and use Workbook by openpyxl.Workbook?

@BekBrace Жыл бұрын

Sure you can, i just tend to explicitly show everything to be as clear as possible for viewers who are less specialized. For clarity not more. Thanks Amit for your observation.

@ISOPOINTQCS Ай бұрын

Thanks for tutorial. I have a question: is wb.active prepair clear new sheet ? If yes' how I open existing sheet without clearing it ? Thank you !

@BekBrace Ай бұрын

In openpyxl, the wb.active attribute refers to the currently active sheet within a workbook. If you want to create a new sheet without clearing any existing data, you can simply add a new sheet to the workbook using the create_sheet() method without specifying a position or name. Here's how you can do it: from openpyxl import Workbook wb = Workbook() new_sheet = wb.create_sheet() existing_sheet = wb["Existing Sheet Name"]

@ISOPOINTQCS Ай бұрын

@@BekBrace Thank you !!! 😍

@agmednassim9527 2 жыл бұрын

👍 great

@BekBrace 2 жыл бұрын

Thanks 🙏

@avgSE81 11 ай бұрын

What font and theme do you use for VSCode?

@BekBrace 11 ай бұрын

Font: Caskadiya Cove Theme: GitHub Dark

@gbvtech 9 ай бұрын

hi, what theme are you using with posh theme terminal?

@BekBrace 9 ай бұрын

This is a custom theme actually :) This is the link to the ps1 file: gist.github.com/BekBrace/ac293eccb3d0a7c1b56685c04f9a8010

@gbvtech 9 ай бұрын

@@BekBrace thanks for sharing, i got it to work with windows terminal but the icons in the paths in the terminal in visual studio code does not show, only [] (square box) instead, i have already set it as a default , im using PowerShell (not windows powershell), any idea how to fix it?

@BekBrace 9 ай бұрын

@@gbvtech no no, you should your powershell first. have you watched my powershell tutorial ? I explained everything there, and you will find where to put that file on your hard drive. check out: kzfaq.info/get/bejne/nNyZhsydtbGtmKc.html

@gbvtech 9 ай бұрын

@@BekBrace got it all to work , my problem in visual studio code is i just needed to set the nerd font i was using in powershell to use also as the font in the terminal in visual studio code, the icons are showing properly now, thanks for sharing your powershell profile