Programming

#!/usr/bin/python

import os
from openpyxl.reader.excel import load_workbook
from openpyxl.drawing.image import Image
import csv

directoryPath = r'/REPORTS/'
os.chdir(directoryPath)
folder_list = os.listdir(directoryPath)
for folders, sub_folders, file in os.walk(directoryPath):  
    for name in file:
        if name.endswith(".xlsx"):
            filename = os.path.join(folders, name)
            wb = load_workbook(filename, data_only=True)
            ws = wb.get_sheet_by_name('Filtered')

##here is where the text files are stored
            directory = os.path.join("/REPORTS/temp", "path")
            for root,dirs,files in os.walk(directory):
               for file in files:
                    if file.endswith(".txt"):
                        f = open(textfile, 'r')
                        reader = csv.reader(f, delimiter='\t')
                        for row in reader:
                           ws.append(row)
                           wb.save(filename)

import os
from openpyxl.reader.excel import load_workbook
from openpyxl.drawing.image import Image
import csv

xl_directory = r'<path_to_Excel_directory>'
txt_directory = r'<path_to_text_directory>'

for xl_root, xl_dirs, xl_files in os.walk(xl_directory):
    for xl_file in xl_files:
        if xl_file.endswith('.xlsx'):
            xl_abs_file = os.path.join(xl_root, xl_file)
            wb = load_workbook(xl_abs_file, data_only = True)
            ws = wb.get_sheet_by_name('Filtered')
  
            # Now search for the corresponding text file.
            # Note: if xl_file = '1.xlsx', then xl_file.replace('xlsx', 'txt')
            # returns '1.txt' - the corresponding text file name. If this doesn't
            # hold true, then a different algorithm will be required.
            for txt_root, txt_dirs, txt_files in os.walk(txt_directory):
                for txt_file in txt_files:
                    if txt_file == xl_file.replace('xlsx', 'txt'):
                        fh = open(txt_file, 'r')
                        reader = csv.reader(fh, delimiter = '\t')
                        for row in reader:
                            ws.append(row)
                            wb.save(xl_abs_file)

/usr/local/lib/python2.7/site-packages/openpyxl/reader/worksheet.py:310: UserWarning: Unknown extension is not supported and will be removed
  warn(msg)

Laptop 1:
Pythonxy installation on Windows 7 64-bit (http://python-xy.github.io/)

1)  Python 2.7.10
2)  openpyxl - don't know the version
3)  Excel - Microsoft Excel 2013

Laptop 2:
Anaconda installation on Debian 8 64-bit (https://docs.continuum.io/anaconda/install-linux.html)

1)  Python 3.6.0 on Anaconda 4.3.1 (64-bit)
2)  openpyxl version 2.4.1
3)  Libreoffice Calc 4.3.3.2

 
fh = open(txt_file, 'r')

 
with open (os.path.join(txt_root, txt_file)) as fh: