U
|
ý°dº= ã c @ s d Z ddlZddlZddlmZ ddlm mZ ddl m
|
Z ddl m Z mZ ej ddddd iifd
|
ddd iifd ddd iifd ddd iifddddiifdddd iifddddiifddddiifddddiifdddddifdddddifd dd ddifd dd d difd ddd iifd!ddd iifd"dd d#difd$dd d%difd&dd'd(iifd)dd'd*iifd+dd'd,iifd-dd'd.iifd/dd'd(iifd0dd'd1iifd2dd'd3iifd4dd'd5iifd6dd'd*iifd7dd8d9iifd:dd8d9iifd;dd8d9iifd<dd8d9iifd=dd8d9iifd>dd8d9iifd?dd8d@iifdAdd8d@iifdBdd8d@iifdCdd8d@iifdDdd8d@iifdEddFd@iifdGddFd@iifdHddIdJiifdKi fdLi fdMddNd@iifdOdd@dJdPifdQddNd@iifdRddSdTiifdUddSdTiifdVddSdWiifdXddYd9iifdZddYd9iifd[ddYd9iifd\ddYd9iifd]ddYd@iifd^ddYd@iifd_ddYd@iifd`ddYd@iifdaddYd@iifdbdcdTdddeifdfdcdTdddeifdgdcdWdddeifdhdidjdkidjdkidjdkidjdkidlifdmdidjdnidjdnidjdnidjdnidlifdodidpdjdniiifdqdidpdjdniiifdrdidpdjdkiiifdsdidpdjdkiiifdtdidpdjdkiiifdudidpdjdviiifdwdidpdjdviiifdxdidpdjdyiiifdzdidpdjd{iiifd|didpdjd}iiifd~didpdjdiiifddidpdjdiiifddidkdddkdddkdddkddd
ifddidpdddiifddidpdkddiifddidpdddiifddddiifddddiifddddiifddddiifddddpiifddddpiifddddiifddddiifddddiifdddd9iifdddd9iifd ddd9iifd¡ddd@iifd¢d£d¤d¥iifd¦d£d¤d§iifg]¡d¨d© Zdªd« Zej d¬d?ddd8d@iifdd?dd8d@iifd?dEdd@d@d®ifd¯dEddFd9iifd°di fd±dEddFd@iifg¡d²d³ Zej d´eej ¡ dµd¶ ej ¡ D d·d¸g ¡d¹dº Zej d»dd¼g¡d½d¾ Zd¿dÀ ZejdÁd Z ej dÃdÄdÅgdÆfdÇdÈgdÉfdÊdËgdÌfg¡dÍdÎ Z ej dÏdÄdÅdÄggddfdÇgdÈdÇggddfdÊgdÐggddfdÇdÊgdÇdÑggdd fdÇdÊgdÇdÑgdÇdÊggdd fg¡dÒdÓ Z dS )ÔzmTests formatting as writer-agnostic ExcelCells
|
|
ExcelFormatter is tested implicitly in pandas/tests/io/excel
|
é N)Ú
|
CSSWarning)Ú CssExcelCellÚCSSToExcelConverterz css,expectedzfont-family: foo,barÚfontÚnameZfoozfont-family: "foo bar",bazzfoo barzfont-family: foo,
|
barz font-family: foo, bar, bazzfont-family: bar, fooÚbarzfont-family: 'foo bar', bazz font-family: 'foo \'bar', bazzfoo 'barz font-family: "foo \"bar", bazzfoo "barz font-family: "foo ,bar", bazzfoo ,barzfont-family: serifZserifé )r Úfamilyzfont-family: Serifzfont-family: roman, serifZromanz font-family: roman, sans-serifé z font-family: roman, sans serifz font-family: roman, sansserifzfont-family: roman, cursiveé zfont-family: roman, fantasyé zfont-size: 1emÚsizeé zfont-size: xx-smallé zfont-size: x-smallg @zfont-size: smallg333333#@zfont-size: mediumzfont-size: largeg +@zfont-size: x-largeé zfont-size: xx-largeé zfont-size: 50%zfont-weight: 100ÚboldFzfont-weight: 200zfont-weight: 300zfont-weight: 400zfont-weight: normalzfont-weight: lighterzfont-weight: boldTzfont-weight: bolderzfont-weight: 700zfont-weight: 800zfont-weight: 900zfont-style: italicÚitaliczfont-style: obliqueztext-decoration: underlineÚ underlineÚsingleztext-decoration: overlineztext-decoration: nonez text-decoration: line-throughÚstrikez'text-decoration: underline line-through)r r z9text-decoration: underline; text-decoration: line-throughz
|
color: redÚcolorÚFF0000zcolor: #ff0000z color: #f0aZFF00AAztext-shadow: noneZshadowz text-shadow: 0px -0em 0px #CCCz text-shadow: 0px -0em 0px #999ztext-shadow: 0px -0em 0pxz text-shadow: 2px -0em 0px #CCCz text-shadow: 0px -2em 0px #CCCz text-shadow: 0px -0em 2px #CCCztext-shadow: 0px -0em 2pxztext-shadow: 0px -2emzbackground-color: redÚfillÚsolid)ÚfgColorÚ patternTypezbackground-color: #ff0000zbackground-color: #f0azborder-style: solidÚborderÚstyleZmedium)ÚtopÚbottomÚleftÚrightz'border-style: solid; border-width: thinÚthinz/border-top-style: solid; border-top-width: thinr z.border-top-style: solid; border-top-width: 1ptzborder-top-style: solidz1border-top-style: solid; border-top-width: mediumz.border-top-style: solid; border-top-width: 2ptz0border-top-style: solid; border-top-width: thickZthickz.border-top-style: solid; border-top-width: 4ptzborder-top-style: dottedZmediumDashDotDotz0border-top-style: dotted; border-top-width: thinZdottedzborder-top-style: dashedZ mediumDashedz0border-top-style: dashed; border-top-width: thinZdashedzborder-top-style: doubleÚdoublez*border-style: solid; border-color: #0000ffZ0000FF)r r ©r r" r r! z0border-top-style: double; border-top-color: bluez/border-top-style: solid; border-top-color: #06cZ0066CCzborder-top-color: blueÚnone©r r ztext-align: centerÚ alignmentÚ
|
horizontalÚcenterztext-align: leftr! ztext-align: rightr" ztext-align: justifyZjustifyzvertical-align: topÚverticalzvertical-align: text-topzvertical-align: middlezvertical-align: bottomr zvertical-align: text-bottomzwhite-space: nowrapÚ wrap_textzwhite-space: prezwhite-space: pre-linezwhite-space: normalznumber-format: 0%Z number_formatZ format_codez0%u! number-format: 0§[Red](0)§-§@;z0;[red](0);-;@c C s t }||| kstd S ©N©r ÚAssertionError)ÚcssÚexpectedÚconvert© r3 ú\d:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/tests/io/formats/test_to_excel.pyÚtest_css_to_excel s Lr5 c C sN t } | d}ddddddiddiddiddidd d
|
d d |ksJtd S ) NzÈ
|
font-weight: bold;
|
text-decoration: underline;
|
color: red;
|
border-width: thin;
|
text-align: center;
|
vertical-align: top;
|
unused: something;
|
Tr r )r r r r r# r% r* r )r) r+ )r r r( r. )r2 Úactualr3 r3 r4 Útest_css_to_excel_multipleã s ÿ
|
üø ÷r7 zcss,inherited,expectedÚ )r r zfont-style: normalzfont-style: inheritz'font-style: normal; font-style: inheritc C s t |}||| kstd S r- r. )r0 Z inheritedr1 r2 r3 r3 r4 Útest_css_to_excel_inheritedü s r9 zinput_color,output_colorc C s g | ]}d | |fqS )ú#r3 )Ú.0Zrgbr3 r3 r4 Ú
|
<listcomp> s r< )z#F0FZFF00FF)z#ABCZAABBCCc s d| d| d| d| d| d| }i }d d|d < d
|
i|d < fd d dD |d< t d ¡ t }|||ks~tW 5 Q R X d S )Núborder-top-color: ú; border-right-color: ú; border-bottom-color: ú; border-left-color: ú; background-color: ú ; color: r )r r r r r c s i | ]}| d dqS )r& r' r3 )r; Úk©Ú output_colorr3 r4 Ú
|
<dictcomp>- s ÿ z1test_css_to_excel_good_colors.<locals>.<dictcomp>r% r )ÚtmÚassert_produces_warningr r/ )Ú input_colorrE r0 r1 r2 r3 rD r4 Ú test_css_to_excel_good_colors s &ÿ
|
þ
|
rJ rI z not-a-colorc C sp d| d| d| d| d| d| }i }| d k r@ddi|d < t t¡ t }|||ksbtW 5 Q R X d S )
|
Nr= r> r? r@ rA rB r r r )rG rH r r r/ )rI r0 r1 r2 r3 r3 r4 Ú test_css_to_excel_bad_colors7 s &ÿ rK c sL t ttjtj tj ¡ D ]*} t | dkrBt
|
fdd| D s t q d S )Nr c 3 s | ]}| kV qd S r- r3 )r; Úc©Z
|
upper_hexsr3 r4 Ú <genexpr>P s z/tests_css_named_colors_valid.<locals>.<genexpr>) ÚsetÚmapÚstrÚupperÚstringÚ hexdigitsr Ú NAMED_COLORSÚvaluesÚlenÚallr/ )r r3 rM r4 Ú tests_css_named_colors_validM s rY c C sH ddl m} tj}| ¡ D ](\}}||kr>|| |dd
kstqd S )Nr )Ú CSS4_COLORSr )Zmatplotlib.colorsrZ r rU Úitemsr/ )Z
|
mpl_colorsZ pd_colorsr r r3 r3 r4 Ú&test_css_named_colors_from_mpl_presentS s r\ zstyles,expected)r Úgreen)r Úredz color: red;)ú font-weightr )r_ Únormalzfont-weight: normal;)ú
|
text-alignr* )ú
|
TEXT-ALIGNr" ztext-align: right;c
|
C sP t }|j ¡ d| i}tdddd|dd|d}|j ¡ |j||ksLtdS )z>It applies favors latter declarations over former declarations)r r r r8 N©ÚrowÚcolÚvalr Ú
|
css_stylesÚcss_rowÚcss_colZ css_converter)r Ú _call_cachedÚ cache_clearr r r/ )Ústylesr1 Ú converterrg Úcellr3 r3 r4 Ú test_css_excel_cell_precedence\ s
|
ø
|
|
ro z styles,cache_hits,cache_misses)rb r* )ra r! c C s| t }|j ¡ dd t| D }|D ] \}}tdddd||||d q&|j ¡ }|j ¡ |j|ksjt|j|ksxtdS )z It caches unique cell stylesc S s i | ]\}}d |f|qS )r r3 )r; ÚiÚ_styler3 r3 r4 rF s z-test_css_excel_cell_cache.<locals>.<dictcomp>r r8 Nrc ) r rj rk Ú enumerater Ú
|
cache_infoÚhitsr/ Úmisses)rl Z
|
cache_hitsZ cache_missesrm rg rh ri rs r3 r3 r4 Útest_css_excel_cell_cachey s$ #
|
ø
|
|
|
rv ) Ú__doc__rS ZpytestZ pandas.errorsr Z pandas.util._test_decoratorsÚutilZ_test_decoratorsÚtdZpandas._testingZ_testingrG Zpandas.io.formats.excelr r ÚmarkZ parametrizer5 r7 r9 ÚlistrU r[ rV rJ rK rY Zskip_if_no_mplr\ ro rv r3 r3 r3 r4 Ú<module> sÐ þ
|
þ þ þ þüÿþ üÿþ þþþþþþþþþüÿþ þþþ
|
þ ¾þ K
|
ý
|
ýöþ
|
ÿþý
|
|
|
|
|
|
ýþ
|
þúþú
|
ýùíþ
|
