from Anki import Anki
from Cleaner import Cleaner
SEPARATOR = ';'
def get_frequency(frequency_sheet, word: str) -> str:
for i in range(4, frequency_sheet.max_row):
if frequency_sheet.cell(row=i, column=2).value == word:
# returns position on frequency list
return str(frequency_sheet.cell(row=i, column=1).value)
return "Out of range"
cleaner = Cleaner(sys.argv[1])
cleaner.cleanSubtitles()
wb = openpyxl.load_workbook('frequency.xlsx')
# print(wb.sheetnames)
frequencySheet = wb['10000k']
# print(sheet['A1'].value)
subtitles = open('subtitles', 'r')
to_anki = open('to_anki', 'w')
vocabulary = list(
input("Podaj po przecinku wyrażenia jakie mam poszukać\n").split(','))
comment = input("Podaj komentarz jaki chcesz umiescic w kartach\n")
fileLineNumbers = 0
for line in subtitles:
