▶️ Watch Entire OpenPyXL ✅ Subscribe To My RUclips Channel: bit.ly/2PVAsYW bit.ly/2IGzvOR ▶️ See More At: ✅ Join My Facebook Group: Codemy.com bit.ly/2GFmOBz ▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt! Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN
You don't have to loop twice to be able to .value the tuple output, you can simple use index values for this. for cell in range: print(cell[0].value) This will work and you won't have to loop twice, which can be a big performance upgrade when dealing with larger files
How are we able to compile this program with pyinstaller to be executed elsewhere. I would like to be able to execute the file outside of gitbash. How is this possible?
is there a way to make the range we select as Page break view so its also printable? i can do that manually but i wanted to know if OpenPyXL could do it for me
Hey, I'm a little late with my question I guess 😅 I have a excel file, which contains a link. In order to access the information(s) I am looking for, I have to first click that link. Any solution for that? -thanks
What if I want to grab the entire range on a sheet but I don’t know what that range is? For example I want to select the entire data range and then turn on autofilter for that sheet. Worksheet.autofilter()
Thanks for your tutorial, I ran into a problem when I was automating my excel file, I want to fill another column ( date column ) according to the previous column so that it is filled with a condition. How can I do that? Thanks in advance.
How to read cell value by using column name and row name? Example: First column in my excel is row names By using that row names amd columns names i want to get cell values.. Can you help me?
Great content, beautiful work. I just have a couple of questions, how can you edit the excel file, that is, add/remove content, say: a word, number or formula. and how can you access other spreadsheets? and, would it be possible to view a formula saved in excel file, say you have a cell that performs some mathematical operation using other cells within the workbook, would you be able to see it from python using openpyxl? and lastly would you be able to use multiple workbooks at the same time, that is, you have a workbook that contains first names and colors like in the example and another workbook containing another information, age and last names for example?
Hello John I have combobox for excel databank, and it has 300 rows, and 10 columns. How do i do if i select one object from combobox list, and it gets data from B column. Like i choose A10 text from combobox, it gets data from B10. And i need to use that B10 data to calculate things. I have not able to find tutorial for this. Thank you, your videos has been so helpful to this point. -Hannu
Hi John, Excellent tutorials! Question: If the range is variable from time to time is there a way to get that instead of manually entering 'A1': 'AXX' every time. Can it grab the number of cells like in len() ? Thanks
Hi John - thanks for the great content. If I had one request, it would be how to work with Groupings in openpyxl. Specifically, how to extract certain Groupings of data from an .xlsx file. Context: looking to write Groupings from a Workbook into separate Worksheets. Would love to hear if you have a video covering this and/or any recommended resources?
Hi! Let's say I want to print a random value from range 'A1' to 'A10'. Is there any way to do that/is there a series on your channel where you teach about this exact thing? Thanks in advance!
You could just use python's random function to randomly select your value, then just get the data from the spreadsheet in the normal way I show in these videos
Hi John - thanks for the great explanations... I'm a bit confused though, you mentioned what you'd be talking about in the next video, but this series ended with #7 and I can't find the next in this series. There are a ton of videos, and maybe I'm just overlooking it, but I don't see the continuation... can you help me out?
hi sir, hope you are fine... What about the kivy and django tutorials...i am new to the channel,just wanted to know if the courses on kivy and django are still going on..
the double for loop to get the values of a range of cells is something that should not be a thing in openpyxl. Why is it not possible to get the values directly from something like ws['A2':'A10'].value ?
what I'd like to see is using python like you use filters. if this cell value is x return the entire row. I know this can be done. I've seen it in pandas, but still haven't gotten my head around it
Great videos John! How do I dynamically select a range and pasteSpecial - make its values equal to itself import openpyxl wb=openpyxl.load_workbook(path1) sheet = wb['Sheet1'] names=sheet['A'] for cellObj in names: val = str(cellObj.value) if val[0] == "=": #print(val) excel.Range(dynamic range).Select() #PART I WANT TO SELECT IF TRUE excel.Selection.PasteSpecial(Paste=-4163) THANKS!!
why didnt you keep this playlist up? its so useful for people with finance and accounting background like me! I recommend you u to not lose this type of audience that has a lot to do with excel! im just saying
What I see about 80% of the time in comments is that people ungratefully keep saying "John, make this tutorial", "John, can you teach this", "John, do you know this" and are just not grateful and thankful and appreciative for his youtube channel and many amazing and helpful tutorials on different things, how much more to expect from him!? This is unlike what I mention in the comments
@@sachinsinghal13 bro it is your problem if you think so. Why anybody will ask him to make any tutorial series that is already uploaded on RUclips. This is just because he explains things very well
▶️ Watch Entire OpenPyXL ✅ Subscribe To My RUclips Channel:
bit.ly/2PVAsYW bit.ly/2IGzvOR
▶️ See More At: ✅ Join My Facebook Group:
Codemy.com bit.ly/2GFmOBz
▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt!
Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN
Thanks John, this was the missing piece on something I was trying to do. In 3 minutes, you just solved my biggest issue.
Awesome
You don't have to loop twice to be able to .value the tuple output, you can simple use index values for this.
for cell in range:
print(cell[0].value)
This will work and you won't have to loop twice, which can be a big performance upgrade when dealing with larger files
I don't understand why he did not go this approach.
Hey John,
Really great tutorials on openpyxl so far. Keep it up!!!
Thanks! Glad you like it!
How are we able to compile this program with pyinstaller to be executed elsewhere. I would like to be able to execute the file outside of gitbash. How is this possible?
I don't have any videos on that
This is a fantastic video, showed me how to program a range of excel cells.
Valeu!
is there a way to make the range we select as Page break view so its also printable?
i can do that manually but i wanted to know if OpenPyXL could do it for me
Hey, I'm a little late with my question I guess 😅
I have a excel file, which contains a link. In order to access the information(s) I am looking for, I have to first click that link. Any solution for that?
-thanks
What if I want to grab the entire range on a sheet but I don’t know what that range is? For example I want to select the entire data range and then turn on autofilter for that sheet. Worksheet.autofilter()
Man so glad to see you doing this! Do you have any plan to make videos about pandas and data analysis?
Yeah, I have a couple in a playlist already...check the channel
Yes, this is very interesting theme even for me (pandas and data analysis).
Thanks for your tutorial, I ran into a problem when I was automating my excel file, I want to fill another column ( date column ) according to the previous column so that it is filled with a condition. How can I do that? Thanks in advance.
How to read cell value by using column name and row name?
Example: First column in my excel is row names
By using that row names amd columns names i want to get cell values..
Can you help me?
Great content, beautiful work. I just have a couple of questions, how can you edit the excel file, that is, add/remove content, say: a word, number or formula. and how can you access other spreadsheets? and, would it be possible to view a formula saved in excel file, say you have a cell that performs some mathematical operation using other cells within the workbook, would you be able to see it from python using openpyxl? and lastly would you be able to use multiple workbooks at the same time, that is, you have a workbook that contains first names and colors like in the example and another workbook containing another information, age and last names for example?
Is it possible to save it in another new excel file? How? thanks.
Sure, the course shows how to create and save excel files
Can this whole series of python and excel with openpyxl be used in a tkinter program to edit specific excel cells?
Sure
Hello John
I have combobox for excel databank, and it has 300 rows, and 10 columns.
How do i do if i select one object from combobox list, and it gets data from B column.
Like i choose A10 text from combobox, it gets data from B10.
And i need to use that B10 data to calculate things.
I have not able to find tutorial for this.
Thank you, your videos has been so helpful to this point.
-Hannu
Hi John, Excellent tutorials! Question: If the range is variable from time to time is there a way to get that instead of manually entering 'A1': 'AXX' every time. Can it grab the number of cells like in len() ? Thanks
Love to see more in this series ☺️
They're available for purchase at codemy.com I won't be posting any more free here
Hi John - thanks for the great content. If I had one request, it would be how to work with Groupings in openpyxl. Specifically, how to extract certain Groupings of data from an .xlsx file. Context: looking to write Groupings from a Workbook into separate Worksheets. Would love to hear if you have a video covering this and/or any recommended resources?
This helped me a lot!!
What if I have a variable range?
I'd love more of these
like more complex subjects
You can purchase them from Codemy.com
very helpful we need more of this
I've got the entire course for sale on codemy.com
Are you going continue this playlist?
No, to continue to watch it you need to purchase it from Codemy.com
Hi! Let's say I want to print a random value from range 'A1' to 'A10'. Is there any way to do that/is there a series on your channel where you teach about this exact thing? Thanks in advance!
You could just use python's random function to randomly select your value, then just get the data from the spreadsheet in the normal way I show in these videos
Hi John - thanks for the great explanations... I'm a bit confused though, you mentioned what you'd be talking about in the next video, but this series ended with #7 and I can't find the next in this series. There are a ton of videos, and maybe I'm just overlooking it, but I don't see the continuation... can you help me out?
The course continues at codemy.com but you have to purchase it.
Thank you these videos are amazing!
Glad you like them!
From the land of Aussie - When will OpenPyXL #8 coming out?
Never, you have to purchase it from Codemy.com
Is everything got ok
huh?
hi sir, hope you are fine...
What about the kivy and django tutorials...i am new to the channel,just wanted to know if the courses on kivy and django are still going on..
Yes, I’ve been out of town with a family emergency. They’ll start back up next week.
I broke my code because I tried writing to excel and it writes values as text into excel and excel just give me errors
the double for loop to get the values of a range of cells is something that should not be a thing in openpyxl. Why is it not possible to get the values directly from something like ws['A2':'A10'].value ?
Because it will be in tuple format and tuple has no attribute value
is not finished? :'(
what I'd like to see is using python like you use filters. if this cell value is x return the entire row. I know this can be done. I've seen it in pandas, but still haven't gotten my head around it
👌👌👌👍👍Thank you so much
Welcome!
Incredible tutorials, John. Quick question. Is it possible to pass workbook/worksheet as an argument to a function? Somehow im unable to do so.
Sure, I don't see why not...
Awesome video, keep up the incredible work! :)
Thanks!
Where is the next video?
You have to purchase it on codemy.com
Great videos John!
How do I dynamically select a range and pasteSpecial - make its values equal to itself
import openpyxl
wb=openpyxl.load_workbook(path1)
sheet = wb['Sheet1']
names=sheet['A']
for cellObj in names:
val = str(cellObj.value)
if val[0] == "=":
#print(val)
excel.Range(dynamic range).Select() #PART I WANT TO SELECT IF TRUE
excel.Selection.PasteSpecial(Paste=-4163)
THANKS!!
One live value in Excel cell is running with python
Copy it in other cell every 15 seconds
Help me sir
Sorry I don't know what you mean.
really enjoying these! Where is video 8+
You have to purchase it on Codemy.com
Awesome Man
Thanks!
why didnt you keep this playlist up? its so useful for people with finance and accounting background like me! I recommend you u to not lose this type of audience that has a lot to do with excel! im just saying
Because this is a paid course at codemy.com If you want the rest of the videos in the course, you have to purchase them.
Excelent video
Thanks!
thank you teacher
You are welcome
output is coming as None
What did you do differently from the video?
Thank you!
You're welcome!
Please make a scrapy tutorial series on this channel
Sorry, I don't know what that is
*web scrapping
What I see about 80% of the time in comments is that people ungratefully keep saying "John, make this tutorial", "John, can you teach this", "John, do you know this" and are just not grateful and thankful and appreciative for his youtube channel and many amazing and helpful tutorials on different things, how much more to expect from him!? This is unlike what I mention in the comments
@@sachinsinghal13 bro it is your problem if you think so.
Why anybody will ask him to make any tutorial series that is already uploaded on RUclips. This is just because he explains things very well