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

[somesh g]

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
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: How to write in to already opened excel file by using openpyxl

[somesh g]

Hi..joel

what is said is correct i dint added save to that after adding its working 
perfect

thanks
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: How to write in to already opened excel file by using openpyxl

[somesh g]

hi..Neil 

yes i dint saved that time and i added the save option and it saved 

Thanks for the response
-- 
https://mail.python.org/mailman/listinfo/python-list

unable to read combo boxes in excel by xlrd package in python

[somesh g]

Hi..there

I want to read the combo box in excel by using xlrd but in the output it is 
showing empty message, its not reading the combo box can u guys help me how to 
read the combo box in excel by xlrd

code written like this

workbook = xlrd.open_workbook('path of the file')
worksheet = workbook.sheet_by_name('sheetname')
TargetSystem = worksheet.cell_value(4, 2)
-- 
https://mail.python.org/mailman/listinfo/python-list