Python

Search

Python getting content from xl range

from openpyxl import load_workbook

wb = load_workbook(r"C:Usersl470DownloadsTelegram Desktop	ranslated1446186995.xlsx")
ws = wb.active

need_trans = ws['C14':'C174']
for cell_tuple in need_trans:
    for cell in cell_tuple:
        print(cell.value)

Comment

PREVIOUS	NEXT

Code Example
Python :: extracting bounding box from xml file python
Python :: how parse date python no specific format
Python :: how to sort list in python without sort function
Python :: html in nested structure
Python :: Examples pandas.read_hfd5()
Python :: Command to import the Schema interface from voluptuous
Python :: Simple Python Permutation Printing result without for loop
Python :: Python return statement (Write and Call Function)
Python :: int to floats
Python :: numpy find most distant elements in array
Python :: scikit learn lazy predict
Python :: codeforces 1133A in python
Python :: python to uml
Python :: python multi dimensional dict
Python :: generate pycryptodome salt
Python :: Upgrade requests-html in python
Python :: Python NumPy atleast_1d Function Syntax
Python :: geopandas nc file
Python :: Set changed size during iteration
Python :: create game board with radone values within a range python
Python :: Python NumPy insert Function Example Working with Scalars
Python :: python pandas read parquet with progressbar
Python :: NumPy trim_zeros Syntax
Python :: scipy kullbach leibler divergence
Python :: drop column 0 to many
Python :: fibo_itrativ
Python :: call a Python range() using range(start, stop)
Python :: displaying print output in a textbox
Python :: python turtle star
Python :: separete even and odd numbers from a list by filter in python

Search

PYTHON

Python getting content from xl range

ADD CONTENT