Tell me more ×
TeX - LaTeX Stack Exchange is a question and answer site for users of TeX, LaTeX, ConTeXt, and related typesetting systems. It's 100% free, no registration required.
up vote 0 down vote favorite
1

I need help installing and using exceltex.

I installed ActivePerl, then according to link I installed Spreadsheet::ParseExcel. Then copied exceltex into

/usr/local/bin

and exceltex.sty

into

/usr/local/texlive/2012/texmf/tex/latex/Misc

Note: I created the Misc folder myself.

Now according to the above link, when I try to run the simple example given in the above link, after creating the LaTeX file, it says

now, run `latex`, `exceltex`, and `latex` again.

This is the part I don't understand.

Am I supposed to compile my LaTeX file, then run exceltex from /usr/local/bin and then compile the LaTeX file again? I tried this and it doesnt work. It compiles, but doesnt give me the result I am looking for. I really appreciate any help/suggestions.

share|improve this question
Never add things manually to the main tree. The correct place is /usr/local/texlive/texmf-local/tex/latex/exceltex/ (create the necessary folders); run sudo mktexlsr after copying the .sty file there, – egreg Oct 29 '12 at 23:11
Could you please post the link you are referring to? – krlmlr Oct 29 '12 at 23:22
I edited the post; now it has the link. – N Nik Oct 29 '12 at 23:29
1  
Which tex distribution and which operating system do you use? As the manpage of exceltex says you need perl to use it. So your asked exceltex is run from command line using perl. How to call depends on your computer system. – Kurt Oct 30 '12 at 0:34
1  
I have no Mac (I'm a windows user) so I don't know, how to do it. It could be you need to add something like perl exceltex to call exceltex. The manual of Activ Perl should tell it. Then you first compile your tex file, then ExcelTeX, then your tex file twice. I saw some pictures in TV about Sandy. Bad thing... – Kurt Oct 31 '12 at 20:10
show 7 more comments

closed as too localized by Speravir, Kurt, Guido, Thorsten, Stefan Kottwitz♦ Apr 14 at 7:53

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, see the FAQ.

1 Answer

up vote 2 down vote

I got exceltex working in Mountain Lion by applying the following steps. Note that exceltex is included in the TeX Live distribution, and the installation may work without downloading the package

  1. Download exceltex.
  2. Install Spreadsheet::ParseExcel from CPAN (sudo -s cpan Spreadsheet::ParseExcel),
  3. Download the Makefile.PL from the Spreadsheet::Excel-source and placing it in the exceltex folder (I still had mine in my Downloads directory at this point, shouldn't pose a problem),
  4. Run perl Makefile.PL

When trying to run exceltex file.tex, I had problems with exceltex not finding the correct @INC path (or something). That is because OS X comes with its own Perl distribution, while my updated version is from MacPorts. My solution was to jump into the exceltex script and change the Perl call:

  1. sublime /opt/local/bin/exceltex (replace sublime with whichever editor you prefer)
  2. Change the first line of the script to: #!/opt/local/bin/perl -w

Now it should work! =)

share|improve this answer
(Repeated from comments below the question) What I do not understand: In TeX Live for Windows exceltex is already installed. It should also be included in the Mac version. – Speravir Apr 10 at 18:10
@Speravir Yeah, that's a point. I was not aware of this when I installed it. At first I just put exceltex.sty somewhere LaTeX would find it, but got error messages related to Spreadsheet:ParseExcel upon compilation. So exceltex might just be installed while Spreadsheet:ParseExcel is not. Try just installing the latter and see if the exceltex package from TeX Live repsonds? – Holene Apr 11 at 6:48

Not the answer you're looking for? Browse other questions tagged or ask your own question.