o 'j@sddlmZddlmZddlmZddlmZddlm Z ddl m Z ddZ d d Z dd d ZddZdddZdddZddZddZdS))absolute_import)html)Workbook)get_column_letter) PremailerTablecCs|rt|SdS)Nr)isdigitint)sr p/var/www/html/Deteccion_Ine/venv/lib/python3.10/site-packages/paddleocr/ppstructure/table/tablepyxl/tablepyxl.py string_to_int srcCs:t|}|d}|D]}|q dd|dDS)Nz //comment()cSsg|]}t|qSr r).0tabler r r szget_Tables..z//table)rZ fromstringZxpathZdrop_tag)doctreecommentscommentr r r get_Tabless   rcCsRddlm}|}|jD]}|jD]}|j||d}t||r.|d7}|j||d}t||st|jdd} t|jdd} | dksH| dkrY|j |||| d|| dd|j |_ | || d } | d } | dkrt |jt|jpzdt|j d } | r| | kr| } n| r| | kr| } | |jt|_|| 7}q|d7}|}q |S) z} Writes every tr child element of elem to a row in the worksheet returns the next row after all rows are written r) MergedCell)rowcolumnrcolspan1rowspan)Z start_row start_columnZend_row end_columnz min-widthz max-width)Zopenpyxl.cell.cellrrowscellscell isinstancerelementgetZ merge_cellsvalueformatZ get_dimensionmaxZcolumn_dimensionsrwidthlen) worksheetelemrrrZinitial_columnZ table_rowZ table_cellr#rr min_width max_widthr*r r r write_rowss<        $   r0cCs&|j|jdd}t||dddS)z Takes a table and workbook and writes the table to a new sheet. The sheet title will be the same as the table attribute name. name)titlerN)Z create_sheetr%r& insert_table)rwbwsr r r table_to_sheetDsr6NcCsH|s t}||jt||dd}t|}|D]}t||q|S)z Takes a string representation of an html document and writes one sheet for every table in the document. The workbook is returned F)base_urlZremove_classes)rremoveZactiver transformrr6)rr4r7Zinline_styles_docZtablesrr r r document_to_workbookMs  r:cCst||d}||dS)z Takes a string representation of an html document and writes one sheet for every table in the document. The workbook is written out to a file called filename )r7N)r:save)rfilenamer7r4r r r document_to_xl`s r=cCs4|jr t||j||}|jrt||j||}dSdSN)headr0body)rr,rrr r r r3is r3cCs&|j}|j|j}}t||||dS)zE Inserts a table at the location of an openpyxl Cell object. N)parentrrr3)rr#r5rrr r r insert_table_at_cellpsrB)r)NNr>) __future__rZlxmlrZopenpyxlrZopenpyxl.utilsrZ premailerrZtablepyxl.stylerrrr0r6r:r=r3rBr r r r s       +