o g@sddZddlmZddlmZmZddlmZddlm Z ddl m Z ddl m Z Gd d d eZd S) z;Write worksheets to xml representations in an optimized way) isgenerator)Cell WriteOnlyCell)_WorkbookChild) WorksheetWorkbookAlreadySaved)WorksheetWritercseZdZdZdZdZdZejZej Z ej Z ej Z ej Z ej Z ejZejZejZejZejZejZejZejZejZejZfddZeddZdd Zd d Zd d ZddZddZddZ ddZ!Z"S)WriteOnlyWorksheetz Streaming worksheet. Optimised to reduce memory by writing rows just in time. Cells can be styled and have comments Styles for rows and columns must be applied before writing cells FNcs&t||d|_d|_|dS)Nr)super__init___max_col_max_row_setup)selfparenttitle __class__X/var/www/html/api-tag/env/lib/python3.10/site-packages/openpyxl/worksheet/_write_only.pyr .s zWriteOnlyWorksheet.__init__cCs|jSN)_WriteOnlyWorksheet__savedrrrrclosed4szWriteOnlyWorksheet.closedc csz |jjd}Wn ty|Ynw|d+d}z dV}|||}|j||||d7}q"ty@YnwWdn1sKwY|jjddS)z2 Send rows to the writer's stream T sheetDatarN) _writerxfsend StopIteration_already_savedelement_values_to_row write_row GeneratorExit)rrrow_idxrowrrr _write_rows9s*      zWriteOnlyWorksheet._write_rowscCs&|jdurt||_|jdSdSr)rr write_toprrrr _get_writerPs  zWriteOnlyWorksheet._get_writercCsT|jr|||jdur|jn|j|j|jd|_dS)NT)rr!r*_rowsr write_rowsclose write_tailrrrrr-Vs      zWriteOnlyWorksheet.closecCsXt|st|tttfs||||jdur$||_t |j|j |dS)z^ :param row: iterable containing values to append :type row: iterable N) r isinstancelisttuplerange _invalid_rowr*r+r(nextr)rr'rrrappendgs    zWriteOnlyWorksheet.appendc cst|}t|dD]?\}}|durq z||_Wnty+t|tr'|}ntYnw||_||_|jdur<|j |j_ |V|j sE|jrIt|}q dS)zW Convert whatever has been appended into a form suitable for work_rows rN) r enumeratevalue ValueErrorr/rcolumnr' hyperlink coordinateref has_style)rvaluesr&cellcol_idxr7rrrr#{s,      z!WriteOnlyWorksheet._values_to_rowcCstd)NzHWorkbook has already been saved and cannot be modified or saved anymore.rrrrrr!sz!WriteOnlyWorksheet._already_savedcCstdt|)NzGValue must be a list, tuple, range or a generator Supplied value is {0}) TypeErrorformattype)riterablerrrr3szWriteOnlyWorksheet._invalid_row)#__name__ __module__ __qualname____doc__rrr+r _rel_type_path mime_type_add_row _add_column add_chart add_image add_tabletables print_titlesprint_title_colsprint_title_rows freeze_panes print_area sheet_viewrr propertyrr(r*r-r5r#r!r3 __classcell__rrrrr s>  r N)rHinspectr openpyxl.cellrropenpyxl.workbook.childr worksheetropenpyxl.utils.exceptionsr rr r rrrrs