Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #55053

How to read a particular cell by using "wb = load_workbook('path', True)" in openpyxl

Newsgroups comp.lang.python
Date 2013-09-30 00:26 -0700
Message-ID <e32b083f-65c4-4475-a4de-7cdfa2b5441f@googlegroups.com> (permalink)
Subject How to read a particular cell by using "wb = load_workbook('path', True)" in openpyxl
From somesh g <someshg2@gmail.com>

Show all headers | View raw


Hi..there

I have written code for reading the large excel files 

but my requirement is to read a particular cell in a excel file when i kept "True" 

in "wb = load_workbook('Path', True)"

any body please help me...

CODE:
====
from openpyxl import load_workbook

wb = load_workbook('Path', True)
sheet_ranges = wb.get_sheet_by_name(name = 'Global')
for row in sheet_ranges.iter_rows():
      
    for cell in row: 
        print cell.internal_value

Regards,
G.Someswara Rao

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

How to read a particular cell by using "wb = load_workbook('path', True)" in openpyxl somesh g <someshg2@gmail.com> - 2013-09-30 00:26 -0700

csiph-web