
    %
i                         d dl Z d dlZd dlZd dlZd dlZd dlmZ d dlmZ d Z	d Z
d Zd Zd Zd	 Zed
k    r% e              e              ej                     dS dS )    Ngencache)
CheckCleanc                     	 t           j                            d          } | j        r t	          d           t          |            nt	          d           t           j        j                            d          }t          |           d }t	          d           t           j        j                            d          }|	                                }|
                                }t           j        j                            ||d d          }t           j        j                            ||          }d x}x}x}}t          |           n:# t          $ r-}t	          d|           t          j                     Y d }~nd }~ww xY wt	          d           	 dd	lm}  |j        d
          }t          |           d S # t          $ r.}t	          d|           t          j                     Y d }~d S d }~ww xY w)Nz
Word.Basicz Starting Word 7 for dynamic testz Starting Word 8 for dynamic testzWord.Applicationz)Starting Word 8 for non-lazy dynamic testr   zWord dynamic tests failedz"Starting MSWord for generated testr   zWord.Application.8zWord generated tests failed)win32comclientDispatchFileNewprint	TestWord7dynamic	TestWord8_GetGoodDispatchGetTypeInfoGetTypeAttrbuildDispatchItem	CDispatch	Exception	traceback	print_excwin32com.clientr   EnsureDispatch)word7worddispatchtypeinfoattrolereprer   s           C:\Users\Dell Inspiron 16\Desktop\tws\AgrotaPowerBi\back-agrota-powerbi\mcp-client-agrota\venv\Lib\site-packages\win32com/test/testMSOffice.pyTestWordr"      s   ((66= 	4555e 4555?*334FGGDdOOOD=>>>.??@RSSH++--H''))Do+884qQQG?*44XwGGD377H7x7$dOOO   )1--- 

.///,,,,,,&x&';<<$   +Q///s0   EE 
F#E==F%F< <
G4#G//G4c                 8   |                                   |                                 s|                     d           t          d          D ]7}|                     |dz   |dz              |                     d|z             8|                     d           d S )NAppShow      )ColorPointszHello from Python %d
   )r
   r$   _proc_range
FormatFontInsert	FileClose)r   is     r!   r   r   :   s    LLNNN<<>> I2YY 2 2a!eAF333,q01111NN1    c                    d| _         | j                                        }|                                }t	          d          D ]}|                    d|dz    d           |j        }t          | j        	                    d          d                   dk    rAt          |          D ]0\  }}|dz   |j        j        _        dd	|z  z   |j        j        _        1nNt	          t          |                    D ]1} ||dz             }|dz   |j        _        dd	|z  z   |j        _        2|                    d
           |                                  t#          j        d           d S )Nr&   
   zHello from Python 
.r      r%      F)SaveChangesi  )Visible	DocumentsAddRanger+   InsertAfter
ParagraphsintVersionsplit	enumerateFont
ColorIndexSizelenCloseQuitwin32apiSleep)r   docwranger/   parasps         r!   r   r   G   sc   DL
.



CYY[[F2YY ; ;9A999::::NE
4<c""1%&&",,e$$ 	- 	-DAq&'!eAGL# "a!eAGL	- s5zz"" 	' 	'Aa!eA !AAFA,AFKKII%I   IIKKKN4r0   c                  P    	 dd l } d S # t          $ r t          d           Y d S w xY w)Nr   zCan not do old style test)$win32com.test.Generated4Test.msword8ImportErrorr   )r   s    r!   TestWord8OldStylerQ   `   sL    +333333 + + +)******+s    %%c                    d| _         | j         r
J d            d| _         | j         s
J d            | j                                         d|                     d          _        d|                     d          _        d	|                     d
          _        t          d          D ]&}d|z  |                     |dz   |dz             _        '|                     d          j        dk    s
J d            |                     d          j        dk    s
J d            |                     d          j        dk    s
J d            |                     d          j        dk    s
J d            d|                     d          _        |                     d          j        dk    s
J d            d|                     dd          _        d|                     dd          _        dd l}d|                     d d          _        t          j
        |                                          |                     d d          _        d!|                     d d          _        |                     d"          j                                         |                     d                              d           |                                  d S )#Nr   zVisible property is true.r&   zVisible property not true.r&   r)      zA1:C1xyzzA2:C2)321zA3:C3   zHi %dA1Hi 0zSingle cell range failedzA1:B1))r^   r)   z!flat-horizontal cell range failedzA1:A2))r^   )rV   zflat-vertical cell range failedzA1:C3))r^   r)   rT   )rV   zHi 1rX   )rT   r)   zHi 2zsquare cell range failed))rT   r)   r&   rU   rS   zRange was not what I set it to!z
Excel time   z=Now()r)   zPython time   zd/mm/yy h:mmzA:B)r8   	Workbooksr:   r;   Valuer+   CellsFormulatime	pythoncomMakeTimeNumberFormatColumnsEntireColumnAutoFitrF   rG   )xlr/   re   s      r!   	TextExcelrm   g   s   BJz66666>BJ:33333:L'BHHW-BHHW-BHHW2YY 3 3'.{QA$$88D>>6)))+E)))88G"n444+ 544 88G" '    )   88G" '    "	   FBHHW88G" '    )	   (BHHQNN%BHHQNNKKK(BHHQNN$-diikk::BHHQNN"0BHHQNNJJu"**,,,LLOO!GGIIIIIr0   c                  |   t                       	 t          d           t          j        j                            d          } t          |            n<# t          $ r/}d}t          d|           t          j	                     Y d }~nd }~ww xY w	 t          d           t          j        dddd	d
          }t          j                            d          } t          |            d S # t          $ r t          d           Y d S t          $ r.}t          d|           t          j	                     Y d }~d S d }~ww xY w)Nz"Starting Excel for Dynamic test...zExcel.ApplicationFzExcel tests failedz0Starting Excel 8 for generated excel8.py test...z&{00020813-0000-0000-C000-000000000046}r   r&   r)   T)
bForDemandz/Could not import the generated Excel 97 wrapperzGenerated Excel tests failed)r"   r   r   r   r   r	   rm   r   r   r   r   EnsureModulerP   )rl   r    workedmods       r!   TestAllrs      ss   JJJ2333_$--.ABB"   "A&&&
@AAA#4aA$
 
 
 _%%&9::" A A A?@@@@@@   ,a000s7   AA 
B%BBAC( (D;	D;#D66D;__main__)r   rf   rH   r   win32com.client.dynamicr   r   win32com.test.utilr   r"   r   r   rQ   rm   rs   __name__CoUninitialize r0   r!   <module>rz      s                  $ $ $ $ $ $ ) ) ) ) ) )$ $ $N
 
 
  2+ + +1 1 1h  4 zGIIIJLLLI r0   