1. import os
2. try:
3.     import openpyxl
4.     has_openpyxl = True
5. except:
6.     has_openpyxl = False
7. if not has_openpyxl:
8.     print("You need to intall the openpyxl library to continue....")
9. else:
10.     if os.path.exists("movies.xlsx"):
11.         from openpyxl import load_workbook
12.  
13.         myworkbook = load_workbook("movies.xlsx")
14.         mysheet = myworkbook.active
15.     else:
16.         from openpyxl import Workbook
17.         filename = "movies.xlsx"
18.         myworkbook = Workbook()
19.         myworkbook.save("movies.xlsx")
20.  
21.         from openpyxl import load_workbook
22.         myworkbook = load_workbook("movies.xlsx")
23.         mysheet = myworkbook.active
24.  
25. def report():
26.     movietitle = []
27.     moviegenre = []
28.     movierank = []
29.     moviefile = open("movie_data.txt","r")
30.     cellno = 1
31.     for movie in moviefile:
32.         moviedetails = movie.split(',')
33.         movietitle.append(moviedetails[0])
34.         mysheet['A'+str(cellno)] = moviedetails[0]
35.         moviegenre.append(moviedetails[1])
36.         mysheet['F'+str(cellno)] = moviedetails[1]
37.         movierank.append(moviedetails[2].rstrip("\n",))
38.         mysheet['H'+str(cellno)] = moviedetails[2].rstrip("\n")
39.         numofmovies = len(movietitle)
40.         numtoshow = 0
41.         print("\tMovies, Genres and their Rankings\n")
42.         while numtoshow < numofmovies:
43.             print("\t" + movietitle[numtoshow] + "\t" + moviegenre[numtoshow] + "\t")
44.             numtoshow +=1
45. run = report()
46.