U [e@sdZddlZddlmZddlmZmZmZddlm Z ddl m Z dZ dZ d Zdd d Zdd d Ze fddZe fddZe fddZe fddZe fddZe fddZd ddZd!ddZdS)"z pyexcel.cookbook ~~~~~~~~~~~~~~~~~~~ Cookbook for pyexcel :copyright: (c) 2014-2022 by Onni Software Ltd. :license: New BSD License, see LICENSE for more details N)Book)save_asget_book get_sheet) OrderedDict)MESSAGE_WARNINGzpyexcel_merged.csvz merged.xlsz pyexcel_%scCspt|}|r|}tj|r$ttt|dd}|j}|D]"}| t |}| |||q>| |dS)aZUpdate one or more columns of a data file with series The data structure of column_dicts should be: key should be first row of the column the rest of the value should an array :param str infilename: an accessible file name :param dict column_dicts: dictionaries of columns :param str outfilename: save the sheet as r) file_nameZname_columns_by_rowN) OUT_FILE_FORMATTERospathexistsNotImplementedErrorrrZcolnameskeysindexstrZ set_column_atr) infilenameZ column_dicts outfilenamedefault_out_filesheetserieskrrR/var/www/html/services/stratfitenv/lib/python3.8/site-packages/pyexcel/cookbook.pyupdate_columnss    rcCspt|}|r|}tj|r$ttt|dd}|j}|D]"}| t |}| |||q>| |dS)a3Update one or more rows of a data file with series datastucture: key should an integer of the row to be updated value should be an array of the data :param str infilename: an accessible file name :param dict row_dicts: dictionaries of rows :param str outfilename: save the sheet as r)rZname_rows_by_columnN) r r r r r rrZrownamesrrrZ set_row_atr)rZ row_dictsrrrrrrrrr update_rows/s    rcCs^tj|rttg}|D] }t|d}|t|qt|d}| | ||S)zdmerge many files horizontally column after column :param str outfilename: save the sheet as r)array) r r r r rrextendlistcolumnsZ transposer)Z file_arrayrcontentrrZ merged_sheetrrr merge_filesEs    r!cCs*tj|rtt||g}t||dS)zmerge two files :param str file1: an accessible file name :param str file2: an accessible file name :param str outfilename: save the sheet as N)r r r r rr!)Zfile1Zfile2rfilesrrrmerge_two_filesUs r#cCs@tj|rttt}|D]}||jqt||ddS)zmerge many readers With FilterableReader and SeriesReader, you can do custom filtering :param str outfilename: save the sheet as )Zdest_file_nameadictN) r r r r rrupdatedictr) reader_arrayrr readerrrr merge_readersbs  r)cCs*tj|rtt||g}t||dS)zFmerge two readers :param str outfilename: save the sheet as N)r r r r rr))Zreader1Zreader2rr'rrrmerge_two_readersps r*cCsFt}|D],}t|d}tj|\}}||_||7}q ||dS)zmerge a list of csv files into a excel book :param list filelist: a list of accessible file path :param str outfilename: save the sheet as rN)rrr r splitnamer)filelistrmergedrr_tailrrrmerge_csv_to_a_book|s  r1cCs,t}|D]}|t|d7}q ||dS)zmerge a list of excel files into a excel book :param list filelist: a list of accessible file path :param str outfilename: save the sheet as rN)rrr)r-rr.rrrrmerge_all_to_a_booksr2cCs>t|d}|r|}n|}|D]}d|j|f}||qdS)zSplit a file into separate sheets :param str file_name: an accessible file name :param str outfilename: save the sheets with file suffix r%s_%sN)rr,r)rrbooksaveasrfilenamerrr split_a_books r7cCs:t|d}|r|}n|}||}d||f}||dS)zExtract a sheet from a excel book :param str file_name: an accessible file name :param str sheetname: a valid sheet name :param str outfilename: save the sheet as rr3N)rr)rZ sheetnamerr4r5rrrrextract_a_sheet_from_a_books  r8)N)N)N)N)__doc__r Z pyexcel.bookrZ pyexcel.corerrrZpyexcel._compactrZpyexcel.constantsrZDEFAULT_OUT_FILEZDEFAULT_OUT_XLS_FILEr rrr!r#r)r*r1r2r7r8rrrrs$