xlrd select sheet by name
from __future__ import print_function
from os.path import join, dirname, abspath
import xlrd
fname = join(dirname(dirname(abspath(__file__))), 'test_data', 'Cad Data Mar 2014.xlsx')
# Open the workbook
xl_workbook = xlrd.open_workbook(fname)
# List sheet names, and pull a sheet by name
#
sheet_names = xl_workbook.sheet_names()
print('Sheet Names', sheet_names)
xl_sheet = xl_workbook.sheet_by_name(sheet_names[0])
# Or grab the first sheet by index
# (sheets are zero-indexed)
#
xl_sheet = xl_workbook.sheet_by_index(0)
print ('Sheet name: %s' % xl_sheet.name)
# Pull the first row by index
# (rows/columns are also zero-indexed)
#
row = xl_sheet.row(0) # 1st row
# Print 1st row values and types
#
from xlrd.sheet import ctype_text
print('(Column #) type:value')
for idx, cell_obj in enumerate(row):
cell_type_str = ctype_text.get(cell_obj.ctype, 'unknown type')
print('(%s) %s %s' % (idx, cell_type_str, cell_obj.value))
# Print all values, iterating through rows and columns
#
num_cols = xl_sheet.ncols # Number of columns
for row_idx in range(0, xl_sheet.nrows): # Iterate through rows
print ('-'*40)
print ('Row: %s' % row_idx) # Print row number
for col_idx in range(0, num_cols): # Iterate through columns
cell_obj = xl_sheet.cell(row_idx, col_idx) # Get cell object by row, col
print ('Column: [%s] cell_obj: [%s]' % (col_idx, cell_obj))
Are there any code examples left?
New code examples in category Python
Relative searches
xlrd sheet by name
xlrd load workbook
python xlrd read file rows
xlrd get sheet by name
using xlrd in python
python xlrd example
xlrd get sheet by index
xlrd python read excel with sheet name
python xlrd read
python xlrd current row
xlread example
xlrd get first sheet name
how to select one rows from excel sheet in python xlrd
xlrd python example
xlrd array column python
for j in range(sheet1_Required.ncols): print(sheet1_Required.col_values(i)
python xlrd read xls
get all row xlxs python xlrd
xlrd find all rowsin excel python
xlrd get_
how to use xlrd in python
xlrd program to read excel
python loop through excel sheets xlrd
xlrd example
reading data xlrd python
write a row in excel xlrd
How to get all the rows in excel xlrd
python workbook xlrd
xlrd examples
xlrd read excel
xlrd read line by line
slrd sheet by name
open_workbook python counts sheets in workbook
xlrd read excel sheet
xlrd print sheet
xls workbook.sheet_by_name python
workbook.sheet_by_name python
