Python and Excel programming with OpenPyXL

Here we will:
- load an excel with movies data;
- add a filter;
- add a formula;
- add a horizontal bar chart.

Support this channel, become a member:

🔥 Udemy Courses LOW COST Coupons/ Cupões Cursos Udemy BAIXO CUSTO 🔥:

With Udemy Courses you get/ Com Cursos da Udemy você terá:
♾️ Full lifetime access/ Acesso Vitalício Completo
📱📺 Access on mobile and TV/ Acesso no celular e TV
🏆 Certificate of completion/ Certificado de Conclusão

📚 Useful books from Mike Driscoll 📚:

◾ 💸 Donations 💸 ◾
Please consider giving a donation so I can improve the quality of this content that I made for all of you 😊

⏰TIMESTAMPS⏰
0:00 Intro
0:21 Install OpenPyXL
0:39 Code
2:04 Create excel file
2:31 Insert data
6:34 Add a filter
8:18 Add a formula
10:14 Add a chart

Know more:

Get data from IMDB:

Other videos:

Playlists:

Follow me on Facebook

Or Twitter

#Python #Excel #openpyxl #office #programming #software #AllTech

[JFresh]

I've learned more in the first few minutes from this video than many others in the same amount of time. Really appreciate your straightforward and to the point videos!

[kanikan]

Very intelligent, creative and straight to the point tutorial! Bravo!

[RahulMishra-npfw]

I appreciate your work and all your videos are making videos one day your videos goes to millions of views

[khalilj.]

Hello!
Thank you for this great and valuable content. I’m not a pro in Python but I try to learn it. However, I have a problem to get this script to work correct, or it semi-works only.
With this script I aim to generate number combinations and attache those to an excel file. When running the script the combinations are shown on screen only, in contrast no excel file is created for those combinations. Where’s the trick? What I’m doing wrong in the script? Strange thing is, I got no error messsge either. Can you please advice, appreciate any help or suggestions.
Thank you
Here’s the code:

import itertools
import os
import xlsxwriter

row = 0
col = 0

combin = itertools.combinations(range(1, 15), 7)
count_combin = []
count = 0

for i in combin:
count_combin.append(i)
print(count_combin.index(i)+1, i)
workbook = xlsxwriter.Workbook( os.getcwd() + '\\' + 'combination.xlsx')
worksheet =
worksheet.write(row, col, i[0])
worksheet.write(row, col+1, i[1])
worksheet.write(row, col+2, i[2])
worksheet.write(row, col+3, i[3])
worksheet.write(row, col+4, i[4])
worksheet.write(row, col+5, i[5])
worksheet.write(row, col+6, i[6])

row += 1

workbook.close

print('number of combinations', len(count_combin))


Hello!
Thank’s for a all this valuable content. I’m not a pro in Python but I try to learn it. I have a problem to get this script to work fully, it semi-works to halv of what I need it for. Something seems. to be missing or incorrect.
In this little program I want to generate number combinations and attache those combinations to an excel file.
However, When I run the script it runs correct but only the combinations are shown on the screen, in contrast no excel file was created for the generated combinations.
What I’m doing wrong here? Strange thing is I got no error messsge either. Can you please advice, I appreciate any suggestion or help. Thank you
Here’s the code:

import itertools
import os
import xlsxwriter

row = 0
col = 0

combin = itertools.combinations(range(1, 15), 7)
count_combin = []
count = 0

for i in combin:
count_combin.append(i)
print(count_combin.index(i)+1, i)
workbook = xlsxwriter.Workbook( os.getcwd() + '\\' + 'combination.xlsx')
worksheet =
worksheet.write(row, col, i[0])
worksheet.write(row, col+1, i[1])
worksheet.write(row, col+2, i[2])
worksheet.write(row, col+3, i[3])
worksheet.write(row, col+4, i[4])
worksheet.write(row, col+5, i[5])
worksheet.write(row, col+6, i[6])

row += 1

workbook.close

print('number of combinations', len(count_combin))