Reading an Excel file using Python



The xlrd module is used to extract data from a spreadsheet.

The command to install the xlrd module is

 pip install xlrd 

Input file:

Code # 1:

Output:

 `NAME` 

Code # 2: Extract row count

# Reading an Excel file using Python

import xlrd

 
# Specify file location

loc = ( "path of file" )

 
# To open the book

wb = xlrd.open_workbook (loc)

sheet = wb.sheet_by_index ( 0 )

 
# For line 0 and column 0

sheet.cell_value ( 0 , 0 )

Output:

 4 

Code # 3: Extract number of columns

# Program for extracting the number
# lines using Python

import xlrd

  
# Specify file location

loc = ( "path of file" )

  

wb = xlrd.open_workbook (loc)

sheet = wb.sheet_by_index ( 0 )

sheet.cell_value ( 0 , 0 )

 
# Extract line count

print (sheet. nrows)

# Program to extract quantity
# columns in Python

import xlrd

 

loc = ( "path of file" )

 

wb = xlrd.open_workbook (loc)

sheet = wb.sheet_by_index ( 0 )

  
# For row 0 and column 0

sheet.cell_value ( 0 , 0 )

 
# Retrieve the number of columns

print (sheet.ncols)

Output:

 3 

Code # 4: Retrieve all column names

# Program that extracts all columns
# Python name

import xlrd

 

loc = ( " path of file " )

  

wb = xlrd .open_workbook (loc)

sheet = wb.sheet_by_index ( 0 )

 
# For row 0 and column 0

sheet.cell_value ( 0 , 0 )

 

for i in range (sheet.ncols):

print  (sheet.cell_value ( 0 , i))

Output:

 NAME SEMESTER ROLL NO  

Code # 5: Extract first column

Output:

 NAME ALEX CLAY JUSTIN 

Code # 6: Retrieving a specific value lines

# Program that extracts the first column

import xlrd

 

loc = ( " path of file " )

  

wb = xlrd.open_workbook (loc)

sheet = wb.sheet_by_index ( 0 )

sheet.cell_value ( 0 , 0 )

 

for i in range (sheet.nrows):

print (sheet.cell_value (i , 0 ))

# Program to extract a specific string value

import xlrd

  

loc = ( "path of file" )

  

wb = xlrd.open_workbook (loc)

sheet = wb.sheet_by_index ( 0 )

 

sheet.cell_value ( 0 , 0 )

 

print (sheet.row_values ​​( 1 < / code> ))

Exit:

 [`ALEX`, ​​4.0, 2011272.0]]