import os
try:
    import openpyxl
    has_openpyxl = True
except:
    has_openpyxl = False
if not has_openpyxl:
    print("You need to intall the openpyxl library to continue....")
else:
    if os.path.exists("movies.xlsx"):
        from openpyxl import load_workbook

        myworkbook = load_workbook("movies.xlsx")
        mysheet = myworkbook.active
    else:
        from openpyxl import Workbook
        filename = "movies.xlsx"
        myworkbook = Workbook()
        myworkbook.save("movies.xlsx")

        from openpyxl import load_workbook
        myworkbook = load_workbook("movies.xlsx")
        mysheet = myworkbook.active

def report():
    movietitle = []
    moviegenre = []
    movierank = []
    moviefile = open("movie_data.txt","r")
    cellno = 1
    for movie in moviefile:
        moviedetails = movie.split(',')
        movietitle.append(moviedetails[0])
        mysheet['A'+str(cellno)] = moviedetails[0]
        moviegenre.append(moviedetails[1])
        mysheet['F'+str(cellno)] = moviedetails[1]
        movierank.append(moviedetails[2].rstrip("\n",))
        mysheet['H'+str(cellno)] = moviedetails[2].rstrip("\n")
        numofmovies = len(movietitle)
        numtoshow = 0
        print("\tMovies, Genres and their Rankings\n")
        while numtoshow < numofmovies:
            print("\t" + movietitle[numtoshow] + "\t" + moviegenre[numtoshow] + "\t")
            numtoshow +=1
run = report()