Pfthb

This code basically does what it needs to do. But it does throw an error sometimes whereas I would expect the code to work as all data necessary is present.

So what it does is: (1) Read in users (2) Add information to the Excel dashboard, such as header information, word clouds and profile picture.

Then it saves the Excel file. It sometimes, randomly almost, gives an error: (pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft Excel', 'Open method of Workbooks class failed', 'xlmain11.chm', 0, -2146827284), None)). What part of the code could cause this?

import os
import xlwings as xw
import pandas as pd
import openpyxl


def get_users(file_name):
 """Read all the users from the csv file."""
 users = 
 f = open(file_name, 'r')
 for line in f:
 user = line.strip().split(',')
 screen_name = user[0]
 users.append(screen_name)
 f.close()
 return users


def read_csv_file(file_name):
 """Return csv file with accounts."""
 data = 
 f = open(file_name, 'r')
 for line in f:
 temp = tuple(line.strip().split(';'))
 data.append(temp)
 f.close()
 return data


def write_panda_to_excel(df, start_cell, wb):
 """Write Pandas DataFrame to Excel."""
 sht = wb.sheets['Input']
 sht.range(start_cell).value = df


def add_word_cloud(name, cell, wb):
 """Add the WordCloud to Sheet2 """
 sht = wb.sheets['Sheet2']
 name = os.getcwd() + '\' + name
 rng = sht.range(cell)
 sht.pictures.add(name, top=rng.top, left=rng.left, width=325, height=155)


def add_profile_picture(user, cell, wb):
 #Add charts to dashboard.
 sht = wb.sheets['Sheet1']
 picture = [f for f in os.listdir('.') if f.startswith(user + '.')][0]
 name = os.getcwd() + '\' + picture
 rng = sht.range(cell)
 sht.pictures.add(name, top=rng.top, left=rng.left, width=70, height=90)


app = xw.App(visible=False)

# Read users
os.chdir('../FolderA/')
file_name = 'accounts_file.csv'
users = get_users(file_name)
os.chdir('../Data')

for i, user in enumerate(users):
 try:
 #count += 1
 print(100 * '-')
 print(len(users), i+1, user)

 # go to directory where the dashboard is stored
 os.chdir('../Folder5/FolderE')
 wb = xw.Book('Twitter - Individuele Rapportage.xlsm')
 os.chdir('../../Data/' + user)

 # Remove file if exists
 xl = [e for e in os.listdir('.') if e.endswith('.xlsm')]
 for e in xl:
 os.remove(e)

 # add user name to title of Dashboard
 sht = wb.sheets['Input_Data']

 # add the csv data and profile pictures the other data to the dashboard
 df = pd.read_csv(user + '_header_info.csv', sep=',')
 write_panda_to_excel(df, 'A1', wb)

 cell = 'L20'
 try:
 add_profile_picture(user, cell, wb)
 except:
 os.chdir('../../Folder6')
 with open('Twitter - Profile picture Error.txt', 'a') as ExceptFile:
 ExceptFile.write(str(user) + 'n')
 os.chdir('../Data/' + user)

 name = user + '_WC.png'
 cell = 'Y46'
 add_word_cloud(name, cell, wb)

 xlname = 'Twitter' + user + '.xlsm'

 try:
 wb.save(xlname)
 wb.close()

 except:
 os.chdir('../../Folder6')
 with open('Twitter - Dashboard Generation Errors.txt', 'a') as myfile:
 myfile.write(str(user + "n"))
 myfile.close()
 os.chdir('../Data/' + user)
 os.chdir('..')

 except OSError as exception:
 print(exception)
 os.chdir('..')
 with open('dash_errors.txt', 'w') as dashboard_errors:
 dashboard_errors.write(user+"n")