How to read a particular cell by using "wb = load_workbook('path', True)" in openpyxl
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
unable to read combo boxes in excel by xlrd package in python
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
Re: How to write in to already opened excel file by using openpyxl
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
Re: How to write in to already opened excel file by using openpyxl
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