4b Reading data from execal file

Import open pyxl

Import xlsx writer

Import pandas aspd

Workbook xlsx writer workbook(“hello.xlsx”)

worksheet = workbook.add_worksheet()

worksheet.write('A1', 'NAME')

worksheet.write('B1', 'DEPARTMENT ')

worksheet.write('C1', 'ADDRESS')

worksheet.write('D1', 'AGE')

row = 0

NAME = ["ankit", "rahul", "priya"]

DEPT =["CSE","ECE","CSE"]

ADD["nagercoil","marthandam","palayam kotai"]

AGE=["14","14","15"]

for item in NAME:

    row += 1 

    column = 0

    worksheet.write(row, column, NAME[row-1])

    column = 1

    worksheet.write(row, column, DEPT[row-1])

    column = 2

    worksheet.write(row, column, ADD[row-1])

    column = 3

    worksheet.write(row, column, AGE[row-1])

dataframe = openpyxl.load_workbook("hello.xlsx")

dataframe2 = pd.read_excel('hello.xlsx')

print(dataframe2) 

workbook.close()