#!python
# -*- coding: utf8 -*-
import fire
from explay.source import XlManager


if __name__ == "__main__":

    fire.Fire(XlManager)

    '''
    # [MERGE-STDOUT]
    # merge multiple xlsx and print dataframe to console
    python manage.py --yml=template.yml \
           merge_all - __str__

    # [MERGE-EXCEL]
    # merge multiple xlsx, set excluded_files and export raw excel file
    python manage.py --yml=template.yml \
           merge_all --filename_excludes=ST-O3-106002.xlsx - \
           to_excel output/output.xlsx


    # [MERGE-PARSE-STDOUT]
    # 1. merge multiple xlsx, set excluded_files
    # 2. select output to parse and print dataframe to console
      python manage.py --yml=template.yml \
             merge_all --filename_excludes=ST-O3-106002.xlsx - \
             parse --job_name=to_excel __str__

    # [MERGE-PARSE-EXCEL]
    # 1. merge multiple xlsx, set excluded_files
    # 2. select output to parse
    # 3. export raw excel file
    python manage.py --yml=template.yml \
           merge_all --filename_excludes=ST-O3-106002.xlsx - \
           parse --job_name=to_excel \
           to_excel output/xxx.xlsx


    # [MERGE-PARSE-EXCEL-TEMPLATE]
    # 1. merge multiple xlsx, set excluded_files
    # 2. select output to parse
    # 3. select saved path, excel template and export raw excel file
    python manage.py --yml=template.yml \
           merge_all --filename_excludes=ST-O3-106002.xlsx - \
           parse --job_name=to_excel \
           render_excel --saved_path=output/output3.xlsx --excel_template=ST-O3-106001-output-template2
    '''
