Advanced Python 8: openpyxl

Показать описание

Using openpyxl to read and write Excel files from python

Рекомендации по теме

Комментарии

Great video!

Note: you might want edit out the part where you open up a new tab to search for your github link if you're showing this to your students, as some of the links that show up are a bit personal.

jstarky

hai sir, im using data_only=True . That time automatic remove formula my excel sheet. How solve I keep formula every cell. Please help me

royalwinautomatedsoftware

I am SAVED cause of this tutorial 😭🙏 THANK

ishitachakraborty

If this is an Excel file that you have access to, not a situation where you are giving this out, you could just put an end of file code in the Excel worksheet where you want to stop and just look for that.

garrowolf

Is this library read excel image file?

bala-stcj

Is it possible to update the cells dynamically use iter_row ? I have a for loop that iterates between a min_row and max_row. The problem is that when I print (row[0]), it correctly prints the value of the first cell in each row between the selected min and max. But i want to now use the same for loop with iter_row to dynamically update the value of row[0] in each row between the selected min and max. Thats where my code is failing. Any help will be much appreciated.

zaynmunshi

How create pivot table using openxlpy library which is equivalent to the following pandas pivot table function?
table = pd.pivot_table(df, values ='A', index =['B', 'C'],
columns =['B'], aggfunc = np.sum)

sahilmakandar

Great staff!! Thanks so much for sharing.

hongren

Can I use this to manipulate an existing excel sheet? I want to plug in a value for a particular cell through my code and let the remainder of the worksheet remain the same. This value has several dependents (use this value in their formulas). I tried to use xlrd and xlwt but they erased all the formulas from the sheet.

soumilpar

Hey Ryan, great videos ! I attempted to recreate your demo however I'm receiving an error,

line 146, in get_all_data_by_filename
data_out = get_all_data(sheet_in=sheet1)
File ("my file path")
N = len(sheet_in.rows)
TypeError: object of type 'generator' has no len()

any idea ?

stefanstapinski

how can i use empty row checker just by itself to see if there's an empty row to write to?

davidbeiler

Hi Ryan,
I am not able to enter multi line string to a cell, I am getting value Error Cannot convert to excel. Using openpyxl 2.5. Even after using this I am facing this error.

Rajakumar-bljk

I need to automate my repetitive test in which I have to import data from an excel row by row and use it to fill a form in website, do you know how to do that ? (Note- there are multiple columns in each row)

learnvik

how can we copy some rows data from one excel sheet and paste the same in new have tried to search copy paste method in openpyxl but unable get proper code or let me know.

Thanks

rajeevagarwal