o h@sdZddlZddlmZddlmZmZmZddlm Z ddl m Z dZ dZ d Zdd d Zdd d Ze fddZe fddZe fddZe fddZe fddZe fddZdddZdddZdS)z pyexcel.cookbook ~~~~~~~~~~~~~~~~~~~ Cookbook for pyexcel :copyright: (c) 2014-2017 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_%scCpt|}|r|}tj|rttt|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_namename_columns_by_rowN) OUT_FILE_FORMATTERospathexistsNotImplementedErrorrrcolnameskeysindexstr set_column_atr) infilename column_dicts outfilenamedefault_out_filesheetserieskrrB/var/www/html/env/lib/python3.10/site-packages/pyexcel/cookbook.pyupdate_columnss    rcCr)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)r name_rows_by_columnN) r r r rrrrrownamesrrr set_row_atr)r row_dictsrrrrrrrrr update_rows/s    r#cCs^tj|r ttg}|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 rrrrextendlistcolumns transposer) file_arrayrcontentr r merged_sheetrrr merge_filesEs    r-cC*tj|r tt||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 rrrr-)file1file2rfilesrrrmerge_two_filesUs r2cCs@tj|r ttt}|D]}||jqt||ddS)zmerge many readers With FilterableReader and SeriesReader, you can do custom filtering :param str outfilename: save the sheet as )dest_file_nameadictN) r r rrrrupdatedictr) reader_arrayrr+readerrrr merge_readersbs r9cCr.)zFmerge two readers :param str outfilename: save the sheet as N)r r rrrr9)reader1reader2rr7rrrmerge_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 r$N)rrr r splitnamer)filelistrmergedr r_tailrrrmerge_csv_to_a_book|s  rCcCs,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 r$N)rrr)r?rr@r rrrmerge_all_to_a_booksrDcCs>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)r rbooksaveasrfilenamerrr split_a_books  rIcCs: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 r$rEN)rr)r sheetnamerrFrGrrrrextract_a_sheet_from_a_books  rK)N)__doc__r pyexcel.bookr pyexcel.corerrrpyexcel._compactrpyexcel.constantsrDEFAULT_OUT_FILEDEFAULT_OUT_XLS_FILEr rr#r-r2r9r<rCrDrIrKrrrrs&