Hướng dẫn how do i read a specific row in excel using python? - làm cách nào để đọc một hàng cụ thể trong excel bằng python?

Xem thảo luận

Cải thiện bài viết

Lưu bài viết

Xem thảo luận

Cải thiện bài viết

Lưu bài viết

ĐọcOpenpyxl module in python. Openpyxlis a Python library for reading and writing Excel [with extension xlsx/xlsm/xltx/xltm] files. The openpyxl module allows a Python program to read and modify Excel files.

Bàn luận

Trong bài viết này, chúng ta sẽ thảo luận về cách lặp lại thông qua các hàng excel trong Python. Để thực hiện nhiệm vụ này, chúng tôi sẽ sử dụng mô -đun OpenPyXL trong Python. OpenPyXLIS Một thư viện Python để đọc và ghi các tệp Excel [với phần mở rộng XLSX/XLSM/XLTX/XLTM]. Mô -đun OpenPyXL cho phép chương trình Python đọc và sửa đổi các tệp Excel.

Chúng tôi sẽ sử dụng bảng tính Excel này trong các ví dụ dưới đây:

Python3

Cách tiếp cận số 1:

Chúng tôi sẽ tạo một đối tượng của OpenPyXL, và sau đó chúng tôi sẽ lặp qua tất cả các hàng từ trên xuống dưới.

import

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

df.iloc[6] ## This will give you 7th row

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

df.iloc[6] ## This will give you 7th row

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

df.iloc[6] ## This will give you 7th row

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

df.iloc[6] ## This will give you 7th row

df.iloc[6] ## This will give you 7th row

df.iloc[6] ## This will give you 7th row

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

pandas2

df.iloc[6] ## This will give you 7th row

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

Output:

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

pandas2pandas3

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

Python3

Cách tiếp cận số 1:

Chúng tôi sẽ tạo một đối tượng của OpenPyXL, và sau đó chúng tôi sẽ lặp qua tất cả các hàng từ trên xuống dưới.

import

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

pandas2

df.iloc[6] ## This will give you 7th row

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

import pandas as pd
import xlrd
df = pd.read_excel['abc.xlsx', sheet_name='Sheet1']

df.iloc[6] ## This will give you 7th row

import xlrd 

# Give the location of the file 
loc = ["path of file"] 

# To open Workbook 
wb = xlrd.open_workbook[loc] 
sheet = wb.sheet_by_index[0] 

print[sheet.row_values[7]] 

Output: