openpyxl xlsx file cell value = none
Created originally on Bitbucket by Anonymous
I want to read an xlsx file using openpyxl. Here is the typical code i use:
#!python
import openpyxl
wb = openpyxl.load_workbook("example.xlsx")
sh = wb.get_sheet_by_name(name="Sheet3") or wb.get_sheet_by_name(name="Section3")`
for row_index in range (ws.get_highest_row()):
for col_index in range (ws.get_highest_column()):
print 'Row: '; print row_index ; print ' column :' ; print col_index
print ws.cell(row=row_index, column=col_index).value
But I am unable to do that. Only numeric values are being printed. The xlsx file is being dumped by Jasper in Java
Attachments: report_vap__3_.xlsx