ࡱ> ;o')>`CompObj<pi25&., n``@w@wfY "u !#}$%1'()*+,-./0234q6F89:;<=>?@ABCDE5GHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoprstvwxyz{|~ \pdexcon Ba= ThisWorkbook=h/:<X@"1Arial1Arial1Arial1Arial1Arial1Calibri1 Calibri1?Calibri14Calibri1>Calibri1Calibri1Calibri1Calibri1<Calibri1Calibri1h8Cambria1,8Calibri18Calibri18Calibri14Calibri1 Calibri1 Calibri3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "q*6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-k)3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_-,>_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-{+;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_-"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.0050_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-#,##0\ "DM";\-#,##0\ "DM"##,##0\ "DM";[Red]\-#,##0\ "DM"$#,##0.00\ "DM";\-#,##0.00\ "DM")$#,##0.00\ "DM";[Red]\-#,##0.00\ "DM">9_-* #,##0\ "DM"_-;\-* #,##0\ "DM"_-;_-* "-"\ "DM"_-;_-@_->9_-* #,##0\ _D_M_-;\-* #,##0\ _D_M_-;_-* "-"\ _D_M_-;_-@_-FA_-* #,##0.00\ "DM"_-;\-* #,##0.00\ "DM"_-;_-* "-"??\ "DM"_-;_-@_-FA_-* #,##0.00\ _D_M_-;\-* #,##0.00\ _D_M_-;_-* "-"??\ _D_M_-;_-@_-"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)61_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0 0.0% #,##0.0\ "DM" #,##0.0 #,##0\ "DM" 0.000                                                                           a>               P  P     `     ff  20% - Akzent1 20% - Akzent2 20% - Akzent3 20% - Akzent4 20% - Akzent5 20% - Akzent6 40% - Akzent1 40% - Akzent2 40% - Akzent3 40% - Akzent4 40% - Akzent5 40% - Akzent6 60% - Akzent1 60% - Akzent2 60% - Akzent3 60% - Akzent4 60% - Akzent5! 60% - Akzent6 "Akzent1 #Akzent2 $Akzent3 %Akzent4 &Akzent5 'Akzent6 (Ausgabe) Berechnung*+ ,Eingabe -Ergebnis.Erklrender Text/Gut 0Neutral 1Notiz2 3Schlecht4 berschrift5 berschrift 16 berschrift 27 berschrift 38 berschrift 49Verknpfte Zelle:;<Warnender Text=Zelle berprfen`1Working11" TabelleA;" TabelleB;%" TabelleC;)8" TabelleD;<K||>G}A} 00\);_(*ef;_(@_)-;}A} 00\);_(*ef;_(@_)-;}A} 00\);_(*ef;_(@_)-;}A} 00\);_(*ef;_(@_)-;}A} 00\);_(*ef;_(@_)-;}A} 00\);_(*ef ;_(@_)-;}A} 00\);_(*L;_(@_)-;}A} 00\);_(*L;_(@_)-;}A} 00\);_(*L;_(@_)-;}A} 00\);_(*L;_(@_)-;}A} 00\);_(*L;_(@_)-;}A} 00\);_(*L ;_(@_)-;}A} 00\);_(*23;_(@_)-;}A} 00\);_(*23;_(@_)-;}A} 00\);_(*23;_(@_)-;}A} 00\);_(*23;_(@_)-;}A}  00\);_(*23;_(@_)-;}A}! 00\);_(*23 ;_(@_)-;}A}" 00\);_(*;_(@_)-;}A}# 00\);_(*;_(@_)-;}A}$ 00\);_(*;_(@_)-;}A}% 00\);_(*;_(@_)-;}A}& 00\);_(*;_(@_)-;}A}' 00\);_(* ;_(@_)-;}}( ???00\);_(*;_(@_)-;???-;_-????\ _ ???@_-@ ???}}) }00\);_(*;_(@_)-;-;_-?\ _ @_-@ }}, ??v00\);_(*̙;_(@_)-;-;_-?\ _ @_-@ }U}- 00\);_(*;_(@_)-;-;_-}-}. 00\);_(*}A}/ a00\);_(*;_(@_)-;}A}0 e00\);_(*;_(@_)-;}x}100\);_(*;_(-; ?\ @_}A}3 00\);_(*;_(}-}4 00\);_(*}A}5 00\);_(*;_(}A}6 00\);_(*?;_(}A}7 00\);_(*23;_(}-}8 00\);_(*}A}9 }00\);_(*;_(}-}< 00\);_(*}}= 00\);_(*;_(???-; ????\  ???@_-@ ???M 20% - Akzent1 ef %M" 20% - Akzent2 ef %M& 20% - Akzent3 ef %M* 20% - Akzent4 ef %M. 20% - Akzent5 ef %M2 20% - Akzent6  ef %M 40% - Akzent1 L %M# 40% - Akzent2 L湸 %M' 40% - Akzent3 L %M+ 40% - Akzent4 L %M/ 40% - Akzent5 L %M3 40% - Akzent6  Lմ %M 60% - Akzent1 23 %M$ 60% - Akzent2 23ٗ %M( 60% - Akzent3 23֚ %M, 60% - Akzent4 23 %M0 60% - Akzent5 23 %M4 60% - Akzent6  23 %AAkzent1 O %A!Akzent2 PM %A%Akzent3 Y %A)Akzent4 d %A-Akzent5 K %A1Akzent6  F %yAusgabe  ???%????????? ??? Berechnung  }% $Dezimal, Dezimal [0]yEingabe ̙ ??v% SErgebnis %OOG5Erklrender Text %9Gut  a%ANeutral  e%d Notiz  $ProzentCSchlecht  %&Standard= berschrift I}%O berschrift 1 I}%OO berschrift 2 I}%?O berschrift 3 I}%23A berschrift 4 I}%UVerknpfte Zelle }%$Whrung, Whrung [0]C Warnender Text %Zelle berprfen  %????????? ???XTableStyleMedium9PivotStyleLight16ccB4c =_MA  2  dMbP?_*+%&?'?(?)?"??U >@$ 7 Working&ggD ThisWorkbook&@__SRP_2D__SRP_3  Working%  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~rU 0a 9  a4 a) ` W`,x$ Hlxcx&,$ x0 @  0  4H"!@!B.2 2%D.6 &HJ 2%F.: :G :B@Lj PlR 6!D%N.: & :(H/ Versions before Office 2007 only (=> ribbons!) >!V.$T#X Now create tool bar] & >%@.X X & >!@%N.XkH X!D!Z G X%DB@Lj ^ X(\ X(` P X!D%N.<k < < .B@Nk : : .B@Nk ( . & ((bk ((d $ ((f $ (($0o( >Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Option /licit` P"& Sub _Open() If Act4 Is Nothing Then xeCommandBar End(/+ - MenuItem "Convert to LaTeX", s^. Mall '?@Xs AllToFiles|.FK(ByV al CaSAs S@ng, LYRDim pctl GK=tXrol4AiLongCol lebNew G myATbar,@ols Popup, n.C”to-E1=n(s(6d-AIFindD*(Tag:=5, recurs`]:=fD `] $M`( .Dele>t zF.Add(Type:p=mso-Iefor 3d @cC+' VeAons b Offi2007 only (=> @b`!@CLng(S1t(2 p.")(0)) < 12b!'Now cAeM PZxmyT@7`9OO rror ResuNex@ a:GF(! GoTo 0 : ,:@V 9%JIfGACount > 0#&(1) L Posib^so.TopVisiC# ag}g7gV Vh 6.D`g!do I BL p =F)PEach\IPooGXa0^.On(:F107qtipT/$f+ug=h2@w 88 .   ( B0 8H BP Xh" p x  B "   B "  (8 "@HXhp x8]@`]@]@]@ .m0P x.m .xx B@m`( t.m@ .t t/m |.!mp .|  t/m    tB@  tB@xophQAttribute VB_Name = "CController" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |@GlobalSpacFalse dCreatablPredeclaIdC@ExposeTemplateDerivCus tomiz EOp tion 0licit I&ements 6I P/3 mView A Model  Storage (pEv{8*N-< Property (Get Q_()B.E S ]mD End :D=A?P7M*B (ByVal p9QB) Em=7.RaiseBChanged;|D;;A:C: E::99?.g?`M r R-MIdT&VQ Wed)DG1U SubjRun( #If Win32 Or64 Then .Show DvbBJessC#E %alElIfO@m4@, N [x  B"   ( 8Ph   B"   B"  (@ HX B`hp" x B" (HP BX`p" x  B  ((0\8 ,".(|XN 3wxME PSS S \\ B P iDp $i  $,H )J 0%i No `L `N $, ") %IR iT enteringi \c 8 % X % Vx }{ %`,}`Xchec ZP )b %i  cont`X ,d )b%i  0 l% n%,PX )x!Z%i   ,4)%i(i `%``` ` % % Hihii i x )(0%)PX%i  p I I i  ,@X1)x%i i i `<``` ,)%i ,Hi(i ,i)%i %,Pip)%i , ) %i  ``` %,0)%i ,p)%i ,@ ) %i  ,)%i ```` +H8@8<  0@HPX`hp x  B8H &Px       .8h  4 ( D@      " HP h$& .( $8 ` h p  4x   "        B  0 H P $X  B   "      "  @ P "X ` @h  B       B    @ P BX ` h  p     "    B    B ( 0  "H  p              8@H B P` x    ( 0@ HX `p 0x   B  . 8  Hh p   B    0 (@  h B  B  ( 08@H PX` x (     *8 "@  0h" ,  >X `  4 "     6(`h p "  B   B  ($0$X B     &  ( 8H  P :` 8   b     , 0 8 HX`x  B    B   *0(8`( B 08@ P  X,x,  & ,0`h B p "x     2 80@ p6x  B    ((8 `p B x B  B  B  ( 0@ `x  > .     8  H P X ` p x8]`"Characters per Cell in output file]x]]]]]]]@( IModel implementationH .m@ G  'j G  'j G  'jm(]$'@   '   '   ' $ B@kXmP 'm8  G{j ' B@%mp 'm  G{j ' B@m0 'm] ' $ $\*   $ 'k( 'm ?:\* \\*\* 'd%1\%2  $'kmh $'m $. B@mX(]]]]]0' % Error: No range selected.A@k $-% Table generated by Excel2LaTeX from sheet ' !! ' A@  $\begin{table}[htbp] A@  ' $ \centering A@ $\caption{Add caption} A@  'k $\begin{tabular}{ A@ $A@}A@Start checking top border %.  $\toprule A@d  $A@kTable contents:  !!Z' for each row  %. !.   $\midrule A@k0 $A@  ' , !Z for each cell in row r , %l. ,  , , ! ! !Z !Z $  ', , cells in row Struts and end of line%1\\ $$A@  ' Check for Border lines  % $A@k  row Tabellenende  $ \bottomrule A@kH $\end{tabular}% A@   ' $\label{tab:addlabel}% A@  ' $ \end{table}% A@k '- Save to registry after successful conversionA@i@H''   'A@ . 'o  (empty range)' {k%1: %2 ! !$' mx ."mXX $%&. B@m  Class implementation Excel2LaTeXMainDefaultSettings %*A@(o  Excel2LaTeXMainDefaultSettings $. B@,oP@ .'z k !!0!2'i 4Gzj 4$6RangeGzj 4.i ]p  :!'8 !!'8h%1.tex 8$'iH >G < @ '<j  < 'o D >!F%H$'Bi J!!ZE No struts in booktabs mode Gzj] ]0 J$P'L J%$P'N L N \bigstrut'd \bigstrut[t]'kd N \bigstrut[b]'kkiH ] @ ` ] ] ! . %l.V R V$Z'Xk0 , !Z T V..V , T $.V !\ ^KT Xl 'X `KT Xc 'XS Xr 'XDefault alignment is rightnP V X V$Z 'Xk , X'i ' No vertical borders for booktabs style Gzjreturn nothing, | or ||]8 b$d fKT||'X hKT|'XSH'Xn8 X'Zi(P j'd]] l b! d ^ l%r!t$p'd l!v |z l%x%.n d ~ n%r!t$p'dkphi` $'Pi0 !!ZE]H !  %.k ]h]]]]]  !   !v !v  % .kH $'d(  $'  j'k    !v !v  A@   ! !Z A@) Straight line? => revert to old behavior 1-%1 ! !Z$&return nothing, \hline or \hline\hline  $'  fKT $\hline @ $ \hline @ ' hKT $\hline @ 'Sx 'nh e'dH \cline{%1} ;}\cline{$$'k i    '%1%3%2   ;$$'k d  %1-%2   $''kH k@ o8   %r!t' Gzj   %r!t$p'i x j'p  h  hG h'pj  f  fG f'pjix ]]] $'<]( $'Check for multicolumns ! @multicolumn cell ! 5 !Z'5!Z'q  4 Add contents only for first row of a multi-row cell $\multirow{%1}[%3]{*}{%2}  < $$'<d'<kk    \multicolumn{%1}{%2}{%3}  !   ! ! !Z$ <$'<kpd single cell''k@ <A@      < $BA@k &A@k   A@d @ $A@k 'ip@ !d' $'  $'  $'i '$Check for special characters % and $  \\textbackslash{}$' $\$$' _\_$' ^\^$'k8 %\%$' &\&$' #\#$'iH] !. 'Check for Font Styles !G \textbf{%1} $'j !G \textit{%1} $'j Typeset math in bold if required ! e $ e\boldmath{}%1\unboldmath{} $'ki Requires "rotating" package ' Check for orientation ! KT Do nothing KT \begin{sideways}%1\end{sideways} $' KT\begin{turn}{-90}%1\end{turn} $'S\begin{turn}{%2}%1\end{turn}  !$'nHi@]@]X]p $']  % .   ! ! !Z$'   ! ! !Z$'  'i !v !v  'iX0 ! !  'i( ! ! !'i@]]]] $'  ! !!Z '     %$P'7 First and last horizontal lines account for one strut,( the others account for two struts each:   '        'kkiCAttribute VB_Name = "CMo@del" Bast0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobaBlSpacFalse dCre atablPr@edeclaIdCExposeTemplateDeriv%Customiz EOption 0licit  I&emen0ts I Dim CellWi dth A nt eger 'Characters p  in output fil convertDolw"Boolean books Float IndT IG%FullTex% SngsF"„@0 RangeToU@BA=PTV mpEvDNewE 'D iNaUub@V ProF@ty Get _y()/BZEAUS ! Endxsx2l AIf KeThen(D _Or CsMathAsFFr(BH}$AeT\Environ!Y%P2Lg-D(ByVal >'')caVoldR#=l*(qK0= ( <0-) <>!0Non@k8F.%+H,p2)#H+FO8c%Y.Rais6eGodA[If_\(iÀ#\ Ą0Aft$ AiA 8D= VExittBB`j!|& Ff!P ! Q""##$__8"a= fb\xC"aCsDir_v= Worksheet`3@&$UC(i) `Like S) & "\*" qQFMid$W, Len(+ 2 8sn$8AbsolP G 8"?: f\\v*/e~  E?R1oentf("%1\%2",:,W"?;O4Addres6sOs2ToU`_nD) (- 1:Ni :'IsJ' Struts aeof linHRENPrintf("%1\\[GetC(r));M_S-S: CheckBorderNotHorizontalC(r.Of`fset(C:|=1@*&_Mj 'F theE:A. 'Tab@yenH@TENObottom/I"{ular}% CV$leFloat fl:ad~d,# 2xleL ! leave:Model_ PConversionResultsFullaC\ tvegistry aftMsuccessful cF cS ToR Funct Public Sub IInitDefa(KF"0 Aa{Width5SCOp sx2 X$Or tMathChars teRleEnvirohV#,H `"((emp` r)" QExitFI$. : %2qjMe.`cr E, %!`= e! #!BA2 Bc- -(ByVal pB AsRg E.s(1TmpEv$s.RaXisep'pd ' Clasfmple'a24!2(1On Erru;&WtfgTo@, VXBA.`% t"("Exm2LaTeX"Mainqt,ds" *A >/ E* 1 ngs@ B ToS2 (Me? 3E WorksaPgtDir/3/3ot/3J0". 2L23Y#.!.Par0".PATH!GR 5AAYF>0 Sele"V @ B=1 (Typ"J() <> " "RD 4&Ы%9 7 u7 t@e$Dim sS7C//xt= AveS .xGog  p .tex*T)7'SPnԁ1EtxtqE , k GGLFeedFals/+A Q=R+ vbL%||9VPad 3n Longp PcApp|J'-.Max@(0, n)o w ưr0)Debug.AsserӠ=U'q !Ŗm P0..1)bHasTopԶ)BooBOc= p/ Z(pd'z  1@q=pbigR?YR+/%[t]YTEo rl?6b? m[q+1onWCoqmatr-I&:Sa(DDoube/"||dCeISinuou{I)+H= "!0B r4456Variaej#`xlNond5'-&ow?h!rRNEach gIn.`(olveLine(0, .cs(C).a"=?A5!P > 1qape=`ize(lS@:=1).Offset:=-AasHtsNeţ!Z8HasGdCLrBpelow"AFBBooleaD@L(n , 0) <>2` J ҃ ! spacesA Integeroebug.Atss0M +u= 1#SAbo|ve+&l& a&r(=T% 3.%A;QPjRl1OpenFromˎb! ^5:E"1a0C34C9SC00 u_=As(9D -+ )>9>Yt Is­MpiaCell o ~ t_esT73! ,3 xS (:xRcO!1App'dlTo!A/s*, z),p $Ep#N0,&sPF%'ra lj? => re! to old behavioD0 FPntf("1-%1" D d \hQS3  u ]1127Ce@SaY(Y)" "vbLf`C 6 kW0 < "")4;qic Sub 4(B`yRef W-f,/gPVal bOpenLine As Boolean, ByVal lCurrentPostLong) $ IfThlen,4lFrom <= 0 FN H= lL(sRangeDef = Printf("%1%3%2", , @@, IIf( 8"c+;")[E nd If7Elseb1N-M - 1@{B 0C PV S@ub 9vate Function ResolveHorizonta-(rBelowzrAboveD)b.Borders(xl Top).StylSRIs Nothing ExitF0>(, H%BottomH&7QNSBD12 I FxlNon?lA Cdinuous Or 2Aʅq GADoub 1' M ccs onl y"$fK row of a&-g! IsQ OfMa+ a(0F\(@ {%1}[%3]{*}{%2},U`, Get% Vutsd dM aʥ#""#b(4()A~?C G({%3_{ , t#Wc4&,A_ B,($>S%)O  &{ 's@eP!6= 1G (&C)TeI0pk GMq7&Wid6߂!%PadSpace* (3 + )`30Len(A_rI" &% _ ښ " ZvbLf & C Ind@: 0a pmf~3#qfПBcapMS*tvertSpecialC|ha F=PI(+?gOri0a1a눜 ssR)к{s0RhhsS c`act % aH$0$YDollar|TRepl!.As, "\\t5backslash{}"4Q-oO@$B$o_ V!`_b__oo/%`^b^e2 %^%//-&"&_/3P#"#!/,i4+"C@-">-Qpq8Cq)Set c=d; 0: rs/.BoldR/',fQt0{t-Iicnt 1 0d L = Printf("\boldh{}%1\un" \)nd If EFunctio Qvate Orienta)(ByVal sText As ing, rd Range)=' Requires "ro(ng" package?t:w8' Check for oOSelect Case: I.& xlHzal ' Do nothl Upw8ard[iegin{sidewaysjend k*lA%Downr turn}{-90 >%2,OmDBxŜDifferVlineClЭBooleaDim sColumn MxylRe2live Lo ng= Get (B! r Bo Set)@hToUse.s(  BD'd, > .MergeAreaEunt s"& * ?"(<>=8ޤO4v'= #&c, - 5 + 1]IFRow\ &arFI@sFirstOfMulti al4= +RsS6S30;p:owTo 4Caf = Hasq (H) Dxow)1w' a`las(t hv Ws 0acco@|ne strut,the `xertwos each:' ' n ?.%q0pR>g` c<5)GoTo 0 r \qByVal pAs IWDim lIndex Long > =.Add(DefaultModel()"ebug.Assert'= 1%CpB IBCSet D=AsICC.CellxWidc%+G4242C42<>42C#$Q.RemoveDCGetItems.Count!G \(1)JLnO6|Md, 2_E:7ω3d0m(I],&L[5/3?{?Hm,qH?N(N5-$XQ$.3d 6cB_Append|Tob` ^ CasLine`S%a laO From_$m , J, TrueH@1A Fals /, -? "$ >? D./t/"4969, ;4o _en?UT0? Q-1/&/%t6o 6ɠ_"11-5 .LN uxME(S<S<S<S<0{03D772A1-F326-497D-BA51-97DD7E8C0F8C}{962B49DC-C1A3-45B1-A362-E3B7D89F92BB}0(%X0 %   `0  " "  ( 8HXx`A@ o` ( Fal (ebugo0(`Attribute VB_Name = "frmAbout"  Bas|0{03D772A1-F326-497D-BA51-D7E8C0F8C}{962B49DC-C1A3-45B1-A362-E3B7D89F92BB} dGlobalSpacoFalse CreatablPredeclaIdTru BExpo se0TemplateDerivCustomizDOption 0licit` P"& Sub cmdCl=_Ck() HidO8End UserForm_InitializeTextBox1.SelSthartu0( L`ength 1 N ExMEConversion CVolatileStorage" CSheetStorage &Memento0 @x /Opens the main dialog for converting into LaTeXctl 14 &-Converts all configured selections into LaTeXrt l 14# 4 ^8  " T ,8 2h  X ^ Z` "  H 68 p x D J    "(0 8 H Xhpx " ?     ! "<:$%&'()*+,-./012345678BC>@KAFDEGIH=JL. Excel2LaTeX: is en excel to LaTeX converter.o X The improvements of V2.0 are based on Modifications by German Riano german@mendozas.comi Changes introduced:n t * Graphical user interface toM * The LaTeX code can be copied to clipboard and then pasted into you editor. & * Better handling of multicolum cellsnt, * doublelines on top border are now handledt tQ Converts the selected cells to a LaTeX table, that can be included in a tex-fileW via \input{"table.tex"} ot that can be copied to the clipboard. Most of the formatting oT is converted too. You can put additional LaTeX code in the cells, which will remain If  untouched by the converter.ntly, A This converter is freeware. You can freely use and distribute it/ 1996-2001 by Joachim Marder and German RianoSA= Send bug reports and suggestions to: marder@jam-software.comeX".C Web Page for Excel2LaTeX: http://www.jam-software.de/software.htmld it t  =o your = tor). "=Store"C@$qo "A@( you co`XAttribute VB_Name = "Conversion" ' Excel2LaTeX: is en BeL to , Bcbter.`The improvements of V2.0 are based on Mod@ificatgs by German Riano g @?doz@as.comZChanges introduced:* GraphMl usererfacede cfbbopiEbclipboard and thp0past4o you editoo* Betv FdlingpmulticolHum ls?@ABCDEFGHIJKLMNOPQRSTUVWXZ[\]^_`abcdefghijklmnopqrstuvwxz{|}~ '    B  (8 B @P h   "   0@ BH P `hx x8]@`]@ ..r.o m@i *!Z '0Exc   *!Z $. *B@N% e $.R *B@Nd( $. 2 *B@N fork B@i  *B@ B@o .6] 8 * 8$: 6B@Nhi`XAttribute VB_Name = "CVolatileStorage"  Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobalSpacAIFalse dCreatablPredeclaIdCExposeTempeDerivCustomiz EOption 0licit  I&ements I P.amCollecAs New  pEv"'&  *Property Get:_() k  SPm End E1I&Fun/_Add(ByVal pModelB9B, HlIndex-1&Long #I!E.Count + 1D f (< 0) Or, (U =Then  , (ToSng(.) EIf +0 , Before:=D.A#, After:="D'fIfl.RaiseChangedCoEjIoSubRemovendE2 I&?d" FUItems#T`a5SEB-facDim sB:OVarian@rFor EachIn fP.DSClTo@ ( $$Nex e-N VxME > F >$B%B@DkH] >$B%.J]$J.H] $N.L]0]H P$T'R P$H'R R G P$V'Rj R E P RangeAddress P$L R J%A@Xd0 P$L R J,%k > '0 B@r ii`]  $B%.Jut Z JB@Lu B@. *o.6 pr]P$B.\i \Gzj]p] ^$J.H]]]]e]0  < th  \%.Jn. J >!F%fGyj.`ase b H b$^'P1 P RangeAddress bj J%$h'dmod0 bj J%'dGk d P `B@Nto `$l 6B@N opt.`iP =COUNT(%1) n$ (po !p !p $'haTiP`saved 8 !tur Excel2LaTeX7l.Bes c v!x r5N.Brded a Excel2LaTeX B( z B(`den kqi.Jontrac.|ovemen]$B.\ w \Gzj] \%.~ist ]]  <is sho j ~%'8f 8Gyj A do  8 JB@Ntem in 8 |B@Ntoi]`$B.\ly, ] \% .hit ]]  < "Ov  %'dng derwr '@zki]0$B.\elec]P \%.~mpt.]p]  <erts a j ~%'dLa des o 'z@k80i($'Vroperl] $B.\ 8 V \,tisAttribute VB_Name = "CSheetStora ge" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |Global!SpacFalse dCreatablPre declaIdCExposeTemplat@eDerivCustomiz EOption 0licit  I&ements I P.2 mpEvAsp New Const MAX_DIMl10  &Property Getņ$_%() 1Au/ S/L ` End E $Func;_Add(ByVal pModelBB, FlInHdex-1&L ong #Dim lFreeRowGIf < 0 ThenC A F =?EA L D+ 2Oj»()."s().InsY xlShif0tDowD"JIfCA3rD2Rang \+McColumnsFleaC  List()3N@jue= iB8To (;. sKeyVarian_a:>P:For Each bIn Ms% Okrr`ResuNex l = -1CP$( GoTo 0'P Q Be# Debug.AsH>$H@mress"`A DTo@+mulaL c9c, N.Cells(1, e xj g%? bG5Ɇ &x- 6.RaiseChhd%SubGRemoved$}Ods1cY+ 1$ #Dele@UpC;Item@ak`J~)E@*mcpɎ WorkscD;Ju/S1KImot0hing*qit %K] EJ_O RROcQ $Yg7JD:qM9P S ng, s7QA"q`Pl!= 2 0G~3 r= Di AppЇay.&.CountA() "stDtor[cc o$ 1 B\Up\WQDLR( ! =T"N= @NToP2N!";:=e|/O Oa1. !p")glw=2+To"z(X 14#8S! y8o]TdvddTst-,z 3rAe-tB.'ntf("=COUNT(%x1)"40Q S J% H% L(er%`P l `R a 4iIn Joi%,6P( '%)H rt% \haT % H: % ^ef% `Ve%`ea`b Se`Pnown`d S JHevel% Xinex .)~~~~%,h`)8@ur "%i wo b,B ir . If  %) ly,  %,J8`)|Xhwhen%%) ust % \and  % ~e to%`n th`8 res,@@i r). \xton  % ngs %` or `dX. ,i V \H on  % ~hoolb%`om p`d ,Vi8 tabli fol \8 requ % 88      B( 0@ B HX `px    ( 0@P X x  "      " (08X  hx B     ( @ ` p      (08 " @ HhB px& B     ( @PX` B h p     0HX` Bhp x      B ( 0 @H `hp    B      0x8]@`]D'te S ..(ByValm8mC]  dex @'>d  'x=}t w}D.1,z I)`"G]@ !' G|jx  !ngs VoXX]] !.  !Z* $A@oKAttribute VB_Name = "Memento" Option Explicit Pub, FunclModelPropertys() As Sng()  Const NAMES8RangeAdd ress|ns|CellWidt h|Ind|File[MsJSt(b, "|"yEndToCollef(ByVal p{0TIhiS8et  CNe w Dim sc,VarianhFor EachIn, ";. CallB(`,', VbGet)#Nex>sXGC989V[& Printf("%1=%x2;";]BD@SdubqTo, F~xGFEFO@rrRes~u2E?IJFFVbLet, p&(BRF GoTo 0E"ai&$.S}$ksgtings!$#aCFA}F ~;O~!-l1A LonggsKey@ue-r= 0 @!UBound(h&@ &(l1n0b#!9zg9 =D9s 7QATo ] 6㣃 f5& D& B TE +P qqMa<PE ;U-To+ +If pCIs Nothh The xitaJ& E'%1'!%2` .Worksheet.i0e1yT To s1 B 7# Vu"onARpca.(/ES `SaveЋversVltToe! S%^uc s=D=.Absol0" CSOp K@Output1c3B #1PR . ` ;Clos>e7+_pAllStoredI0tems!agTI8OYm cq AS@5Q 3SZ1Z.C[$1DZ% X )8%` (Factory IModellIController0< IStorage YP%.ix.iXH .i8 .@ B@Hi.%ih ."iH@Attribute VB_Name = "Factory" Option Explicit Pub, FunclNewController() As I SetN N C PE ndUhModelc ^Y TDefault- 10oe.Init @Vieweh CS0heet  $(/N xME PSS S<S>ByVpal pC)>View?B B'StorageD?D !!Sub Run( @g (N <xME PSS S<,stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files (x86)\Common \Microsoft Shared\OFFICE12\MSO.DLL#P 9.0 Ob Li`braryMTools frmConvert59_VBA_PROJECT3dirCurrCdWIf IsMissing(xpThen[= -1 Else7*)If' Handle all tokens:CBD%~Szt(r, "%"G 9@ry of is tZunti!he fAQ oHccuDce %Start from secoO@)D" lm= L() + 1 To :Mneft$ (), 1D2 Select Case@E|"1""9 i' ipeter: L@ookup @X inserġ va= CL@G,) - yE "A@Q<= sB Es =CAK' Defa@o: E.g., keep %3 if onl@y two f s aressed  K &/EWab>:UA & Mid>2';%:Deb0ug.ASFamBSpec i`BcJ: %% (or % ees)$]a }a'*@signo@)njuA !#)ih#/A' Silt=othex$k ?bw!=rCN#' Combine< r'C@Joinc} %ԁ֐Sub Keueǵ, ByRef s@K{lC}@VBA.In(1, b =KA|!{0,z="}A's`Qk7LdB@cB4 #Aeqpg?@vaЅ Test_S(C*7"%1"abc")"f("Thg a %2%1.tq(not)o simple) .Let's`ke how it h^les out-of-rangPPAasRpfAA%y,bevenTB`CC gdqO '%%%!%1h+6$4dq+梓S @ =cd0`4'j0abOt 2Scd=ef074do/H cey1&k    B  0Php .     @( 8 $@  h x  0 *   h(0    ( 0 @ H  X h p x B "  9 B "  (8@ " HP` h p B  B     ( "08@ X h x ptE-N %HxMEH8<(D$4@0,@S<S<S<S< Dim lUBound LongsResulYvElemenVarianVTex Na(sFirstCharSPosQ< <<<9 %B9 !D$>9 !F9qo' 5 (@5 B@H5 (D5 (F5 !J($qx'A@*o`` B@]  |! ! B@Lo N!PG B 'Bj R!PG B 'Bj T!PG B 'Bji0   N(P   R(P   T(Po  $B x(o A@Vo A@VoX A@Vo ] x!TeX documents (*.tex), *.tex >%`'  'FkPoH A@ o00 ]p 6 fB@j fB@lA@ o xA@A@ o x |B@N !r (o ]P !'  |B@ x  |B@N  (o(h ! |!%l / o ! |B@o |A@(o( B@oh | @(doh  D(doH8 @'| @ x(o( F x( F x! x!'Fkoh D' D x(o >!4 x/ x! !J($o`T This is regenerated every time the form is activated in the IDE. Just keep it here.o(A@oVAttribute VB_Name = "frmConvert"D Bas0{003F9D78-98E8-4612-AAB1-8E52206E645C}{840DDBDF-C6D3-4D50-89F6-71909FADE004} dGlobalSpacAoFalse CreatablPredeclaIdTru BExpose0Template DerivCu@stomizDO@ption 0licit I&ements@ IView P ,0 troller A z.VarH elpIDn-1 &WithEv4. QmModel,BS!  StorageBJGJ XActW@kSheetA$WorksJ 7bIgnore/Boolean!' ' iEaBProbpy G&_ǖ()O SP@LhI E8nd e Q(ByVal p ~)h HR#=i .-:#?"''"&!#5_$E! d D$gA9LoadedTpsLis`G"Subhow`r6FormS17staDMe. - AT"Q' yTFun hSafeRange@c` %%_$V""O rror Resu@Nex Q J.G CIUnOf"AndIts? '#Dim p&= Q"p /If Is Nothing TheA!!v=cERwf= u( ,) 'If(lvw)+h_Ch!!(bSelect yG&Qa = (./Index >= 0cmdA2.En263Dte/ed&Owri_a D19_Dbl CkT/Canc uMSA4s.Return$ M A D_/s_KeyDowvnC~a*+Integer, C]Shifot ys CA46 ' ЃetpE&P u a# t muE# Tar^g0m8w@2  rjs$(c,C,_>d1.(.#8) 6 PRS PCs/ Kis]_@Uel0d)0pqIC=.8e?!ezeInitFrocE$IP+ ].2"uby[-0m3ExiA.DescriGCNextJ4hFunBQ k(b)$x2lCIf chkBoo@ktabs.@ue ThenH` Or E IXDollar MathCharA&`Floa2tresBEnvironmGE ~ GׄF JI= ( HE) <> 0F F N!02^Upd%%]?C%} @AT H$_C݀k j UPHo-%?$k%mdBrowse!{s#Appa`eSaveA ()Absolute, "TeX docu!T@*.tex), "O aG JbtL 5If.mdC ancel)Hi>d $+0-O 91b]r_BY^ԅ͵C~SYJ"Cn.N+~D8Fmp,z#PlwG+O%KAJ ZvO~;7`HKǫ[@/ap%FQOĶ58A<3~ޫ*BXe&dla ImplementsExcel+VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuMSFormsCRefEditVBIDEA ThisWorkbook| _Evaluate Workbook_OpenActiveWorkbookCreateCommandBarCreateMenuItemCaptionxActionRctlCommandBarControlPi`ControlCollectionZ0 CollectionW myMenubar҇ CommandBar toolsMenu`wCommandBarPopup  newMenuItem newButtonR Application* CommandBars  ActiveMenuBarrControlsK FindControl mTag& recursive DeletexAddrmsoControlButtonnBeforeSplit)Version myToolBar%Count0vPosition msoBarTopyVisibleOnActionFaceIdi TooltipTextb?WorkingzWorkbookkItemzKlasse1A CController8c IControllertmViewOIViewmModelIModelmStorageIStorageYmpEvents,IControllerEventsIController_EventsPIController_ModelQ`pModelaRaiseModelChangedn~IController_ViewpView: Controller&IController_Storage0|pStoragepStorageo+-S`CompObjQpCompObj/iaVBFramek(IController_RunGWin64xShow vbModelessZ vbModaltCModel: CellWidthĵ convertDollarYbooktabs tableFloat&lIndentCFullTextW sFileName RangeToUseRange  IModelEvents" IModel_Events'IModel_Optionso x2lOptionsYx2lConvertMathCharsk x2lBooktabsx2lCreateTableEnvironmentv]Options oldOptionsyx2lNonen RaiseChangedK IModel_IndentiIndentjIModel_CellWidth  iCellWidthIModel_FileName iFileNameFsBaseDir`# WorksheetDirfUCase5 IModel_AbsoluteFileName9PrintfIModel_RangeAddress%ERangeToAddressiRangeAddressToRange֎IModel_GetConversionResultrirc^cZFileNamejjaposAddTextQleavetSpace  WorksheetGetColumnsFormat)LRowsUHorizontalBorderCellsAddCell_/ MergeAreaColumnsp9 GetStrutsOffset RowOffset&theend0SaveToRegistry۹IModel_InitDefauam *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\GEMEIN~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.3#0#C:\Programme\Microsoft Office\Office\EXCEL9.OLB#Microsoft Excel 9.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation2*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.1#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 9.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINNT\System32\FM20.DLL#Microsoft Forms 2.0 Object Library *\G{44C106C5-8BB6-4C0D-B999-DAAF291DA70F}#2.0#0#C:\DOKUME~1\ADMINI~1\LOKALE~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M f*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3  b R  N ThisWorkbook0?520a1862ThisWorkbookL Working074f6e0d51iWorking0 aCController10520a1862qCControllerr8 CModel11520a1862 CModel3wPXTest12520a1862Test[h2 frmAbout13520a1862 frmAboutuConversion14520a1862ConversionE CVolatileStorage15520a1862 CVolatileStorage[= CSheetStorage16520a1862CSheetStoragezMemento17520a1862Memento&Factory18520a1862FactoryV IModel19520a1862{ IModel IController1:520a1862sIController(IStorage1;520a1862IStorage<@"IControllerEvents1<520a1862"IControllerEventsX9IModelEvents1=520a1862IModelEvents.p!IStorageEvents1>520a1862-IStorageEvents- IView1?520a1862w IViewx Tools20520a1862 ToolsN!frmConvert21520a1862frmConvert%HK-@hltInitFromRegistry~GetDefaultRangeGetDefaultFileNameIModel_Description^H IModel_RangeĹpRangeAreasK StringToModel GetSetting SaveSetting ModelToStringParentPATH2 SelectionZTypeNamesNamed ActiveSheet%NtxtLineFeedvbLfT%PadSpaceneWorksheetFunction&MaxȲrRowd bHasTopBorderbHasBottomBorder;HasHorizontalBorder bSkipFirstylStepwcn\stgVerticalBorderHorizontalAlignmentS@xlLeft9xlCenter pRightRange VerticalBorderStyleJ~xlDoubleE xlContinuous[xlNone pRightRow|pLeftRow5b ResolveLineBordersC" LineStylewColumniResize@4 ColumnSizeu ColumnOffsetʚxlRighte rBelowRangevspaces rAboveRange)XRow sRangeDefQT lLineOpenFrom? bOpenLine borderStyleS rBelowColumn' rAboveColumn^IsFirstRowOfMultiRowCellResolveHorizontalLine8AppendToRangeSetFvReplacef lCurrentPosIIfzxlTopxlBottom?line1line2rCellh bFirstCell' bLastCellAnColumns#nRowso FormatCell*bRequiresDifferentVlineFormat[RequiresDifferentVlineFormat0 MergeCellsکGetMultiRowStruts0>ConvertSpecialCharsw%FormatCellFonthFormatCellOrientation:sTextpFontFontUBoldItalic! Orientationw xlHorizontalxlUpward  xlDownward  sColumnFormatc sCellFormatlRelativeColumnGetRelativeColumnOrColumnGetRelativeRow lStartRowlEndRowlRowbBorder Modul1Test4Test_VolatileStorage4 Test_Storage9CVolatileStorage4Test_SheetStoragepSheets Clear CSheetStorageolIndexNewDefaultModelأlIndex2kRemoveϱGetItemsyTest_Model_AppendToRangeSet6WsLineDefR]frmAboutcmdClose_Click!PHide9zUserForm_Initialize5cTextBox1SSelStartZ SelLength ConversionMLaTeXg NewController[ViewINewViewBnModel9 NewStorage}Run_LaTeXAllToFiles<SaveAllStoredItems mCollectionIStorageEvents5IStorage_Eventsu{ IStorage_Addp"AfterXIStorage_Remove$IStorage_GetItems.sModelStringToNewModelyNMAX_DIMNlFreeRowGetFreeRowIndexGetStorageSheet|FInsertr xlShiftDownccColumns?, GetColumnListo<cValuesModelToCollectionsKeyh lColumnIndexeModelPropertyNames> CreateColumnAddressToFormula1 xlShiftUp pStorageSheetcKeys cRowlColumnxLsValue$CountA38FormulaToAddress ColumnIndexPCollectionToNewModelsAddressFormulaqYbCreate WorksheetsErroNumber- xlSheetHidden4 cNameList pFirstRowl1^ pFirstColumn,_RowIndex6dGetFreeColumnIndexbMementoNAMESο CallByNameyVbGetCollectionToModel pCollectionLVbLetA sSettings aSettings/ SplitKeyValue  pSettings,NewModelAddress sRangeAddressESaveConversionResultToFileqAbsoluteFileNameLGetConversionResultRwcItems1Factory] InitDefault frmConvertLEvents4 RangeAddress Description  ModelChangedChanged pControllerModalFormShowConstants}Tools6sFormatüValues lValuesUBoundj<sResult vElementlTextaText sFirstCharY lValuePosN sCurrentValue IsMissingJoinM& sKeyValuelPos Test_PrintfTest_SplitKeyValue[ mControllernmControllerEventsן mModelEvents{mStorageEventsmActiveWkSheet&mbIgnoreControlEventsgIView_Controller IView_Storage}LoadStoredTablesList IView_Show,SafeRangePrecedentsg PrecedentsUnionOfRangeAndItsPrecedents pPrecedentsuUnionlvwStoredTables_Change. bSelectedlvwStoredTables ListIndexQcmdLoadEnabled۪ cmdDeleteV cmdOverwritelvwStoredTables_DblClickbCancel ReturnBooleane cmdLoad_ClickLlvwStoredTables_KeyDownKeyCode ReturnIntegerShiftcmdDelete_ClickmActiveWkSheet_ChangeVTargetF Intersect1ConvertSelectionA{mControllerEvents_ModelChangedm InitFromModelmModelEvents_ChangedL SetResultamStorageEvents_Changed txtResultY)Locked SetFocus InitModelVVal txtCellSizeG GetOptions1 txtIndent' txtFilenamed SetOptions4 cmdSelection+AddItem  chkBooktabsxValueKchkConvertDollar chkTableFloath  UpdateOptionsR|chkBooktabs_Click͛chkConvertDollar_ClickchkTableFloat_ClickϱcmdBrowse_ClicklGetSaveAsFilenamecmdCancel_Click\ cmdCopy_ClickPdataObjj DataObjectSetTextPutInClipboard cmdSave_ClickcmdStore_Clickʑ ListCount6cmdOverwrite_ClickXcmdExportAll_ClickACommandButton2_ClickspnCellWidth_Change9B spnCellWidthPspnIndent_Change spnIndentEtxtCellSize_ChangetxtFilename_Change1txtIndent_ChangeficmdSelection_Clicky+UserForm_ClickD 5- & +i -q*s *w% { 3(26hMSFor ms>SFrms$3D452EE1-E0D8FA1A-8-02608C4D0BB4ITINNTStem32\FM20& `L&/;!1Ck rAr00}#:0r# 50 g A44C106C5-8BB6-4C0D-B999-DAAF291DA70F6DOKUME~1\ADMINIALOKALATemp\VBEa7.exdbBIPDE DI2E157E5.3@ @6A676EXT.OLBHVisual Basic for Applicfs Extensibility @"bN bzThisWorkbookGT {i`QWRkbok*2` H1b",L "5"+din gGdinng!h2a*0 CControllerGC@nrlžr m2m rc (%!CModelG"/CMdlM2Xo 3wTesthGT ۢ62/ 2@[!*! frmPAbou `fAbMu. e2qomu=verbs`G`=v r_i`-n,+&26 o.EC+!CVol wleStorage(G V lai'Sopa`0e ge2+ =  [PCSPheet  SU`Cetmt rՠ g/2 Puhep 2z CMementoCM m0q]V[1@IBIBB" YOIRIR*۳Re? рB=ԁ? BI)1~In(QG5E=_<@0XEv(sGgEFQ)sC!nts2eh 9P 3S"% 1" ]3 ! . } ] 1[2N__ -_ _ IViewGAIViFw02&xTool%iTV1$o!&5NExcrpz1rszrt3rtgK-]%H=K*mrU~~~~~~~~~~d 28 6I\ __SRP_0T __SRP_1frmAbout0 mw@wf#       9 i      9 a      ThisWorkbookWorking VBAProjectF /C:\PROGRA~1\GEMEIN~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  A`F /C:\Programme\Microsoft Office\Office\EXCEL9.OLBExcel 9p0FC:\Windows\SysWOW64\stdole2.tlbstdole 9L-[DREC:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLLOffice 1.E .`M C:\WINNT\System32\FM20.DLLMSForms 99aD Lگ) 2C:\DOKUME~1\ADMINI~1\LOKALE~1\Temp\VBE\MSForms.exd 99WFIC:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLBVBIDEIStorage )F^ALrwN=JF"hܳN1B0@DFWorkbook Workbook_OpenCreateCommandBarCreateMenuItem @FF   Klasse1 CControllerCModelModul1TestfrmAbout ConversionCVolatileStorage CSheetStorageMementoFactoryIModel IControllerIControllerEvents IModelEventsIStorageEventsIViewTools frmConverterU~}   CaptionActionj(H  @ }1!R KQDBTahoma(2tLabel1!W(2@Label2! (;8cmdClose$)TextBox1{q uTahoma(o!#l*CompObj"(aVBFrame*+frmConvert%@wzw Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmAbout Caption = "About Excel2LaTeX" ClientHeight = 4890 ClientLeft = 45 ClientTop = 330 ClientWidth = 7215 StartUpPosition = 1 'Fenstermitte TypeInfoVer = 9 End (H  !@F}S2R KQT(Bby Joachim Marder, Germn Riao, Andrew Hawryluk and Kirill Mller.$uTahoma (Excel2LaTeX v3.2NuTahoma(Closea{uTahoma`)!@HB),Excel2LaTeX =========== v3.3 It's difficult to create tables in LaTeX, especially if some columns are calculated. Excel2LaTeX allows you to transform the current selection from Excel to LaTeX. Text formatting (bold, italic), alignment (left, right, centered), and rotation of cell contents is retained. Cells spanning multiple columns and/or rows are supported. Border lines can be retained at the level of individual cells, or replaced with the style of formatting recommended by the booktabs package. The generated LaTeX code can also be placed in a floating table environment. The LaTeX code can be copied to the clipboard or saved as a LaTeX file, which then can be included in an existing LaTeX document using the \input command. You can also specify which ranges of your Excel workbook you want to convert into LaTeX, and convert them all at once as individual .tex files. This Excel add-in works best in Microsoft Office 2000 and later (on Windows). It also works in Office:mac (on Mac OS X), but see the "Known issues" section. SOURCE ~~~~~~ The development repository and the bug tracker for this package is hosted at https://launchpad.net/excel2latex . INSTALLATION ~~~~~~~~~~~~ Just open the file Excel2LaTeX.xla in Excel. Then you will have two additional menu items in your "Tools" menu and a new toolbar with two buttons on it. For Excel 2007 and later, you will have two new buttons in the "Add-Ins" ribbon. If you plan to use the program frequently, you can save it in your addin directory and add it with Tools/Add-in. This way it will be loaded whenever Excel is opened. USAGE ~~~~~ Just select the table to convert and hit the button "Convert table to LaTeX". You will be given the option to save the result to a .tex file, or send it to the clipboard (so you can paste it into your LaTeX editor). Hit the "Store" button to store the current settings so you can "Load" them later or "Export all" to LaTeX. ANNOTATIONS ~~~~~~~~~~~ * Bold and italic are recognized as long as whole cell is in bold or italic. * Alignment formats (right, left, center) will be recognized for individual cells. * Cell border lines will be recognized for individual cells (with certain restrictions). * Font sizes are not supported, because they are handled completely different in TeX. * Cells spanning multiple columns and/or rows are supported. For this you have to merge the cells in Excel using the format/cells menu and selecting the alignment tab. * The characters %, &, and # are automatically replaced by LaTeX macros (e.g. \%), while \, $, _, and ^ can optionally be replaced. * You can put additional LaTeX formatting commands in the Excel cells, so you don't have to edit the output, if you want some special chars or formats. * The default file name for export is the name of the selected range (if it has one), otherwise it will be the name of the active Excel worksheet. * Stored tables: It is possible to store the Excel ranges that you want to convert into LaTeX, together with one set of options per range, in the workbook. Internally, the "list of stored tables" is kept on a hidden worksheet named "Excel2LaTeX", and hence is saved whenever you save your workbook. The table ranges corresponding to the stored tables are recorded as relative references in the hidden worksheet "Excel2LaTeX"; extensions, contractions or movements of a "stored table" will be reflected automatically. A list view containing the stored tables is shown on the right side of the main form. A double click on an item in the list of stored tables loads this table; alternatively, you can select the item and hit "Load". The buttons "Store" and "Overwrite" allow inserting a new or overwriting an existing stored table. The "Delete" button deletes a selected stored table without prompt. The "Export all" button converts all selected ranges to LaTeX and writes one .tex file -- don't forget to configure file names properly! In addition, the new toolbar button and menu item "Convert all stored tables to LaTeX" call the macro LaTeXAllToFiles that also triggers this process. COPYRIGHT ~~~~~~~~~ Copyright 1996, 1997, 1998, 2001, 2008, 2010, 2011, 2012 by Kirill Mller, Andrew Hawryluk, and Joachim Marder. This work may be distributed and/or modified under the conditions of the LaTeX Project Public License, either version 1.3 of this license or (at your option) any later version. The latest version of this license is in http://www.latex-project.org/lppl.txt and version 1.3 or later is part of all distributions of LaTeX version 2005/12/01 or later. This work has the LPPL maintenance status `maintained'. The Current Maintainer of this work is Kirill Mller. This work consists of the file Excel2LaTeX.xla. KNOWN ISSUES ~~~~~~~~~~~~ Office Mac: "Copy to clipboard" appends extra null (\0) characters. Office Mac: Performance is worse than in Windows, converting large ranges might take minutes or hours. Office Mac: The functionality is accessible only through the "Format" menu. Office Mac: The dialog is modal (Windows: modeless). All: Color not (yet) supported. BUGS ~~~~ Please report bugs via the bug tracker at https://launchpad.net/excel2latex . CHANGES ~~~~~~~ Version 3.3: Released on 27 Sep 2012 * Bug fix: Doesn't crash when trying to start conversion when an entire line is selected. * Bug fix: Better conversion of backslashes: '\textbackslash{}' instead of '\textbackslash ' * Performance: Improvements by avoiding unnecessary calls to Excel objects Version 3.2: Released on 26 Mar 2012 * Bug fix: Finally restored compatibility with Office Mac * Bug fix: Do not add extra alignment tab after \multicolumn{}{} Version 3.1: Released on 19 May 2011 * If the column width is set to 0, each cell occupies a separate line in the output file * In booktabs mode, no vertical space is inserted before the top row anymore * Bug fix: Restored compatibility with Office 2000 and Office Mac * Bug fix: Form is protected against erroneous entries Version 3.0: Released on 17 Nov 2010 * CAVEAT: The toolbar buttons and menu items from previous versions of Excel2LaTeX are not deleted automatically. * CAVEAT: Depending on the formatting of your table, you might require the following packages not required before: - bigstrut - rotating - multirow * Stored tables: See annotations above. * More cell formatting options are used in the converted table. - Cells with rotated contents are supported. Requires the "rotating" package. - Multirow and multirow-multicolumn cells are supported. Requires the "multirow" package. - A cell formatted as bold and containing inline math formulae is typeset in bold using \boldmath and \unboldmath. * More precise typesetting of cell borders in non-booktabs mode. - A column is assumed to have a vertical border if there is a border in any row of this column. Cells with a vertical border different from the default or without vertical border are typeset using the \multicol command, specifying the border type for this cell. If both single and double lines are present in one column, a double line is assumed as default for this column. - Horizontal rules are typeset using \cline if they do not go straight through from left to right. Double horizontal lines are converted to single lines in this case. - \bigstrut commands are inserted where appropriate. The number of struts required for a multirow cell is computed correctly. Requires the "bigstrut" package. * Bug fix: The type of the left border of a multicolumn cell is determined correctly (in non-booktabs mode). * Improved file name handling. - The target .tex file will be stored in the directory of the Excel worksheet by default. - If the target .tex file resides in the directory of the worksheet or in a subdirectory, a relative path to the file is stored. * The main form is now modeless. The worksheet can be edited while the form is open. - Changes to the contents of the selection are tracked, the LaTeX table in the text box is updated automatically. Changes to cell formatting (font style, borders) are not tracked. - The current selection can be set as source range for the current conversion to LaTeX by hitting the large button at the top of the dialog. * The main form shows up always, even if no range or a multi-area range is selected. Version 2.3: Released on 16 Nov 2010 * Bug fix: In Office 2007, no error is raised after opening a document anymore. * Bug fix: When writing the TeX file, no additional newline is appended. Spurious spaces may produce unwanted results. Version 2.2: Released on 29 Sep 2010 * Save and load settings to/from registry. * Bug fix: do not add two command buttons to the ribbons in Excel 2007 and later. * Bug fix: use \textbf and \textit instead of \bf and \it. * Bug fix: do not use vertical borders for multicolumn environment for booktabs tables. * Bug fix: correctly determine LaTeX column borders if Excel cell borders are set only for the top and/or left border. * Internal: avoid copying the range to a hidden worksheet before converting it to LaTeX. * Internal: various code refactorings. Version 2.1: Released on 18 Sep 2008 * Better character replacement: the previous version only replaced the first occurrence of $ or % in a cell. * Optionally generate a table environment, format the table in the style of the 'booktabs' LaTeX package, and/or add extra leading indent spaces. * Better interactivtiy (no refresh button required). * Bug fix: the previous version would damage formulas that referred to cells outside the selection. Version 2.0: Released on 21 Jul 2001 This version is based on modifications by Germn Riao * Graphical user interface * The LaTeX code can be copied to clipboard and then pasted into you editor. * Better handling of multicolum cells * doublelines on top border are now handled Version 1.2: Published on 22 Nov 1998 * The characters % and $ are now converted to the correspondig LaTeX makros Version 1.1: Published on 12 Apr 1997 * Some small changes to make it run with Excel 97 too Version 1.0: First published version, Oct 22 1996 5Tahoma      !"$%&')+,-.01a3456789:;`=?@ABCDEFGIJKLMNOPRTUVWXZ[\]^_bcdefghjlmnoqrstuvwxy{|}~DBTahoma8KEFҋB `EF ( 4txtFilename.H,I{5Tahoma ( RBrowse .... uTahoma(HHelp uTahoma(CloseaEuTahomaD#@H!D3JGenerating Table. Please Wait....r5 Courier Newt(]XThis is the selected range convertedRoot Entry FnzwWorkbook5l3_VBA_PROJECT_CUR"38wzwVBA18wmwf/o$*2i14( n``@w@wfHuTahomade    +( @cmdBrowseme.++,8CommandButton2 /, ;8cmdCanceltto, /( h txtResulttto( 2Label1de$ LcmdCopye($ DcmdSavee+$# Frame1ee( #frmStorageto5( ,cmdSelectionI  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmConvert Caption = "Exce2LaTeX" ClientHeight = 7365 ClientLeft = 45 ClientTop = 330 ClientWidth = 12150 StartUpPosition = 1 'Fenstermitte TypeInfoVer = 70 End PROJECTwm2#puPROJECTzPROJECTlkSummaryInformation(4ThisWorkbookThisWorkbookWorkingWorkingCControllerCControllerCModelCModelTestTestfrmAboutfrmAboutConversionConversionCVolatileStorageCVolatileStorageCSheetStorageCSheetStorageMementoMementoFactoryFactoryIModelIModelIControllerIControllerIStorageIStorageIControllerEventsIControllerEventsIModelEventsIModelEventsIStorageEventsIStorageEventsIViewIViewToolsToolsfrmConvertfrmConvert@ID="{71666DDA-3981-11D5-8044-0050BAACF786}" Document=ThisWorkbook/&H00000000 Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} Document=Working/&H00000000 Class=CController Class=CModel Module=Test BaseClass=frmAbout Module=Conversion Class=CVolatileStorage Class=CSheetStorage Module=Memento Module=Factory Class=IModel Class=IController Class=IStorage Class=IController to LaTeX. Click the button to use the current selection.N5Tahoma,(CCopy to the Clipboard; uTahoma$( SSave to File:; uTahoma N n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19qH(2WMinimum cell width (0=each cell in separate line):uTahomas:H,"{uTahomas:<FV a2Convert $ ^ _ \5TahomaHFB:{2Booktabs-style formatting5Tahoma$( DExtra indent: \quTahomaH,"{uTahoma DFT{2Create table environment5Tahoma8H  }D3 Options:R KQDBTahoma (2hLabel21( 4txtCellSizet+,\chkConvertDollar, 2spnCellWidth<0( hchkBooktabshO(2DLabel3#4( 4txtIndentbsh+, 2spnIndentbsh<0, dchkTableFloatlarEvents Class=IModelEvents Class=IStorageEvents Class=IView Module=Tools BaseClass=frmConvert Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="C3C175B43CB83CB83CB83CB8" DPB="868430F9307FF280F280F2" GC="494BFF00000000FF" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=25, 25, 1015, 589, Z Working=0, 0, 0, 0, C CController=0, 0, 0, 0, C CModel=0, 0, 0, 0, C Test=0, 0, 0, 0, C frmAbout=0, 0, 0, 0, C, 1  n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q(eStore3EuTahoma(LLoadEuTahoma(DeleteEuTahoma ( vOverwritedEuTahoma ( pExport alldEuTahoma`[a$5Tahoma@H  ! }0Stored tables:arR KQDBTahoma(;<cmdStore &(;8cmdLoade &, ;8cmdDeletea &, ;@cmdOverwriteW), !;@cmdExportAll,,4lvwStoredTables 10, 110, 1062, 553, C Conversion=0, 0, 0, 0, C CVolatileStorage=0, 0, 0, 0, C CSheetStorage=0, 0, 0, 0, C Memento=0, 0, 0, 0, C Factory=0, 0, 0, 0, C IModel=0, 0, 0, 0, C IController=0, 0, 0, 0, C IStorage=0, 0, 0, 0, C IControllerEvents=0, 0, 0, 0, C IModelEvents=0, 0, 0, 0, C IStorageEvents=0, 0, 0, 0, C IView=0, 0, 0, 0, C Tools=0, 0, 0, 0, C frmConvert=0, 0, 0, 0, C, 132, 132, 1084, 575, C "EFOh+'0@H`p  German RianoxdexconRMicrosoft Excel@ )@M w՜.+,0 PXd lt| n Working ArbeitsbltterDocumentSummaryInformation8CompObji FMicrosoft Excel-ArbeitsblattBiff8Excel.Sheet.89q