Forcibly close Excel application

Kallis

Hi

I have a requirement where emails will have to be sent every hour of the day. This is based on an Excel in which a specific column will denote whether email for that particular row will have to be sent or not. This Excel will be constantly edited by one or multiple users. Alteryx cannot run the flow if an Excel that it is using is being edited. 

I need to find a way to forcibly close that Excel sheet even if someone is working on it so that the next set of emails can be sent.

Any help is much appreciated.

Regards

Bobji

Felipe_Ribeir0

Hi @Kallis 

I would use one of the bellow options:

1-Use this macro to copy the file(s) from the user location to another location. Then (using Block Until Done), attach the version of the "another" location to the email tool.

https://community.alteryx.com/t5/Community-Gallery/Copy-files-between-folders/ta-p/1174965

2-You can use the python component with a script to force closing the excel file. Something like this:

import pandas as pd
from openpyxl import load_workbook

for file_path in df['FullPath']:
    # Load the Excel file
    wb = load_workbook(file_path)
    
    # Close the workbook
    wb.close()