U [e@sdZddlmZddlmZmZddlmZeeddZeeddZ e dd Z e d d Z ed"d dZ ed#ddZ ed$ddZeddZeeddd%ddZeeddd&ddZeeddd'ddZeeddd d!Zd S)(z pyexcel.deprecated ~~~~~~~~~~~~~~~~~~~ List of apis that become deprecated but was kept for backward compatibility :copyright: (c) 2015-2022 by Onni Software Ltd. :license: New BSD License )partial)get_book get_sheet) deprecatedz6Deprecated since v0.1.5! Please use get_sheet instead.)messagez5Deprecated since v0.1.5! Please use get_book instead.cKstfd|i|S)z|Load content from physical file :param str file_name: the file name :param any keywords: additional parameters file_namerrkeywordsr T/var/www/html/services/stratfitenv/lib/python3.8/site-packages/pyexcel/deprecated.py load_booksr cKstf||d|S)zLoad content from memory content :param tuple the_tuple: first element should be file extension, second element should be file content :param any keywords: additional parameters ) file_type file_contentr)rrr r r r load_book_from_memory"srNcKsBt|tr*tf|d|d|d|}ntf||d|}|S)aConstructs an instance :class:`Sheet` from a sheet of an excel file except csv, most excel files has more than one sheet. Hence sheetname is required here to indicate from which sheet the instance should be constructed. If this parameter is omitted, the first sheet, which is indexed at 0, is used. For csv, sheetname is always omitted because csv file contains always one sheet. :param str sheetname: which sheet to be used for construction :param int name_colmns_by_row: which row to give column names :param int name_rows_by_column: which column to give row names :param dict keywords: other parameters rrr sheet_namerr isinstancetupler)r sheetnamer Zsheetr r r load-s rcKstf|||d|S)aDConstructs an instance :class:`Sheet` from memory :param str file_type: one value of these: 'csv', 'tsv', 'csvz', 'tsvz', 'xls', 'xlsm', 'xslm', 'ods' :param iostream file_content: file content :param str sheetname: which sheet to be used for construction :param dict keywords: any other parameters rr)rrrr r r r load_from_memoryIs rTcKstf||d|S)zReturn a sheet from a dictionary of one dimensional arrays :param dict the_dict: its value should be one dimensional array :param bool with_keys: indicate if dictionary keys should be appended or not )adict with_keysr)Zthe_dictrr r r r load_from_dict[srcKstfd|i|S)aReturn a sheet from a list of records Sheet.to_records() would produce a list of dictionaries. All dictionaries share the same keys. :params list records: records are likely to be produced by Sheet.to_records() method. recordsr)rr r r r load_from_recordsfs r z7Deprecated since v0.0.7! Please use class Sheet insteadcKs@t|tr(tf|d|d|d|Stf||d|SdS)a+ A single sheet excel file reader Default is the sheet at index 0. Or you specify one using sheet index or sheet name. The short coming of this reader is: column filter is applied first then row filter is applied next use as class would fail though changed since 0.0.7 rrrrNr)rrr r r r Readerrs r!zVDeprecated since v0.0.7! Please use class Sheet(..., name_columns_by_row=0,..) insteadcKsBt|tr(tf|d|d|d|St|f||d|SdS)zA single sheet excel file reader and it has column headers in a selected row use as class would fail changed since 0.0.7 rr)rrname_columns_by_row)rr"NrrrrrrZseriesr r r r SeriesReaders r%zsV