Automate Excel and Word with Python - Excel Sheet to Word Docs [openpyxl, docxtpl]

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ต.ค. 2024

ความคิดเห็น • 21

  • @bigrevkev55
    @bigrevkev55 7 หลายเดือนก่อน

    Thank you so much! I'm a college registrar and the company that stores and prints our diplomas was just bought out by a bigger company which has jacked up the annual subscription. So I've created our own. I use a database connection instead of a excel file but it works the same!

  • @ontenzen3284
    @ontenzen3284 ปีที่แล้ว +2

    Cool tutorial. I haven't tried it myself, but I will definetly come back to this, when I have a similar use case. Keep up the good work.

  • @luigihurtado7002
    @luigihurtado7002 28 วันที่ผ่านมา

    When I finished it my boss look at me like some sort of super human, thank u very much

  • @carlo_bio
    @carlo_bio หลายเดือนก่อน

    Thanks, really cool video.

  • @asianpsalmshymns
    @asianpsalmshymns 8 หลายเดือนก่อน

    Outstanding Explanation Respectable Madam❤

  • @lega1985
    @lega1985 5 หลายเดือนก่อน

    Спасибо!!! Ты лучшая! Если б мог, то расцеловал!!! Все объяснила очень просто и наглядно!!! ❤❤❤

  • @lajonas3628
    @lajonas3628 ปีที่แล้ว +1

    Hi Hala, i apricate your effort,.. thank you for the video

  • @naveenkarthik3305
    @naveenkarthik3305 5 หลายเดือนก่อน

    Awesome ❤. You are the best Hala.

  • @christianmller7330
    @christianmller7330 4 หลายเดือนก่อน

    Great video! Is there a way to do the same thing but with tables from excel?

  • @fabriciocarranza7044
    @fabriciocarranza7044 ปีที่แล้ว

    Amazing. Thank you

  • @BriNgHouZ
    @BriNgHouZ ปีที่แล้ว

    Thanks for the video. How can I make same but for an excel template? Didnt manage to reach the same result with xlwings

  • @nict5683
    @nict5683 ปีที่แล้ว

    Hey Hala - this was awesome. I am on to the next step of difficulty here - i have multiple rows of data that i need to combine in a single output. The rows will have a common identifier in tuple[0]. 90% of the data in both rows match, but i need a way to pull the unique values from the 10% of columns to the single docx output. Any advice?

    • @tarasgolovatyj4369
      @tarasgolovatyj4369 ปีที่แล้ว

      Hey, why not just to re-make data? Get raw from exel than use some work around to have needed list or dict and use it as you need?

  • @sayurijurema
    @sayurijurema 5 หลายเดือนก่อน

    I am beginner in python, and this video is really easy to understand. But i would like to generate all the certificates as 1 file.docx, how can i change it?

  • @tarasgolovatyj4369
    @tarasgolovatyj4369 ปีที่แล้ว

    holllyy. I'm so exited to find this way of doing stuff. Thanks so mush. As all that "Microsoft out of a box office ways" makes me feel too stupid

  • @turtlecode
    @turtlecode 11 หลายเดือนก่อน

    Perfect tutorial, thanks

  • @ibrahimmoawadibrahim7332
    @ibrahimmoawadibrahim7332 ปีที่แล้ว

    Great 📃

  • @Abcs-o7j
    @Abcs-o7j 8 หลายเดือนก่อน

    How one can extract data like (mp2 = -3.2424) from a large txt file using python programme.???
    Please instruct me

  • @sanathkumarr9075
    @sanathkumarr9075 ปีที่แล้ว

    Its not Looping over generating documents with different data in my case....
    Need help

  • @alielsheikh8091
    @alielsheikh8091 ปีที่แล้ว

    Hello, how can I make my python PyQT5 app with a button to check for updates and deploy my updates remotely online ?

  • @RadovanPalik
    @RadovanPalik ปีที่แล้ว

    You should switch from Python to R and C#. You'll find the world will be nicer and the code faster.