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
myworkbook = load_workbook("movies.xlsx")
mysheet = myworkbook.active
else:
from openpyxl import Workbook
filename = "movies.xlsx"
myworkbook = Workbook()
myworkbook.save("movies.
from openpyxl import load_workbook
myworkbook = load_workbook("movies.xlsx")
mysheet = myworkbook.
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].
mysheet['H'+str(cellno)] = moviedetails[2].
numofmovies = len(movietitle)
cellno += 1
numtoshow =
print("\tMovies, Genres and their Rankings\n")
while numtoshow <
print("\t"
print("t" + movietitle[numtoshow] +
numtoshow
run = report()
myworkbook.save("movies.xlsx")