Installing/Using Exceltex

installing conversion exceltex

1,216

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

Download exceltex.
Install Spreadsheet::ParseExcel from CPAN (sudo -s cpan Spreadsheet::ParseExcel),
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),
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:

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

Now it should work! =)

1,216

N Nik

Updated on August 01, 2022

Comments

N Nik 5 months
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.
- egreg about 10 years
  
  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,
- krlmlr about 10 years
  
  Could you please post the link you are referring to?
- N Nik about 10 years
  
  I edited the post; now it has the link.
- N Nik about 10 years
  
  @egreg: Thanks for your help. I followed your suggestion and I got mktexlsr: Done. Now, exceltex is installed? I ran my latex file, still doesnt work. Can you please explain how I should use it? Thanks a lot
- egreg about 10 years
  
  @Nikandish Sorry, I know nothing of Excel (and I don't want to learn, either). My comment was only about where to put exceltex.sty in a safe place.
- Mensch about 10 years
  
  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.
- Mensch about 10 years
  
  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...
- Joseph Wright about 10 years
  
  @Nikandish Is the issue solved? If so, could you write up an answer?
- N Nik about 10 years
  
  @JosephWright: No, honestly, I gave up!
- Speravir over 9 years
  
  What I do not understand: In TeX Live for Windows exceltex is already installed. It should also be included in the Mac version.
Speravir over 9 years

(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.
Holene over 9 years

@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?