خواندن و ویرایش فایل اکسل در پایتون — راهنمای کاربردی

1# Reading an excel file using Python 
2import xlrd 
3  
4# Give the location of the file 
5loc = ("path of file") 
6  
7# To open Workbook 
8wb = xlrd.open_workbook(loc) 
9sheet = wb.sheet_by_index(0) 
10  
11# For row 0 and column 0 
12sheet.cell_value(0, 0)

1# Program to extract number 
2# of rows using Python 
3import xlrd 
4  
5# Give the location of the file 
6loc = ("path of file") 
7  
8wb = xlrd.open_workbook(loc) 
9sheet = wb.sheet_by_index(0) 
10sheet.cell_value(0, 0) 
11  
12# Extracting number of rows 
13print(sheet.nrows)

1# Program to extract number of 
2# columns in Python 
3import xlrd 
4  
5loc = ("path of file") 
6  
7wb = xlrd.open_workbook(loc) 
8sheet = wb.sheet_by_index(0) 
9  
10# For row 0 and column 0 
11sheet.cell_value(0, 0) 
12  
13# Extracting number of columns 
14print(sheet.ncols)

1# Program extracting all columns 
2# name in Python 
3import xlrd 
4  
5loc = ("path of file") 
6  
7wb = xlrd.open_workbook(loc) 
8sheet = wb.sheet_by_index(0) 
9  
10# For row 0 and column 0 
11sheet.cell_value(0, 0) 
12  
13for i in range(sheet.ncols): 
14    print(sheet.cell_value(0, i))

1# Program extracting first column 
2import xlrd 
3  
4loc = ("path of file") 
5  
6wb = xlrd.open_workbook(loc) 
7sheet = wb.sheet_by_index(0) 
8sheet.cell_value(0, 0) 
9  
10for i in range(sheet.nrows): 
11    print(sheet.cell_value(i, 0))

1# Program to extract a particular row value 
2import xlrd 
3  
4loc = ("path of file") 
5  
6wb = xlrd.open_workbook(loc) 
7sheet = wb.sheet_by_index(0) 
8  
9sheet.cell_value(0, 0) 
10  
11print(sheet.row_values(1))