Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- import codecs
- import xlrd
- # вводный файл Excel
- main_file = xlrd.open_workbook('Main.xlsx')
- sheet_main = main_file.sheet_by_index(0)
- # Файл Excel, который мы обрабатываем
- pars_file = xlrd.open_workbook('ForPars.xlsx')
- sheet_pars = pars_file.sheet_by_index(0)
- # создаем словарь, который будет представлять собой
- # {'name' : [(start_date, end_date), ...]}
- nameAndRanges = {}
- nameAndRanges[sheet_main.row_values(1)[2]] = [(sheet_main.row_values(1)[6],sheet_main.row_values(1)[7])]
- print(nameAndRanges)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement