format.pyc
1 o 2 P��c|e � @ s. d dl mZ ddlmZ G dd� dej�ZdS )� )� xmlwriter� )�warnc sz e Zd ZdZd�� fdd� Zdd� Zd�dd �Zd 3 d � Zd�d d�Zd�dd�Z d�dd�Z 4 d�dd�Z d�dd�Z d�dd�Z d�dd�Zd d � Zd�d d �Zd�d d!�Zd"d#� Zd�d$d%�Zd�d&d'�Zd(d)� Zd�d*d+�Zd�d,d-�Zd�d.d/�Zd�d0d1�Zd2d3� Zd4d5� Zd�d6d7�Z d8d9� Z d�d:d;�Z d<d=� Z d�d>d?�Z d�d@dA�Z!dBdC� Z"d�dDdE�Z#dFdG� Z$d�dHdI�Z%dJdK� Z&dLdM� Z'd�dNdO�Z(d�dPdQ�Z)d�dRdS�Z*dTdU� Z+dVdW� Z,dXdY� Z-dZd[� Z.d\d]� Z/d^d_� Z0d�dadb�Z1dcdd� Z2dedf� Z3dgdh� Z4didj� Z5dkdl� Z6dmdn� Z7dodp� Z8d�dqdr�Z9dsdt� Z:d�dudv�Z;dwdx� Z<dydz� Z=d{d|� Z>d}d~� Z?dd�� Z@d�d�� ZAd�d�� ZBd�d�� ZCd�d�� ZDd�d�� ZEd�d�� ZFd�d�� ZGd�d�� ZH� ZIS )��Formatz; 5 A class for writing the Excel XLSX Format file. 6 7 8 Nc s� |du ri }t t| ��� || _|| _d| _d| _d| _d| _d| _ d| _ 9 d| _ d| _ d| _ d| _d| _d| _d| _d| _d| _d| _d| _d| _d| _d| _d| _d| _d| _d| _ d| _ d| _ d | _ d| _ d| _!d| _"d| _#d| _$d| _%d| _&d| _'d| _(d| _)d| _*d| _+d| _,d| _-d| _.d| _/d| _0d| _1d| _2d| _3d| _4d| _5d| _6d| _7d| _8d| _9d| _:d| _;d| _<d| _=d| _>d| _?d| _@d| _A|�B� D ] \}}tC| d 10 | �|� q�d| _DdS ) z 11 Constructor. 12 13 N�Generalr �Calibri� � �minorFr �set_)E�superr �__init__�xf_format_indices�dxf_format_indices�xf_index� dxf_index� 14 num_format�num_format_index� 15 font_index�has_font� has_dxf_font�bold� underline�italic� font_name� font_size� 16 font_color�font_strikeout� font_outline� font_shadow� font_script� font_family� font_charset� font_scheme� font_condense� font_extend�theme� hyperlink�xf_id�hidden�locked� text_h_align� text_wrap� text_v_align� text_justlast�rotation�fg_color�bg_color�pattern�has_fill� has_dxf_fill� 17 fill_index� 18 fill_count� border_index� 19 has_border�has_dxf_border� border_count�bottom� bottom_color� diag_border� 20 diag_color� diag_type�left� 21 left_color�right� right_color�top� top_color�indent�shrink� merge_range� reading_order� just_distrib� color_indexed� font_only�items�getattr� _format_key)�self� 22 propertiesZ 23 xf_indicesZ dxf_indices�key�value�� __class__� ��C:\Users\Jacks.GUTTSPC\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\xlsxwriter\format.pyr s� 24 zFormat.__init__c C � 25 || _ dS )z� 26 Set the Format font_name property such as 'Time New Roman'. The 27 default Excel font is 'Calibri'. 28 29 Args: 30 font_name: String with the font name. No default. 31 32 Returns: 33 Nothing. 34 35 N�r �rP r rV rV rW � set_font_namey s 36 zFormat.set_font_namer c C rX )z� 37 Set the Format font_size property. The default Excel font size is 11. 38 39 Args: 40 font_size: Int with font size. No default. 41 42 Returns: 43 Nothing. 44 45 N�r �rP r rV rV rW � set_font_size� � 46 zFormat.set_font_sizec C � | � |�| _dS )z� 47 Set the Format font_color property. The Excel default is black. 48 49 Args: 50 font_color: String with the font color. No default. 51 52 Returns: 53 Nothing. 54 55 N�� 56 _get_colorr �rP r rV rV rW �set_font_color� � zFormat.set_font_colorTc C rX )z� 57 Set the Format bold property. 58 59 Args: 60 bold: Default is True, turns property on. 61 62 Returns: 63 Nothing. 64 65 N)r )rP r rV rV rW �set_bold� r_ zFormat.set_boldc C rX )z� 66 Set the Format italic property. 67 68 Args: 69 italic: Default is True, turns property on. 70 71 Returns: 72 Nothing. 73 74 N)r )rP r rV rV rW � 75 set_italic� r_ zFormat.set_italicr c C rX )z� 76 Set the Format underline property. 77 78 Args: 79 underline: Default is 1, single underline. 80 81 Returns: 82 Nothing. 83 84 N)r )rP r rV rV rW � set_underline� r_ zFormat.set_underlinec C rX )z� 85 Set the Format font_strikeout property. 86 87 Args: 88 font_strikeout: Default is True, turns property on. 89 90 Returns: 91 Nothing. 92 93 N)r )rP r rV rV rW �set_font_strikeout� r_ zFormat.set_font_strikeoutc C rX )z� 94 Set the Format font_script property. 95 96 Args: 97 font_script: Default is 1, superscript. 98 99 Returns: 100 Nothing. 101 102 N)r )rP r rV rV rW �set_font_script� r_ zFormat.set_font_scriptc C rX )z� 103 Set the Format font_outline property. 104 105 Args: 106 font_outline: Default is True, turns property on. 107 108 Returns: 109 Nothing. 110 111 N)r )rP r rV rV rW �set_font_outline� r_ zFormat.set_font_outlinec C rX )z� 112 Set the Format font_shadow property. 113 114 Args: 115 font_shadow: Default is True, turns property on. 116 117 Returns: 118 Nothing. 119 120 N)r )rP r rV rV rW �set_font_shadow� r_ zFormat.set_font_shadowc C rX )z� 121 Set the Format num_format property such as '#,##0'. 122 123 Args: 124 num_format: String representing the number format. No default. 125 126 Returns: 127 Nothing. 128 129 N)r )rP r rV rV rW �set_num_format� r_ zFormat.set_num_formatc C rX )z� 130 Set the Format locked property. 131 132 Args: 133 locked: Default is True, turns property on. 134 135 Returns: 136 Nothing. 137 138 N)r* )rP r* rV rV rW � 139 set_locked r_ zFormat.set_lockedc C rX )z� 140 Set the Format hidden property. 141 142 Args: 143 hidden: Default is True, turns property on. 144 145 Returns: 146 Nothing. 147 148 N)r) )rP r) rV rV rW � 149 set_hidden r_ zFormat.set_hiddenc C s> |� � }|dkr | �d� |dkr| �d� |dkr | �d� |dkr(| �d� |dkr1| �d � |d 150 kr:| �d � |d krC| �d � |dkrL| �d � |dkrU| �d� |dkr^| �d� |dkred| _|dkrn| �d� |dkrw| �d� |dkr�| �d� |dkr�| �d� |dkr�| �d � |dkr�| �d � dS dS )z� 151 Set the Format cell alignment. 152 153 Args: 154 alignment: String representing alignment. No default. 155 156 Returns: 157 Nothing. 158 r@ r �centrer �centerrB � �fill� �justify� Z center_across� Z centre_across� distributed� Zjustify_distributedrD Zvcentre�vcenterr; ZvjustifyZ vdistributedN)�lower�set_text_h_alignrJ �set_text_v_align)rP � alignmentrV rV rW � set_align# sH 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 �zFormat.set_alignc C s | � d� dS )z` 175 Set the Format center_across property. 176 177 Returns: 178 Nothing. 179 180 rw N)r| )rP � 181 align_typerV rV rW �set_center_acrossV s zFormat.set_center_acrossc C rX )z� 182 Set the Format text_wrap property. 183 184 Args: 185 text_wrap: Default is True, turns property on. 186 187 Returns: 188 Nothing. 189 190 N)r, )rP r, rV rV rW � set_text_wrap` r_ zFormat.set_text_wrapc C sX t |�}|dkr d}n d| krdkr!n n 191 |dk r | d }ntd� dS || _dS )z� 192 Set the Format rotation property. 193 194 Args: 195 rotation: Rotation angle. No default. 196 197 Returns: 198 Nothing. 199 200 i �� i�����Z r z3Rotation rotation outside range: -90 <= angle <= 90N)�intr r/ )rP r/ rV rV rW � set_rotationm s 201 � 202 zFormat.set_rotationc C rX )z� 203 Set the Format indent property. 204 205 Args: 206 indent: Default is 1, first indentation level. 207 208 Returns: 209 Nothing. 210 211 N)rF )rP rF rV rV rW � 212 set_indent� r_ zFormat.set_indentc C rX )z� 213 Set the Format shrink property. 214 215 Args: 216 shrink: Default is True, turns property on. 217 218 Returns: 219 Nothing. 220 221 N)rG )rP rG rV rV rW � 222 set_shrink� r_ zFormat.set_shrinkc C rX )z� 223 Set the Format text_justlast property. 224 225 Args: 226 text_justlast: Default is True, turns property on. 227 228 Returns: 229 Nothing. 230 231 N)r. )rP r. rV rV rW �set_text_justlast� r_ zFormat.set_text_justlastc C rX )z� 232 Set the Format pattern property. 233 234 Args: 235 pattern: Default is 1, solid fill. 236 237 Returns: 238 Nothing. 239 240 N)r2 )rP r2 rV rV rW � set_pattern� r_ zFormat.set_patternc C r` )z� 241 Set the Format bg_color property. 242 243 Args: 244 bg_color: Background color. No default. 245 246 Returns: 247 Nothing. 248 249 N)rb r1 )rP r1 rV rV rW � set_bg_color� re zFormat.set_bg_colorc C r` )z� 250 Set the Format fg_color property. 251 252 Args: 253 fg_color: Foreground color. No default. 254 255 Returns: 256 Nothing. 257 258 N)rb r0 )rP r0 rV rV rW � set_fg_color� re zFormat.set_fg_colorc C �, | � |� | �|� | �|� | �|� dS �z� 259 Set the Format bottom property. 260 261 Args: 262 bottom: Default is 1, border type 1. 263 264 Returns: 265 Nothing. 266 267 N)� 268 set_bottom�set_top�set_left� set_right)rP �stylerV rV rW � 269 set_border� � 270 271 272 zFormat.set_borderc C r� )z� 273 Set the Format bottom property. 274 275 Args: 276 color: Color string. No default. 277 278 Returns: 279 Nothing. 280 281 N)�set_bottom_color� set_top_color�set_left_color�set_right_color)rP �colorrV rV rW �set_border_color� r� zFormat.set_border_colorc C rX r� )r; )rP r; rV rV rW r� � r_ zFormat.set_bottomc C r` )z� 282 Set the Format bottom_color property. 283 284 Args: 285 bottom_color: Color string. No default. 286 287 Returns: 288 Nothing. 289 290 N)rb r< )rP r< rV rV rW r� re zFormat.set_bottom_colorc C rX )z� 291 Set the Format diag_type property. 292 293 Args: 294 diag_type: Default is 1, border type 1. 295 296 Returns: 297 Nothing. 298 299 N)r? )rP r? rV rV rW � set_diag_type r_ zFormat.set_diag_typec C rX )z� 300 Set the Format left property. 301 302 Args: 303 left: Default is 1, border type 1. 304 305 Returns: 306 Nothing. 307 308 N)r@ )rP r@ rV rV rW r� r_ zFormat.set_leftc C r` )z� 309 Set the Format left_color property. 310 311 Args: 312 left_color: Color string. No default. 313 314 Returns: 315 Nothing. 316 317 N)rb rA )rP rA rV rV rW r� * re zFormat.set_left_colorc C rX )z� 318 Set the Format right property. 319 320 Args: 321 right: Default is 1, border type 1. 322 323 Returns: 324 Nothing. 325 326 N)rB )rP rB rV rV rW r� 7 r_ zFormat.set_rightc C r` )z� 327 Set the Format right_color property. 328 329 Args: 330 right_color: Color string. No default. 331 332 Returns: 333 Nothing. 334 335 N)rb rC )rP rC rV rV rW r� D re zFormat.set_right_colorc C rX )z� 336 Set the Format top property. 337 338 Args: 339 top: Default is 1, border type 1. 340 341 Returns: 342 Nothing. 343 344 N)rD )rP rD rV rV rW r� Q r_ zFormat.set_topc C r` )z� 345 Set the Format top_color property. 346 347 Args: 348 top_color: Color string. No default. 349 350 Returns: 351 Nothing. 352 353 N)rb rE )rP rE rV rV rW r� ^ re zFormat.set_top_colorc C r` )z� 354 Set the Format diag_color property. 355 356 Args: 357 diag_color: Color string. No default. 358 359 Returns: 360 Nothing. 361 362 N)rb r> )rP r> rV rV rW �set_diag_colork re zFormat.set_diag_colorc C rX )z� 363 Set the Format diag_border property. 364 365 Args: 366 diag_border: Default is 1, border type 1. 367 368 Returns: 369 Nothing. 370 371 N)r= )rP r= rV rV rW �set_diag_borderx r_ zFormat.set_diag_borderc C � 372 || _ d S �N)r )rP r rV rV rW � set_has_font� � 373 zFormat.set_has_fontc C r� r� )r3 )rP r3 rV rV rW � set_has_fill� r� zFormat.set_has_fillc C r� r� )r )rP r rV rV rW �set_font_index� r� zFormat.set_font_indexc C r� r� )r )rP r rV rV rW � set_xf_index� r� zFormat.set_xf_indexc C r� r� )r )rP r rV rV rW � set_dxf_index� r� zFormat.set_dxf_indexc C r� r� )r )rP r rV rV rW �set_num_format_index� r� zFormat.set_num_format_indexc C r� r� )r+ )rP r+ rV rV rW r| � r� zFormat.set_text_h_alignc C r� r� )r- )rP r- rV rV rW r} � r� zFormat.set_text_v_alignr c C r� r� )rI )rP � directionrV rV rW �set_reading_order� r� zFormat.set_reading_orderc C s | � |� d S r� )r )rP �alignrV rV rW � 374 set_valign� s zFormat.set_valignc C r� r� )r! )rP r! rV rV rW �set_font_family� r� zFormat.set_font_familyc C r� r� )r" )rP r" rV rV rW �set_font_charset� r� zFormat.set_font_charsetc C r� r� )r# )rP r# rV rV rW �set_font_scheme� r� zFormat.set_font_schemec C r� r� )r$ )rP r$ rV rV rW �set_font_condense� r� zFormat.set_font_condensec C r� r� )r% )rP r% rV rV rW �set_font_extend� r� zFormat.set_font_extendc C r� r� )r& )rP r& rV rV rW � set_theme� r� zFormat.set_themec C s$ d| _ | �d� | �d� || _d S )Nr � 375 )r( rh r� r' )rP r' rV rV rW � set_hyperlink� s 376 377 378 zFormat.set_hyperlinkc C r� r� )rK )rP Z color_indexrV rV rW �set_color_indexed� r� zFormat.set_color_indexedc C r� r� )rL )rP rL rV rV rW � set_font_only� r� zFormat.set_font_onlyc C r� r� rY rZ rV rV rW �set_font� r� zFormat.set_fontc C r� r� r\ r] rV rV rW �set_size� r� zFormat.set_sizec C s | � |�| _d S r� ra rc rV rV rW � set_color� s zFormat.set_colorc C s8 d}g }| j s| js| js| js| js| js| jr d}n||fS | jr5| j dkr5| j dkr5| j dkr5d| _ | jr;d| _| j dkrCd| _| j dkrKd| _| j dkrSd| _| j dkr[d| _| jrad| _d}| j dkrm|�d� | j d krw|�d 379 � | j dkr�|�d � | j dkr�|�d � | j dkr�|�d � | j dkr�|�d|f� | j dkr�|�d� | jr�|�d� | jdkr�|�d� | jd kr�|�d� | jdkr�|�d� | jdkr�|�d� | jr�|�d| jf� | jr�|�d| jf� | jr�|�d� | j�r|�d� | jdk�r |�d� | jd k�r|�d� ||fS ) Nr r rr ry rt rv �centerContinuous)� 380 horizontalr@ r )r� rq )r� rB )r� rs )r� ru rw r� )r� rx )�justifyLastLiner )�verticalrD )r� rq )r� ru )r� rx rF � textRotation)�wrapTextr )� shrinkToFitr )� readingOrderr )r� r ) r+ r- rF r/ r, rG rI rJ �append)rP �changedr� � 381 continuousrV rV rW �_get_align_properties� s� ���� 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 z Format._get_align_propertiesc C s( g }| j s 415 |�d� | jr|�d� |S )N)r* r )r) r )r* r� r) )rP �attribsrV rV rW �_get_protection_propertiesE s 416 417 z!Format._get_protection_propertiesc 418 C sJ | j d u r"d�dd� | �� | �� | �� | �� | j| j| jfD ��| _ | j S )N�:c s � � | ]}t |�V qd S r� ��str��.0�xrV rV rW � <genexpr>S � � z)Format._get_format_key.<locals>.<genexpr>) rO �join� _get_font_key�_get_border_key� _get_fill_key�_get_alignment_keyr r* r) )rP rV rV rW �_get_format_keyP s 419 420 � zFormat._get_format_keyc C sL d� dd� | j| j| j| j| j| j| j| j| j | j 421 | j | j | j f D ��}|S )Nr� c s r� r� r� r� rV rV rW r� ` r� z'Format._get_font_key.<locals>.<genexpr>)r� r r r" r! r r r r r r r r r& �rP rR rV rV rW r� ^ s 422 423 �zFormat._get_font_keyc C sD d� dd� | j| j| j| j| j| j| j| j| j | j 424 | j f D ��}|S )Nr� c s r� r� r� r� rV rV rW r� s r� z)Format._get_border_key.<locals>.<genexpr>) r� r; r< r= r> r? r@ rA rB rC rD rE r� rV rV rW r� q s 425 426 � zFormat._get_border_keyc C s$ d� dd� | j| j| jfD ��}|S )Nr� c s r� r� r� r� rV rV rW r� � r� z'Format._get_fill_key.<locals>.<genexpr>)r� r2 r1 r0 r� rV rV rW r� � s 427 428 �zFormat._get_fill_keyc 429 C s4 d� dd� | j| j| j| j| j| j| jfD ��}|S )Nr� c s r� r� r� r� rV rV rW r� � r� z,Format._get_alignment_key.<locals>.<genexpr>)r� r+ r- rF r/ r, rG rI r� rV rV rW r� � s 430 431 � zFormat._get_alignment_keyc C sN | j d ur| j S | �� }|| jv r| j| S dt| j� }|| j|< || _ |S )Nr )r r� r �len�rP rR �indexrV rV rW � _get_xf_index� s 432 433 434 435 zFormat._get_xf_indexc C sJ | j d ur| j S | �� }|| jv r| j| S t| j�}|| j|< || _ |S r� )r r� r r� r� rV rV rW �_get_dxf_index� s 436 437 438 439 440 zFormat._get_dxf_indexc C sx i dd�dd�dd�dd�d d 441 �d d �d d�dd�dd�dd�dd�dd�dd�dd�d d �d d �}||v r:|| }|S ) N�blackz#000000�bluez#0000FF�brownz#800000�cyanz#00FFFF�grayz#808080�greenz#008000�limez#00FF00�magentaz#FF00FF�navyz#000080�orangez#FF6600�pink�purplez#800080�redz#FF0000�silverz#C0C0C0�whitez#FFFFFF�yellowz#FFFF00rV )rP r� � named_colorsrV rV rW rb � sH �������� � 442 � � � ����zFormat._get_color)NNN)r )T)r r� )r )J�__name__� 443 __module__� __qualname__�__doc__r r[ r^ rd rf rg rh ri rj rk rl rm rn ro r r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r| r} r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� rb � __classcell__rV rV rT rW r s� ^ 444 445 446 447 448 449 450 451 452 453 454 3 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 T r N)� r �warningsr � XMLwriterr rV rV rV rW �<module> s