#! python3
from explay.source import ExPlay
from explay.utils import pd_set_option
import fire

pd_set_option(max_colwidth=80, max_columns=15)


if __name__ == "__main__":

    fire.Fire(ExPlay)


    '''
    [merge_all]
    exp merge_all CONV_NAME [XLSX_DIR] [SHEET_NAME] [EXCLUDES] [SAVE]
    exp merge_all --conv-name CONV_NAME [--xlsx-dir XLSX_DIR] 
                                        [--sheet-name SHEET_NAME] 
                                        [--excludes EXCLUDES] 
                                        [--save SAVE]
    ex:
    exp --home=my_home_path merge_all some_converter_name source_path_relative_to_home


    [merge_sheets]
    exp merge_sheets CONV_NAME XLSX_PATH SHEET_NAMES [SAVE]
    exp merge_sheets --conv-name CONV_NAME 
                     --xlsx-path XLSX_PATH 
                     --sheet-names SHEET_NAMES 
                     [--save SAVE]
    ex:
    exp merge_sheets gender_table source/gender_table.xlsx 1,2
    exp merge_sheets gender_table source/gender_table.xlsx '["分類站長(請更新)",
                                                             "分類副站長(請更新)"]'


    [merge_files]
    exp merge_files CONV_NAME RELATIVE_PATHS [XLSX_DIR] [SHEET_NAME] [SAVE]
    exp merge_files --conv-name CONV_NAME 
                    --relative-paths RELATIVE_PATHS 
                    [--xlsx_dir XLSX_DIR] 
                    [--sheet-name SHEET_NAME] 
                    [--save SAVE]
    ex:
    exp merge_files banbiao '["10609_center1.xlsx","10609_center1.xlsx"]'

    '''
