Python openpyxl - Read & write single or multiple set of data into excel sheet

Рет қаралды 15,199

3 жыл бұрын

This video will explain, how to
Read single cell data into excel sheet
Multiple set of data like list of tuples into excel sheet
Write single cell data into excel sheet
Write multiple cell data like list of tuple data into excel sheet
to install openpyxl - pip install openpyxl
Code base -
qavalidation.com/2021/03/pyth...
qavalidation.com/2021/03/pyth...
Selenium with python video tutorial series -
• Setup Python & PyCharm...
Selenium with python blog series -
qavalidation.com/selenium-pyt...
Repo -
github.com/sunilpatro1985/Pag...
You can subscribe to this KZfaq channel here -
kzfaq.info?sub_...
Tech Blog - all my learnings, practice & experiences are recorded here -
qavalidation.com
GitHub projects -
#1 - github.com/qavbox
#2 - github.com/sunilpatro1985
Sample html elements to practice automation -
qavbox.github.io/demo
Follow on Twitter -
/ qavalidation
Join the Facebook group -
/ qavalidation
Like the Facebook page -
/ qavalidation

Пікірлер: 7

@andreymartynov3958 2 жыл бұрын

Thanks a lot!

@gustavofelicidade_ 2 жыл бұрын

Thanks!

@gopubalu1542 3 жыл бұрын

sir good explanation, but I need to read the fill data instead of input formula in particular cell, when [ ].value used. pl help

@geetapuri8798 3 жыл бұрын

Thanks for the valuable video. I was wondering if I want to have last used cell for particular column (for example : "A" or "Z") how to get it through openpyxl? Is there any other python library which can give last specific column used Value. Please help in this regard.

@LeonaMeyer 2 жыл бұрын

At 26.06 I am getting a syntax error on "print(sheet_cells)". Using Python 3

@royalwinautomatedsoftware2985 2 жыл бұрын

Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.

@8ksmiff502 3 жыл бұрын

Hello ! I have parse data with my python file and getting the result in python console, now I want to export this data to excel sheet. Can you help me to do that ?