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
    print("tMovies, Genres and their Rankingsn")
    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)
        cellno += 1
        
    numtoshow = 0
       
    while numtoshow < numofmovies:
        print("t" + movietitle[numtoshow] + "t" + moviegenre[numtoshow] + "t")
        numtoshow +=1
        
run = report()
 
myworkbook.save("movies.xlsx")