Facebook
From Wet Water Vole, 3 Years ago, written in Plain Text.
This paste is a reply to Untitled from Toxic Bongo - view diff
Embed
Download Paste or View Raw
Hits: 66
  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.     print("tMovies, Genres and their Rankingsn")
  32.     for movie in moviefile:
  33.         moviedetails = movie.split(',')
  34.         movietitle.append(moviedetails[0])
  35.         mysheet['A'+str(cellno)] = moviedetails[0]
  36.         moviegenre.append(moviedetails[1])
  37.         mysheet['F'+str(cellno)] = moviedetails[1]
  38.         movierank.append(moviedetails[2].rstrip("n",))
  39.         mysheet['H'+str(cellno)] = moviedetails[2].rstrip("n")
  40.         numofmovies = len(movietitle)
  41.         cellno += 1
  42.        
  43.     numtoshow = 0
  44.        
  45.     while numtoshow < numofmovies:
  46.         print("t" + movietitle[numtoshow] + "t" + moviegenre[numtoshow] + "t")
  47.         numtoshow +=1
  48.        
  49. run = report()
  50.  
  51. myworkbook.save("movies.xlsx")
  52.