Introduction to OpenpyXL Library [ Python and Microsoft Excel ]

Ғылым және технология

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

Пікірлер: 51

  • @williamthatsmyname
    @williamthatsmyname2 жыл бұрын

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

  • @BekBrace

    @BekBrace

    2 жыл бұрын

    Glad you liked it, my friend !

  • @sheet-chat
    @sheet-chat22 күн бұрын

    Thank you for your video; I've learned new knowledge. As I am currently working on something related to an AI assistant for spreadsheets, I found this library particularly useful. It helps in generating Python code to manipulate spreadsheets using AI. Thank you! 📊🤖

  • @BekBrace

    @BekBrace

    22 күн бұрын

    Awesome 👍 I wanted to create a full course on openpyxl but I saw that no one cared 😜 Thank you 🙏

  • @metralios
    @metralios Жыл бұрын

    This tutorial is straight forward and informative. Thanks

  • @BekBrace

    @BekBrace

    Жыл бұрын

    Thank you very much for watching

  • @monasser6
    @monasser62 жыл бұрын

    Thank you Bek for useful video

  • @BekBrace

    @BekBrace

    2 жыл бұрын

    Thank You :)

  • @samirmishra9946
    @samirmishra99462 жыл бұрын

    You are great!:) Thanks for the tutorial.

  • @BekBrace

    @BekBrace

    2 жыл бұрын

    Thank you so much Samir 🙏🙂

  • @nkunam
    @nkunam2 жыл бұрын

    thank you. I learnt something today 🙏

  • @BekBrace

    @BekBrace

    2 жыл бұрын

    This is great 👍

  • @asha6175
    @asha61752 жыл бұрын

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

  • @BekBrace

    @BekBrace

    2 жыл бұрын

    Thank you Asha

  • @Netrouzt
    @Netrouzt Жыл бұрын

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

  • @BekBrace

    @BekBrace

    Жыл бұрын

    Thank you very much 😊

  • @user-mk6qi5ry3c
    @user-mk6qi5ry3c6 ай бұрын

    Thank you for teach me a lot

  • @BekBrace

    @BekBrace

    6 ай бұрын

    My pleasure, friend 🙏😊

  • @agmednassim9527
    @agmednassim95272 жыл бұрын

    👍 great

  • @BekBrace

    @BekBrace

    2 жыл бұрын

    Thanks 🙏

  • @RecapPlus
    @RecapPlus11 ай бұрын

    Thank so much.

  • @BekBrace

    @BekBrace

    11 ай бұрын

    You're welcome 🤗

  • @vasanthkumarkallannavar7594
    @vasanthkumarkallannavar75944 ай бұрын

    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

    @BekBrace

    4 ай бұрын

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

  • @robertomijares6534
    @robertomijares653420 күн бұрын

    when I want to run load_workbook, it tells me that there is a missing argument "id"

  • @dennydraco
    @dennydraco2 жыл бұрын

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

  • @BekBrace

    @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
    @lextrude2 жыл бұрын

    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

    @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 ?

  • @ISOPOINTQCS
    @ISOPOINTQCS2 ай бұрын

    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

    @BekBrace

    2 ай бұрын

    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

    @ISOPOINTQCS

    2 ай бұрын

    @@BekBrace Thank you !!! 😍

  • @amitsangwan007
    @amitsangwan007 Жыл бұрын

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

  • @BekBrace

    @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.

  • @avgSE81
    @avgSE81 Жыл бұрын

    What font and theme do you use for VSCode?

  • @BekBrace

    @BekBrace

    Жыл бұрын

    Font: Caskadiya Cove Theme: GitHub Dark

  • @riazrr3981
    @riazrr3981 Жыл бұрын

    Hi dude is there a repo for this tutorial? thanks for the videos

  • @BekBrace

    @BekBrace

    Жыл бұрын

    Thanks for watching. As far as the reop, no there's none

  • @riazrr3981

    @riazrr3981

    Жыл бұрын

    ​​Thank you for getting back. Nice clean explanation.

  • @gbvtech
    @gbvtech10 ай бұрын

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

  • @BekBrace

    @BekBrace

    10 ай бұрын

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

  • @gbvtech

    @gbvtech

    10 ай бұрын

    @@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

    @BekBrace

    10 ай бұрын

    @@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: kzread.info/dash/bejne/mKqdtculgK6vmNY.html

  • @gbvtech

    @gbvtech

    10 ай бұрын

    @@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

  • @Jriad
    @Jriad6 ай бұрын

    by any chance are you egyptian ? the names are screaming egypt

  • @BekBrace

    @BekBrace

    6 ай бұрын

    I am Egyptian Copt indeed 🙂

  • @Jriad

    @Jriad

    6 ай бұрын

    @@BekBrace i knew it 😏 great content btw

  • @adamdavies5237
    @adamdavies52372 жыл бұрын

    Many thanks!! Easy video ranking - P-R-O-M-O-S-M.

  • @BekBrace

    @BekBrace

    2 жыл бұрын

    Thank You 🙏 Adam

Келесі