Видео

after I download the openpyxl, before you time the function, what else should I do first? Where to put the downloaded file openpyxl? because it cannot read by the software. Please include it in the tutorial

Thanks!

I think you should be able to do this with native excel tools too, right?

if anyones excel file is not showing the prompt or the error message this is because in some cases its disabled by default so what you have to do is add this to your code: dv.showInputMessage = True dv.showErrorMessage = True Hope this helps

How to change font for the 1st entire row in an easy way?

@Pythonbits not working for me as well what was your python and openpyxl version ?, i have 3.10.2 and openpyxl as openpyxl==3.1.5

Good video, I think you wanted to say range for rows 2:9.Accidentally, you have mentioned range column

please make a video to compare 2 csv files using pandas.

Thanks, This video really saves my day.

you indian guys on youtube are awesome. kind regards from argentina

great explanation, you are doing a wonderfull job. you're making my life at work a lot easier

hello Python Bits following the proposed exercise, if I had a list. of the same size as column c, but I would like to add my list example, my_list=['a','b','c','d','e','f','g','h', 'm'] in column d, as I introduce with the for loop method, if when I did it, it only copied the last element of the list, in this case m is copied in all rows from 2 to 9. and not like this all the elements in the list. greetings.

can you share these excel files with us so we can write the codes with you at the same time?

thank you my indian brothers

Awesome 👍

Hi bro, please help to automate more scenario and post video

Can you share the code?

Hi, I need to manipulate headers with simple tasks like adding a logo. How to put for example a logo in the left side of the three excel headers?

You deserve the heaven

CAN we code this with forms so it is much user friendly?

for me its working fine only on python end on showing any data validation list in .xls

Very helpful. I liked that you are facing challenges then going back and fixing them. Thanks for a very impressive work.

would be super appreciated videos for pivots and indexmatch also!

Thank you Very helpful

Can you help me? I have code sample of your but don't work validation. import openpyxl from openpyxl.worksheet.datavalidation import DataValidation wb = openpyxl.load_workbook('sample_plan.xlsx') sheet = wb.active valid_options = '"Not Started, In Progress, Completed"' rule = DataValidation(type='list', formula1=valid_options, allow_blank=True) rule.error = 'Your entry is not valid' rule.errorTitle = 'Invalid Entry' rule.prompt = 'Please select from the list' rule.promptTitle = 'List Selection' # Add the data-validation object to the worksheet sheet.add_data_validation(rule) rule.add('C2:C100') wb.save('file.xlsx')

What if I have some data in tabular form in pdf file So what should I use to have my docx same format as my pdf file

I pretty much liked that! Very good, thank you!

Thank you and this video is going to be very helpful for us to arrange our messy data in just a click😊

this will not going to work for large data set.

thx for the video, but i have a problem. I'm doing every step but getting this msg in cmd: "'py' is not recognized as an internal or external command, operable program or batch file."

Perfect, bhai if we have 120+ columns then do you think that firstly we need to count the columns in excel...it's not the right way to do in industry level

Thanks

Is anyone else getting an error saying ‘Worksheet’ has no attribute ’add_data_validation’. And also what if you have an excel file with multiple sheets but you only want to apply it to one specific sheet?

I was so tired to search again and again and I've found you. Thank you for this video !

Excellent. Thank you for the concise and useful tutorial.

where is this data ?? daily data ?

Amazing 🔥

That was brilliant. Thank you

Very informative video! Thank you! Would you be able to create a video for this? We have two excel files..one with highlighted and non-highlighted string....and 2nd file has string which might contain the same string as file #1...so you are asked to look only at the highlighted strings from file #1and check if there is an exact match in the 2nd file. How would you approach this?

Pdffile reader romoved in pypdf2 3 0 0

What does the error 'Workbook' object is not subscriptable mean?

I don't know ur English

Great job! Sir how many pages can be converted?

Great my friend!! The simplest solution I have read so far, and the one it worked!!

a store memory in one location n b stored values in separate memory

Спасибо, быстро и ясно!)

how can we do following in openpyxl, - remove the filters once we create using from openpyxl.worksheet.table import Table - convert the table create to range (like we have in excel Convert to Range)

What about I have large number of columns e.g. A1:ZZZ1000. In loop how many variable I can create. Is there any other way to fatch value from range. Also how to SaveAs file as .csv?

ws.cell(row=i, column=6).value=f_col it's not same f_col=ws.cell(row=i, column=6).value ?? why

Int object has no attribute’value’