Read Excel using Python in Robot Framework | Devstringx Technologies

import openpyxl
def open_and_read_excel_file(sheetname, column_value, file):
filename = file
wb_obj = openpyxl.load_workbook(filename, data_only = True)
sheet_obj = wb_obj.get_sheet_by_name(sheetname)
column = int(column_value)
m_row = sheet_obj.max_row
my_list = [] #created an empty list
for i in range(2, m_row): # Here I have started the loop from 2 as I want to skip the column heading value in output
cell_obj = sheet_obj.cell(row=i, column=column)
print(cell_obj.value)
my_list.append(cell_obj.value)
return my_list
# Import OpenPyxlLibrary, ExcelLibrary and the File in which you have created a function to read data from excel file.
*** Settings ***
Library OpenPyxlLibrary
Library ExcelLibrary
Library ../Scripts/ExcelHandling.py
*** Test Cases ***
Read Excel File Data
#open excel and read data from excel
${excel_val}= ExcelHandling.Open And Read Excel File Sheet1 1 E:\\Project_Name\\Files\\Test.xlsx
# Here ‘Sheet1’ is the name of the sheet from which I want to read the data, ‘1’ is the first column whose data I want to get.
# ‘Test.xlsx’ is an excel file which data I want to read.
FOR ${data} IN ${excel_val} # loop to print the excel sheet value on console
log to console ${data}
END

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Devstringx Technologies

Devstringx Technologies

41 Followers

Devstringx Technologies is highly recommended IT company for custom software development, mobile app development and automation testing services