import logging

logger = logging.getLogger()


def init_logger():
    level = logging.INFO
    logger.setLevel(level)
    formatter = logging.Formatter('%(asctime)s | %(levelname)s | %(funcName)s | %(message)s',
                                  datefmt='%Y-%m-%d %H:%M:%S')
    console_handler = logging.StreamHandler()
    console_handler.setLevel(level)
    console_handler.setFormatter(formatter)

    logger.addHandler(console_handler)


def return_none_if_empty(s):
    if not s:
        return None
    return s


def get_str_from_cell(sheet, row_num, col_num):
    raw_value = sheet.cell(row_num, col_num).value
    if isinstance(raw_value, float):
        raw_value = int(raw_value)
    return return_none_if_empty(str(raw_value).strip())