From 3de0fe398c4aa134866362d7f0b79a7cf7f4ce61 Mon Sep 17 00:00:00 2001 From: Vincent Vanwaelscappel Date: Thu, 21 Jan 2021 17:25:51 +0100 Subject: [PATCH] wip #4164 @1.5 --- WearParts/_doc/data.xlsx | Bin 0 -> 16077 bytes WearParts/tools/convertclientdata.php | 58 +++++++++++++++++++++++++- 2 files changed, 57 insertions(+), 1 deletion(-) create mode 100644 WearParts/_doc/data.xlsx diff --git a/WearParts/_doc/data.xlsx b/WearParts/_doc/data.xlsx new file mode 100644 index 0000000000000000000000000000000000000000..2766eee205eac9fc7048282d50c12eac93260404 GIT binary patch literal 16077 zcmeIZgVRA-KES@8s_8d+*-e_b>SF z@cEoMhnae&y85Z=uAVMsIdBLJ5GW8B5D*Yj5Yw}4YeP^FkOT-25Ofe2Fg-Cx2R91` zHzRd#Cks~tCNFycNdW{HO&$ms@c#cD|A#G5kusv#&w?UxFa096!zjC2Ck(@J8Zv-J zry|(%J^5#unO=^K&3jJdGm2D^S+Tu0>|{x*ZMJ%v7NYeVa6c)iUi0})N;yNcyu_*I!yTaDIKwbkV*O|Hw8 zriE?J*bHo)B|M=MX>EK1s=bSgNP!)%?pxGNneNX7JNj-veLtUWnz-m2<)=1IOlu=X zy&U0S(vayz5M{gQ2CT{t4io<0g)j@{M=ttE)}AT1&gMVpy zMUsM2KMO+mx%5lK;QicM0*a`dr-*brsd_+=%qntYY#{~yS~oQTiaK5>xKvIF3496G{i&d{Zu(FKIwz`jS{Yu`%$0YPJdqi=kXn3* zDD;U({$%L{cm%damnG)StM^-}_T&~f@{Tq&g`_FV* zmxcR|Nk$s%7LiZ0zAQT~L+G4IG8!x#O}-WVtF`KFy?J7+l)-oWg5d3Zbv*se~;WpyP|_= zpTX%srgg$xamwrmr^gIP(D3Ski#PuM%#H_YGp8F#;zcZeOwjV^_Um;IaxEYCpm!NcX)cGhC+G1-?>=eI7RRLmy*g z7U=#syn1o#_p>xZ)#B!b^z+cmN6teV(w7Kc8`D>h-pg?P>o-oA9uO9V(3;2KE&LxzD%@4TXP-2)Feg zms>eWepDf|v8eNJV|0rN9T$=pI;d(yVJ`FXDZ1P_B_0@e44=OP5H`i0=G0dT!u2yv zIsBBMYi9L$G2DP|CPK#l&eYuK{ZlPDxarBzX|dhJ?=z^?G~y{$O3*IWwpNxTVhJmM z9HF7Ji%~*ZCQU-Q6@~5ALP*URCSFtak#y)hxo>PnQPH^hvxVsOcU!{ZC*ydpfNsGl z&bwYCAXWd9%)x>wY1hCjZ9qcffxv(Q$^4I?|5r-?YXATR&c}c*@qhcMP*sro&Vtej z{}#dGndyOvy5z=8cA{~N3^UX~yFx|E7I3qHPuFIkJuk-$?ilWUJ~rTS&w=y{9R0SJ zzBCFA!Ur92&Ijo@c0C3TV|rRi6e0zQj&^c%Tz(3Vl;MirDws6Lkb}X!_dr958&OzH zCVta89nNk$&f@;T)^(C_7#ILY8g_!7!qiSGLmHZ!Nit|Hci&sZR_>s3L%fNnu5n>y z_z}H9rVeIF=^uI}?qIGuUMv;7$L)FxpAdEl%H@d4I0XE{-AEz^rHBJ*lU#QTzO-wc zZ@Gy+57Tz9TrrH?oLlY;4a{u-d-^{q!>1snh>8aSa?t?-f&;wcpYhMt+QP!kmHCeo z>+e9Am2KdP&*verq4xPbZ~D3MyOIpkikg`XgBqv(oOu%e^>9OFThf8@&1 z1m~S$tfUPcTdhCmxCj^aRF8w(_1wl=M>pSte``R8fk1~KK?k=Wzqa6NMc1mJpRfNz z?z_+Z$l+G+w&mr8g>$oyc9-Cb-J{n-GuQi@WA&SMWuWg%m%am%Xn4fHLc|7FCNXn- z9Fb!e^Eq}rv!+lgGU=6jW0w)2&uC#IjwrAqEt>h;)a%;R#eNg z)6?yprFU)Hqj$I8A|SaU%`;lz;C=gkg*aYm>CDk~dX0I$`}O5=WbEioO8WBnbnSGn zI_2hK^KEbUWToG>^Wm0>;669>^4H$xg!@Cc$;0`2h=26bL-^UQ(k0p9)( z-2-ER0kH3ZDDV4T??Oto?|gpOM5-)^xnaSbB zlkUOce|dF)Y=gFZp3Bp)avkgWDHa-*Vgmjk@DTWM)JT>dwUjd?{5gsT=wJTge4{jRhFm` zWm3+1PzR7$-7`w>P*6WmL}wkt50aI<5R)Xby(3Xvf$E2d3r5_NB*vRTp*^Zs>3_hm z777v{KO0afFnDt(!aEa8$j>@e(or72-e;h(dT67a51vd%;XQrn6C%aPyd~L5%J-|= zCrMPg1B0U#B~b|zE`SLZM-4eUY9^$3`U)LM27xAForQuXyO(dmC90#0Ivf%;*|caJ zs9CQ<)AOrPSxB^22U(Pf^|z!5sRRr~6beRC?-p7ejVKfDP=pY8q~C+qB=+wMlN6*B zB%@;e4q_W&--v39-(8OTs z25SOA(If^b!-3NO1gRSZD%xsZQHUaqk)IrvfWnWA*#5g!%2?`QO+R$S9Kw~|5CFVu zfuzx6J}54cq!2n7q`%c+4a;MWLNQkf)Bli~?+LZ05k?aI+dKzAMOyd&Y98(A8-)D& zzvw~p+qC+oz~?gTU!YN_9tcR^h(e(Ojp9QJ9+{OEZv{(g!~JiHP!ZDCiD-8VS>ec@ z`jCLdsz7AaBA{Ta%khB4218`b+sM=x%N@lRhK)$+qqt2H22t8y;Z-t(EaNx6yVJ!*)$9C=3#;n{A!P3Or@!) z8YXUHIl;VZv&4@L>uN-u2BO~P9qnMTY8ob<5&V(%935tFgc@qNk%GG_Jh{2`2a~14 zA3Vp(2cN4%;N=b7nYInITIG3l6Qnxj2H8F|&>=VtvZ-%_u!FlJ39~iIkr1SfmFsU? zw_4J@KH@wjPpXph-_-|cVsSJ?8G7Y-zc&tNg?a6-7N2lfYo!08ZI-vUpAF$Zq7o*O zD(}N7c^icBhRvvD1n-ABx|@N{MX=z^xFen|} zuEm%fE(q70;+y#3iHEq8zmTV4Qh@wh@1Ij;7gPDE)v)=g`H=pc4Z>#DB8+126)s}% zwz#@_(R%x_*ItTn))p#atqzeYk#qib;t%CH(TjbtsxZn%sjGR zar!Om{TL+{d$kJR&v|U$wJab^wLPbkE)N({*k;%0)a6jgV$ZZd$G+{fLd1@J6J}El z^T;3+RW|_spWw$po(vm}`?T2#FsPK0rbuDt7n?31c9HTNViqdfE<_}>_rxXGDI$_O z4I$>kQ4>D-(UFf*T94)w@Y_N+Xh9%-+$JIsOf+0G9SNwI0x z2YJAPZ$PF{Z{YA{Q5*8L7T&l%U(et=y&FUWi=(uzR77K4R8YLT1FQ_Ln}7EVsB+fQ zcY+QlU>I10L}BM-^^8>--CA^qCn9*3&Zg!Sg2KF6Dn1&+a^#`@HxzY2@si&tCI3V@ zG~^%LP80gWELy&sXXV+jug?7-FWr}y6ab6YRmsLj=2dVa2-&k+D_CA$Nm%ea7Y+D z{7PXn{otQ11-iVtDntgLNs_Gv*M<61k5i0HBFRj_M+E~-Yx)){`*e;K`W%$)Ik-gm zv4$d_@w+&6zpe@_2v2frU~=;AIG6Pdrp~y-dIOq(EdooDObc=gh@oSdzs1A3q9~iy z{vC1urHibGKDg9`+q_zPSM9KY32}K3>cS!K>{V@9pH2k7RT~sUtlDm)WE)h`b>WQr z5UiS(eu`E43hT?O`-jpyRPG$lMcX?YF|p$obVK{Y>i3xXM~_PQi0Ezu)* z(Cnp&93}YSr6mk{CozxYYHKa@7gD0?b#2n?1p+`Dxvx z6{KO(RI=JuZ7}bqE?!H@B*9->@ ziI9ZTe7x!-gUe5wPxDjW06j7wiq2_G@@+$Pr`@FJ^=rj~8;(}`c^>Y8&dKE& zJ27_H18{hwST=)*Fu`g4$=Mxtolz{O>P$4@30uf;g45U^m)I#o#Wp=)U8H5KZc+rK z!1v_2A)Zf?1+65pCJ^gQCJ=EACOdepe3v}{qPG<5c+@Pm{y`2)hwv*{@-Mz)X3erV z7A6CwgdQ;&gqH?|s9*L%;bQ3YuUXS)1@VFhizV||fj?c361ut|*&Q528DA|*mzbuA z$hob;6YcyQ8g9#P=d7-^Yr|Bqh?X(h4-z9*hXmJN@pRwR#Hczp z907^RVHz-B!!#Sx`qiZk2c~#TISdPvlF|b=E)Kpx0p!>-xG1`qGg#a;-fpPGwJh>j z;3M6{hL%ebcAq5TR^fP(8 zyl+C!BUb`VWU~~te;kD>S<;Ep5Nf9#J zA7?KIu}jp1s(w?GYwLk3PISleR-o(6_E6N<4>cydKe11)Mh^m=+i{zYg#iani)_+!-5gAG9mtyF}6pzN3OHTfuW(j zi0)Fd%jXnF_O-OHubAIMAe3J+(JqUut_JdWsY=W@ijD!mjZjkhSgFv8F#&AbZwk`s zE|PlUfqW^Tee1A#*G^f!)gKeyHbeb1%26QBiv{Fzfv&BfDv`l?^3TzMY-=ghY_@EJ z&^`5qXOUzCw;7ymr|_TP#nADer04<2 z2Y?hpoG7Mq*y4sghao-p^dB9PD-zIS=RX`E1 zS>`|!Wz1ELi8_02W`@E1c8dIOP2^8f+Of%%%<285cW{F5?Ftj^2*?+>C3o1$uUn39 zhzjB0@h86U#*3tItHSefGC8M2#1TjbG!Pw~5gtB?7U~W0954@q12Epg}+CQb+6BHRtXbVJv@Q=N1IoqcsGf zOPsLz#D;1!BE?0aedS%zlB@cbshIn|^|7ha+z%k133g4kf$=nMn6I{E!mU<~uM-&m zf|riBQ9s?}Pr;Y&k*ILsC+M5|N*qkakYCl_W>d9``zFx&0cg%i>;)`dBaeZD7Z@!v zKF~u$)z_m1{EHK_mv4i`C7TrD_05IsKz?MA(^(R<4(=~iU3zo!EOC+uMBWi-a4)%; z+LueCeD!Y9U8;44E#e1|H1;E@UW;DE@x4$_+|;SH6D3HSk)wS=pqRvw)|M9mOALm< z1BZ=146&zP4i+ECx8y9Ihtxx%Oqd;ui-jkV(H0r*gHlzix9jx~b+{wxI;-&u(=OHv0i(3Jb@0zguzOwJn>b$c zWJi=Q*us$j%!mj_fOqrlP#to@;GT*I`VucH(|)aeWF znOjNez-C&kWPo-CjeG$+@b+7E8H;>d7jR!*R}GP}1jo)M$JMSPN$!VSOFf?-NTBYe z+$aIgjYEJl27T|vOc%f7qsdeYDU*@g9orn^)9nFG_j~SVVM1-E=Oz@ihb?|JMIZ3% z1%kk)n++uPQ7rqHdyX+5k2!kG%$}EiS*4(8qr@rypmVMZkd+UifvaE zaA_k+o`S^dY-bO(y~|Lae*b**r0B6=HFxP{TzWnPhTke|1}{Np$(1f*&dF~L7?=1l3!ND} z2*q@i&{pDQ4yT3kb*TgIy4D$#36@@e_rhJR!JU{Z(=EGzZR1@m`HTvjR_Itw;YQL;jtgo%x zryk!d5I1*MbH3}o_%zE$_93~!@n!Ylo2(;)0#8w)H4IMn)t=yLgIcf?`cZYv` ztS%q3bbr5TJ|Fp!mhvFs1m9iNr}Igp&q#E=P)PH5WBSnh`u)GYMtU~=YVQhsgjl4bq8@lH&>|MmO@JCyAS*8Fdprw0qQIZDyqcK7~UBkxgW( zwpxMkw2VLg@^%ntf161fX!|J(fPNCJ-7S|&FQO9s3G+^RxCv)QVH#?&dv8*AHvatG z*Dt=!=Tu~Pk`y)RssdA;Sqn_OE;v)oIJ zl7bTE&dLS6IYj)MpP7Y3cumZ%MNTrpI%2DIZHN?VwKy0t=vqo;g(h9>XN(yJVO+)F zlhdt)aEM!uA!AqBj*(4PHC5&?c>?R{?@J~%Q>A67E@XW2d19lwpcj!3D!Kg1pr+b% zUQ=*%d(7HP9c>|8Q3~>mOM1%-Y=J+zOvTuBIrt^`(^)I;Y{%$V*q)$zX345nPCeS@ za0S47Okgr}b%xpPI&W=#W$Pj8gs^Qq>277mexw~#GY+l-npbWuNuw!kh3~BFLAwoY zW}7q#J3w{({6UTE9Nl>lp&f;>Hne;0tJv{5upNbA3zw`xD+!m6F=wq3NUit`A9#Bf z=pp^$Lafsz(kxkbzUX4v(RNKpAcNoy))e5XCTAfy!>FwG9tta0;BF#@$T^;<(qN~u zGgF9(xX!@|j6!LLr`R2wZ|J?&HA3|*8Y3#skKNI9d}PpG@Q8wYtn zuV-r}=@aftQ2ke678JRCHUr;Fh{s1Z1}@%>3m?y1jefSb9frutssSb2ruI!Oqq7RY z2Iu~4u#}TyrswqOG0AFQyw))M89VjBo`3uf#{9=G)Y~f2?()grz%Ehdk=^L(k!w{1 z4WD(p%yB-0WiMn}GicksK?NHhM_6d(*-!~KjPxNV&QH6rFAU3m(Ae;RJCfcxDRoL{ z*ztVF>I~KosgQ@-1zB?G*kg6L)lc)g&IzeKel~weh{Lyy_ykpJZDuSujO} zdTz6tn!IDm%D_s3MssI}Jv0h=7#jHPQpcrrT2fcoh~d0E%r@>>=FHgUQ?xo)^Mrd)-YE z@f4Wpni?)+mrgM!7@L^qMD$G@r4HI+NPL6#d)bdA3z@o*gvipQmJiLQ$b+ON{s!Rq zPXJ_PuzZIy85JmmGxL|$2?;1f)3u!!H9q3Z(S3VlH&0_dhW7WEPU%YZ8#yVF8Q;4v zIkuWehORZa*QJe^b|TwzPhaAf37C=+-k`^Y=tM1rybiz{C+_o`$Q}YrR_GyA{D(M+ zq_L&-h@dCAmn87zGg9oeqt5R7R%lvwnRwT5jRvQ=4&5efPIO%N>ReqeZ`bx8V+^zx zYu#ICZqxCS?#!c(?yPwSaR$FsA! zW(NM(tzO0ytx(m#oiX0PaSHJtW0b3#H^9R6kBwd$Lk=szjUddDHtP-h%zDs zQo=zEX)VIl4dO%MEie?>gN#q-gtCShMF&X_#^VS>T#i_A)8&eAH{WA+buGBtU|3Dd zW-+xC!n>=Yjl&b&)iu6sa6!i0r;vZ2`mAq zzE*h#|$oQ(vtN*XoC3slcjLQTO`azlO;PEV9w=&f^S4XZs93aEgl!X)!EHcmo) zu}t17fO*d4qNiJOIthpCVqL|L^mNr`=y4`hR5Xi64(I=P#BHe#3dcKm><{m*GARu% zA9%)Gf-iQjk`=?0ux^s$(C{tKd18x5!JAI|G^liIY`$8t`J#JjT*Udh;a9^{6dds| zhzlA?Rub&xX6CcrD_DDZ;_{GaTRUCD7#%yWaO+2L17nAxgOr?>c?Rp&iRsUCe71B*%cbz3+U*;zILzEmP(ukfUg> zFx$d!TY!-Z>DGJ1m2N4phJn@nOZE=M0u~ykewuXoLxyw(=Hxu-0xyni2FGMFTxX?q zZUs>^iGKa7o#c<(Nw8IM8r*vUfR8t!PZ1=3H2#!>kC}<@K>q&cCZ5|XFwzqstDUGo zKrsHvY-8AyWA;1o=el+A17k&F>LqaS2>T$$}| zgqvCWaj-~M#XhU~wJ@MRU^rk1iFT#VJJFo_5Npw2Mm+JC1-I+oXbkekx{~P4=L>G* zo6`BkOS?~#p!iU3ZtCr4+4kMv^0ke5zmpd3lyXu!pPo85y5J0e^)|B$mc@Sj6mZ$$ z#X^Nna9;CC`JmOpF9eePaWI-(@q&d2os24f;pSDqF$7#!3_MjC^!N!n7Ejjtf|B%f zsl0P-`O<`dfH-Pfj#u8aw?eL4q+m)}*7Gks=vC$^ju^FU4(l7e2U;*?7_vx9sM%;eOwNBOBbb zJQSE>5%G3R0%@DE3Iv@>SD zbJsk`r47vfHzUd~QE`*Uj2p`{KEX#Neotk(-aH|}3QK3`CaYB$KR2%QO5gC&Vd&>x zWjFb5UGN|EVjJMac@0h-gViFFH&W1+Q z-?%Cfp!W8f6K&jwf`ZkOni_LHGtO4%+ThCOHB@XV_mnize49|PaDpcvs!-Vwv&D0n zFt!ZGWbg4P3YLCmwKvB-rz}u`e{l0+QJG%VuEF)wpbs*UE=UQ8qB>y}00k^I^v;>7 z)3=A?;?Gyr)HH^H4Zjf5Bm_!hGwlNw#fhH-5O_vaV8p)?Z9F(tUr34WAsMH<^-dEB zyKw#(3qEVaI90*vLcWK;FKa5TnQsyP_VwdJMOf*kAJpkl$O0Bw1%(A|ejs$7?-}=Q zy zJ!oGkU&G)~RizyaFZ7j55!*^v(#o@M?@-u|Gy48rn(%Z8Q~TiusH2pv@3_SNNX2cU zJdEP?APvN0Yc907t6l3GmRZ!~Br5%sq88#NuegP_xwvj+yX43m3|$PjBtLE(V6|_1 zpBdAAJvVNWc?We-5jGJ8xpa=eL;`346?Qnhg6&%tA}Iz;vTQ!dHPWo@H1lvq!3x|A z$oz!zrdQdG1?rv;kIYgT5}KW&8kDE?NmS6#tgHL-8pAG>Y^HQ08czZ}Mp}OE8Jj3F z=VFXDUpgjlp&wSSq?jgODY?fH?+8`e*l4^&k!>Ks*1~;#9x{^QpL%78e9wvp3jp~A zbIle*SYBXnG%E(uD{GkhM!XA;g2>uk!({sSiq-vnv=qcYaMZ}3jYGFTP&C~{61F`c zST+|=&`Iz_OXSBN+)qb8y!4LdzIE7kTQb!T677i|WTh`Z$a{Y;flJ6rdg!Scts*N0 z9fWA^6nLC>4;OqoO9zFc$R0^ASf~-Un zwAA(mW<8r66XSi=?9rAXP4J<4mck|Zl?wGeSeat?w}IK9`2_=iczoBp4gg75w$7D; zk#kPU%*Oiwg0u#JH6;=?eSC7WJeTBF&03*7wP8<*z?DDF&mKf}ICMXZ4C=U3(%~S< ztvQ{_YPTWw_W4^q9scLTg^zU5ZdFOtAdvq0nNIw$P_6FU;J6(kYb}T$x0?!GPR6LF z_nWnjS9f}K>9jHQud*UE9R_K^4sfZ{`QVxh-Ds0FOqoO+$V2^yxO-?F_jH4B?VlTAKI#7A6?`T_Jt!ZPBO~fW+ z{vnyAal;t+O31`|Ol-+X)DXeFL7k&jz)wm9>h4pFW^yblgd{aqzJy-&{$EoV3*v?4 zG~g9}AeB-6N@Wu#r~fe-Na24TS;@V?Yz|o01b&AUeiobMKoc&k$y$W(qg@Lk)6Pac zQ>(0lMlmmacT;Fj;l7;hLH>x|EtJ^MCg4_ez-oc-N0}O}igBP&TDhV1%lZEGD4OO& zaCI+a{AX@ctmda}=tdb*Q?lq*WB6S9DYPG-QdMeuvH@r*&Jm|MWf<`907eKl5q<6&3#2 z1ujXu>9I2pO{=8Ij;l3tY&wnoYy(YG8CnQwlfnsa0?n+`6sYuJ$52f?B_>*FqzMrF z30i_CKmnhFV`rV2#OlGSHr*}iGtNk6LD_0T7q`{nNwhNI!^7$1w8V`gPr{&2cE-Rn zDwK&x@dSP8qR9V2zQYk`gEX#sFTS%j5Cqv*o*}Ey{ebLY8$f)VU@EaCh>}AUsH47ug*M+&acwyc={_N*$48upUtlz6l%E6FswwG+fz}z zbG&ri4eXYGWG$dzjKB=#zZVYwtMmSK{x4<3%5wh>@b4v#{}TLtP6K+#UkV=oF8KGd zuRldQfO*v4iopIZ{O@Hpe~N;DM8f_d{QpyQ^LL!T*IxXI)B*qhDe)hb7=K6k`_lWL zDB!?!5ZIKzFU0>H;P2}qe*%;+`~mRiD#_nP|DJgMDH_cD57ED;p?^pC_rdv3c@U6X tP7sj)7^?p+{_g?tui~~me-Zy@cvO~y1okcn2psS)2$)H8@&Eqy{{YLbN5cRB literal 0 HcmV?d00001 diff --git a/WearParts/tools/convertclientdata.php b/WearParts/tools/convertclientdata.php index 18292fd..522a43d 100644 --- a/WearParts/tools/convertclientdata.php +++ b/WearParts/tools/convertclientdata.php @@ -1,2 +1,58 @@ load(__DIR__ . '/../_doc/client.xlsx'); +$res = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); +$wsr = $res->getActiveSheet(); +$ws = $xls->getActiveSheet(); + +$questionByCol = []; +$answerByCol = []; + +foreach ($ws->getColumnIterator('F') as $col) { + $colIndex = Coordinate::columnIndexFromString($col->getColumnIndex()); + $questionByCol[$colIndex] = $ws->getCellByColumnAndRow($colIndex, 1)->getValue(); + $answerByCol[$colIndex] = str_replace("\n", ' ', $ws->getCellByColumnAndRow($colIndex, 2)->getValue()); +} + +print_r($questionByCol); +print_r($answerByCol); + +foreach ($ws->getRowIterator(3) as $row) { + $questions = []; + foreach ($row->getCellIterator('F') as $cell) { + $colIndex = Coordinate::columnIndexFromString($cell->getColumn()); + $question = $questionByCol[$colIndex]; + if (!isset($questions[$question])) { + $questions[$question] = []; + } + if ($cell->getValue() == 'Y') { + $questions[$question][] = $answerByCol[$colIndex]; + } + } + + $rcol = 1; + foreach ($questions as $question => $answers) { + $wsr->getCellByColumnAndRow($rcol, $row->getRowIndex())->setValue(implode("\n", $answers)); + $wsr->getStyleByColumnAndRow($rcol, $row->getRowIndex())->getAlignment()->setWrapText(true); + $rcol++; + } + foreach ($row->getCellIterator('A', 'E') as $cell) { + $wsr->getCellByColumnAndRow($rcol, $row->getRowIndex())->setValue($cell->getValue()); + + $rcol++; + } +} +$rcol = 1; +foreach ($questions as $question => $answers) { + $wsr->getCellByColumnAndRow($rcol, 2)->setValue($question); + $rcol++; +} + +$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($res); +$writer->save(__DIR__ . '/../_doc/data.xlsx'); \ No newline at end of file -- 2.39.5