Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import openpyxl
- import re
- from datetime import date
- workbook = openpyxl.Workbook()
- today = date.today()
- date_stamp = today.strftime("%Y-%m-%d")
- filename = f"neue_datei_{date_stamp}.xlsx"
- sheet = workbook.active
- with open('ErrorStack.txt', 'r') as file:
- text = file.read()
- pattern = r"((.*?Name:\s{0,1}(.*?)\s).*?\-{5,})"
- matches = re.findall(pattern, text, re.DOTALL)
- for match in matches:
- sheet_name = match[2]
- sheet = workbook.create_sheet(title=sheet_name)
- for row in match[0].split('\n'):
- sheet.append(row.split(','))
- workbook.remove(workbook['Sheet'])
- workbook.save(filename)
Advertisement
Add Comment
Please, Sign In to add comment