HfdZddlZddlmZddlmZmZmZddlm Z ddl m Z dZ dZ d Zdd Zdd Ze fd Ze fd Ze fdZe fdZe fdZe fdZddZddZdS)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_%sct|z}|r|}tj|rt t t |d}|j}|D]@}| t|}| |||A| |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_filesheetserieskrs R/var/www/ffwdstore.be/apps/py-env/lib/python3.11/site-packages/pyexcel/cookbook.pyupdate_columnsrs*J6'& w~~&''3!/222   B B BE ^F    44 SVV$$ E<?3333 MM"#####ct|z}|r|}tj|rt t t |d}|j}|D]@}| t|}| |||A| |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)r name_rows_by_columnN) r r rrrrrrownamesrrr set_row_atr)r row_dictsrrrrrrs r update_rowsr%/s*J6'& w~~&''3!/222   B B BE ^F ^^  .. SVV$$  ! ---- MM"#####rcttj|rttg}|D]F}t |}|t|Gt |}| | ||S)zdmerge many files horizontally column after column :param str outfilename: save the sheet as r )array) r rrrrrextendlistcolumns transposer) file_arrayrcontentr r merged_sheets r merge_filesr0Es w~~k""3!/222G.. I...tEMMOO,,----7+++L%%% rctj|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 rrrrr0)file1file2rfiless rmerge_two_filesr5UsG w~~k""3!/222 ENE{#####rctj|rttt }|D]}||jt||dS)zmerge many readers With FilterableReader and SeriesReader, you can do custom filtering :param str outfilename: save the sheet as )dest_file_nameadictN) r rrrrrupdatedictr) reader_arrayrr.readers r merge_readersr=bsp  w~~k""3!/222mmG$$v{#### ;g666666rctj|rtt||g}t ||dS)zFmerge two readers :param str outfilename: save the sheet as N)r rrrrr=)reader1reader2rr;s rmerge_two_readersrApsH  w~~k""3!/222W%L, ,,,,,rct}|D]@}t|}tj|\}}||_||z }A||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 rsplitnamer)filelistrmergedr r_tails rmerge_csv_to_a_bookrI|sm VVF I...'-- **4 % NN;rc|t}|D]}|t|z }||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)rErrFr s rmerge_all_to_a_bookrKsK VVF00 (Y//// NN;rct|}|r|}n|}|D]#}|jd|}||$dS)zSplit a file into separate sheets :param str file_name: an accessible file name :param str outfilename: save the sheets with file suffix r'rGN)rrDr)r rbooksaveasrfilenames r split_a_bookrPsh i ( ( (D  #jjj&&1 h  rc|t|}|r|}n|}||}|d|}||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'rGN)rr)r sheetnamerrMrNrs rextract_a_sheet_from_a_bookrSsY i ( ( (D OE$99ff-I MM)r)N)__doc__r pyexcel.bookr pyexcel.corerrrpyexcel._compactrpyexcel.constantsrDEFAULT_OUT_FILEDEFAULT_OUT_XLS_FILEr rr%r0r5r=rArIrKrPrSrrr\ss 5555555555((((((------'#!$$$$2$$$$,)9     /? $ $ $ $-= 7 7 7 75E - - - -/C     /C          r