import os
import glob
import xlsxwriter

newest = max(glob.iglob('*.[Tt][Rr][Nn]'), key=os.path.getmtime)
workbook = xlsxwriter.Workbook('OfflineTRN.xlsx')

with open(newest) as f:
    for row, content in enumerate(f):
        for col, value in enumerate(content):
            workbook.write(row, col, value)