j$ SrSSKrSSKrSSKrSSKrSrSrS"SjrS#SjrS#Sjr S"Sjr S$S jr S S S S SS.S SS.SSS.S.S/S.S.SSS S SS.S SS.SSS.S.SS/S.S./r S%Sjr S r\S!:Xa\"5 gg)&aServer MCP pentru citit fisiere Office: Excel (.xlsx), Word (.docx), PowerPoint (.pptx). Doar citire. Doua unelte, ca sa nu umple contextul: serverele gata facute au 29 de unelte (8360 de tokene, ~33 s de prefill in plus la FIECARE cerere), din care 13 de scriere. Astea doua acopera citirea si cautarea. Dependintele sunt declarate mai sus in stil PEP 723: `uv run office_mcp.py` le instaleaza si le pastreaza in cache singur, fara mediu virtual de intretinut. Ni`c lUVVs/sHCoVs/sH3nUcSO [U5RSS5RSS5PM5 snPME nnnUVs/sHn[SU55(dMUPM nnU(dg[SU55nUVs/sHoS/U[ U5- --PM nnS S R US 5-S -SS U--/nX@SSVs/sHnS S R U5-S -PM sn- nSR U5$s snfs snnfs snfs snfs snf)z tabel markdown. Prima linie devine antet.N|z\|  c3@# UHoR5v M g7fN)strip).0cs $/home/andrei/setup-srv/office_mcp.py _tabel_md..s(>AqAsc38# UHn[U5v M g7fr )len)r rs r rrs $GqCFFGsz| z | rz |z---|)strreplaceanymaxrjoin)randurirr nouts r _tabel_mdrs7&-.%,Ayc!f55c5AII$PST%, .!?'QS(>A(>%>q'G?  $G $$A0781B41s1v:&&G8 %**WQZ( (4 /vz1A BC =AD5::a= 4 ' ==C 99S>.?9 =s. D!:D D!D'6D'D,%!D1D!cTSSKnURUSSS9n/nURHnU(aXa:waMXFn/Sp[UR SS95H(upX:aSn OUR [ U 55 M* UR SU-5 UR [U5=(d S5 U (dMUR SU-5 M UR5 U(a*U(d#S U<S S RUR5<3$S RU5$) NrT) data_only read_onlyF) values_onlyz ## Foaia: %sz(goala)z_...taiat la %d randuri_zNu exista foaia 'z'. Foi disponibile: z,  ) openpyxl load_workbook sheetnames enumerate iter_rowsappendlistrcloser) calefoaie max_randurir"wpartinumesrtaiatirs r citeste_xlsxr3!stttDA E  T]  GUakkdk;CTYYq||E\]] ;;u c NSSKJn SSKJn SSKJn U"U5n/nUR RR5GHnURRS5(GaU"Xu5nURR5n U (dMPURR=(d SR5n U R!S5(aSSR#SU 55=(d S n UR%S ['[)U 5S -S 5-S -U -5 MU R!S5(aUR%SU -5 GMUR%U 5 GM'URRS5(dGMJU"Xu5n U R*SUV Vs/sH(oR,Vs/sHoRPM snPM* nn n[/U5nU(dGMUR%U5 GM SR#U5=(d S$s snfs snn f)Nr)Document)Table) Paragraphz}prheadingc3R# UHoR5(dMUv M g7fr )isdigit)r chs r rciteste_docx..IsBTrZZ\Ts' '1#rrtitlez# z}tblr!z(document gol))docxr6 docx.tabler7docx.text.paragraphr8elementbody iterchildrentagendswithtextr stylenamelower startswithrr'minintrowscellsr)r*r,r6r7r8dr.copilptstilniveltbrr rmds r citeste_docxr[9s -A E,,. 99  d # #%#A AGGLL&B--/Dy))BTBBIc S3s5zA~q#99C?!CD)) TAX& Q YY   ' 'uB:<'',;:OP:OQ010:OGP7#Br R '/( ;;u  1!11 1Ps%H!8H H!H!c SSKJn U"U5n/n[URS5GHupVSU-/nURHnUR (auUR RSUV V s/sH(oRV s/sHoRPM sn PM* n n n [U 5n U (aURU 5 MMUR(dMSRSURR55n U R!5(dMURU 5 M UR"(aRUR$R&R=(d SR!5nU(aURSU-5 URS RU55 GM S RU5=(d S $s sn fs sn n f) Nr) Presentationrz ## Slide %drc3z# UH1oRR5(dM#URv M3 g7fr )rJr )r xs r rciteste_pptx..es"X.Efaff.Es";;rz_Note vorbitor:_ r!z(prezentare goala))pptxr]r%slidesshapes has_tabletablerQrRrJrr'has_text_framer text_frame paragraphsr has_notes_slide notes_slidenotes_text_frame)r*r,r]rUr.r2slbucfrr rrZrVrs r citeste_pptxroXsY!TA E188Q'q !A{{>?ggllXY>XGG4GqFFG4>XYw'JJrN!!!IIXall.E.EXX7799JJqM   0055;BBDA .23 V[[%&!(" ;;u  5!555Ys/G GG G c [RRU5n[RRU5(dSU-$[RR U5SR 5nUS;a [ XU5nOBUS:Xa [X5nO0US:Xa [X5nOUS;aSU<SU<S U<S U<S 3 $S U-$S[RRU5-n[U5[:aUS[S[--nXd-$![a+nS U<S[U5R<SU<3sSnA$SnAff=f)NzFisierul nu exista: %sr)z.xlsxz.xlsmz.docxz.pptx)z.xlsz.docz.pptzFormat vechi (z$), neacceptat. Salveaza fisierul ca zDx sau converteste-l cu LibreOffice: soffice --headless --convert-to zx ""z5Extensie neacceptata: %s (accept .xlsx, .docx, .pptx)zNu am putut citi : z# %s zh _...iesire taiata la %d caractere. Cere o foaie anume cu parametrul `foaie`, sau scade `max_randuri`._)ospath expanduserexistssplitextrMr3r[ro Exceptiontype__name__basenamerMAX)r*r+r,extrJeantets r citesterps8 77  d #D 77>>$  '$.. ''  4  # ) ) +CK $ $[9D G^2D G^2D , ,Cd, - KSP P ))$/ /E 4y3DSzOQTUU < K04d1g6F6FJJKs6:D DD1D D E% E E Ec h[RRU5n[RRU5(dSU-$/nSH]n[ SUS-5HGnU[ R "[RR "U/S/US- -QSU-P765- nMI M_ [[U55nUR5/pvUSSHn[USS 9n U R5V s/sH(oU R5;dMU R5PM* n n U (dMYURS U[U 5S R S U SS 554-5 M U(dSU[U5U4-$S[U5[U5SR U54-$s sn f)z:Cauta un text in toate fisierele Office dintr-un director.zNu e un director: %s)xlsxxlsmrBrar*z*.Ni)r,z**%s** (%d potriviri) %src32# UH nSUSS-v M g7f)z - Nr)r ls r rcauta..s(M9a!DS')99sz-Nimic pentru '%s' in %d fisiere Office din %szGasit in %d din %d fisiere: %sr!)rsrtruisdirrangeglobrsortedsetrMr splitlinesr r'r) directorrJadancimetinter}ajosgasiterncontinutrliniis r cautarsww!!(+H 77== " "%00 E/q(Q,'A TYYrww||HUQU$QT*UV VE(0 3u: E**, 4C[1$/$,$7$7$9N$9qAGGI=M$9N 5 MM53u:tyy(M5!9(MM9OO P  >$E T\A]]] .#f+s5z6;;W]K^1_ __ Os 7F/F/rzCiteste un fisier Office (.xlsx, .docx, .pptx) si il intoarce ca text markdown: foile si celulele din Excel, paragrafele SI TABELELE din Word, slide-urile si notele din PowerPoint.objectstringzcalea catre fisier)ry descriptionz&doar la Excel: numele unei singure foiintegerz0limita de randuri per foaie/tabel (implicit 500))r*r+r,r*)ry propertiesrequired)rLr inputSchemarzvCauta un text in toate fisierele Office dintr-un director (recursiv). Intoarce fisierele si liniile care se potrivesc.zdirectorul in care se cautaz*textul cautat, fara diferenta de majusculez+cate niveluri de subdirectoare (implicit 3))rrJrrrJcSUS.nUbX#S'OXS'[RR[R"U5S-5 [RR 5 g)Nz2.0)jsonrpciderrorresultr)sysstdoutwritejsondumpsflush)id_rezultateroarems r raspundersO%A ' ( JJTZZ]T)*JJr4c [RGHnUR5nU(dM[R"U5nUR S5UR S5p2US:Xa[USS00SSS.S .5 MrUS :Xa[US[05 MUS :XaUR S 05nUR S 5UR S05peUS:XaF[UR SS5UR S5[UR SS555nOSUS:XaG[UR SS5UR SS5[UR SS555nOSU-n[USSUS./05 GM{U(aURS5(aGMUcGM[US S!U-S".S#9 GM g![ a GMf=f![ a'nS[U5R<SU<3nSnANSnAff=f)$Nmethodr initializez 2024-11-05toolsofficez1.0)rLversion)protocolVersion capabilities serverInfoz tools/listz tools/callparamsrL argumentsrr*rr+r,rrrJrzunealta necunoscuta: %szeroare: rrcontent)ryrJznotifications/izmetoda necunoscuta: %s)codemessage)r)rstdinr rloadsrxgetrUNELTErrPrryrzrN) linier rrrUr/rrVr~s r mainrs    5!Ax!%%+3  Sl,3R=2:u)MO P,  S7F+ , , h#AeeFmQUU;%;! =9$fb 1155> #AEE-$= >@AW_aeeJ3QUU625F!!%% A"679A2D8A S9'B&CD E 1<< 011  _ S&=UXY=Y!Z [C    * =(,Q(8(8!< =s7GA G$A G1G GG H $HH __main__)Nr)r)r)NN)__doc__rrsrrr|rr3r[rorrrrrrzrr4r rs   02>608`.=&"3GH#4\]!*;mn6pX   H%&7TU"3_`'8ef6h!&) +, *"\J zFr4