How to read data in specific column of XLSX file using python script
<p>I want to read the data given in 2nd and 3rd column from XLSX file.</p>

<pre><code>import xlrd

workbook = xlrd.open_workbook("C:/Users/File.xlsx","rb")
sheet = workbook.sheet_by_index(0)
for row in range(sheet.nrows):
    cols = (sheet.row_values(row,1)) and (sheet.row_values(row,2))
    print(cols)
</code></pre>

<p>But is gives below error when i executed above script..</p>

<pre><code>biff_version = bk.getbof(XL_WORKBOOK_GLOBALS) File
C:\Python27\.....\xlrd_init_.py", line 1323, in getbof raise
XLRDError('Expected BOF record; found 0x%04x' % opcode)
xlrd.biffh.XLRDError: Expected BOF record; found 0x4b50
</code></pre>