yosemitebandit · June 4, 2012 17:42 · danching · Sep 18, 2018 · theepag · Oct 26, 2022
diff --git a/openpyxl-install-with-pip b/openpyxl-install-with-pip
 $ pip install -E ~/conf/virtualenvs/xyuml https://bitbucket.org/ericgazoni/openpyxl/get/1.5.8.zip
diff --git a/read_test.py b/read_test.py
 from openpyxl import load_workbook

 workbook = load_workbook('/tmp/data.xlsx', use_iterators=True)
 first_sheet = workbook.get_sheet_names()[0]
 worksheet = workbook.get_sheet_by_name(first_sheet)

 for row in worksheet.iter_rows():
    print row

 # check out the last row
 for cell in row:
    print cell
	from openpyxl import load_workbook

	workbook = load_workbook('/tmp/data.xlsx', use_iterators=True)
	first_sheet = workbook.get_sheet_names()[0]
	worksheet = workbook.get_sheet_by_name(first_sheet)

	for row in worksheet.iter_rows():
	print row

	# check out the last row
	for cell in row:
	print cell