Gregor Gorjanc has a post on Excel and LaTeX that lists four ways to convert and Excel table into LaTeX. I’ve used two of the methods he lists: brute force and excel2latex. I recommend excel2latex. I used it frequently until I upgraded to Office 2007 and the plug-in quit working. The only bug I remember with it was that sometimes it would give you a warning saying it didn’t work, but it did; the LaTeX code you wanted was waiting for you on the Windows clipboard.
I plan to try out Gregor’s other two suggestions. Creating tables in Excel is far easier than doing so in LaTeX and I miss the functionality that excel2latex provided. Maybe there’s a way to use excel2latex with Excel 2007. If you know of a way, please leave a comment.
{ 12 comments… read them below or add one }
John Johnson 09.16.08 at 08:13
Save the table as a .csv and write a perl script to do the conversion?
Ian Atkin 12.09.08 at 08:12
Hi there
The best solution I’ve found so far is to copy the table to Gnumeric and then save the file as a .tex table fragment, works a treat!
Ian
Matt Kizerian 02.27.09 at 10:58
If you’re open to jumping over to the OpenOffice side of the fence, at least to export your data, you might try the calc2latex macro from the OpenOffice website here. It works very nicely and gives you basic formatting options.
Yun 03.02.09 at 10:46
It works on Excel 2007 for me. After running the .xla file, the convert function can be found under the ‘Add-Ins’ tab, “Custom toolbars”.
Just another user 04.15.09 at 09:05
Works on Excel 2007 for me too. Just did exactly as Yun, and works like a charm!
Homecore 05.04.09 at 08:32
Did you guys do anything in particular? In which folder did you place the .xla file, for example? And did you try to convert from xls or xlsx files? Im’ getting a visual basic error: “compile error: cannot find project or library”. A visual basic screen is opened and the word “CurDir” is highlighted in the code. Did you guys have this problem?
Thanks!
ehud 06.26.09 at 07:36
Hi
I have the same problem getting the error: “compile error: cannot find project or library”. A visual basic screen is opened and the word “CurDir” is highlighted in the code.
Chris 10.16.09 at 17:12
Anyone have any ideas on how to get excel2latex running on excel 2007? I’m having the same issue — installing it results in an icon appearing under ad-ins, but simply pressing it opens up a visual basics sheet or something with the compile error. Is there a step we are just missing?
Ernest 10.22.09 at 09:38
I just installed it to Excel 2007. Just put the ‘.xla’ file in any folder preferably the add-in folder under “C:\Documents and Settings\\Application Data\Microsoft\AddIns\” then open up Excel > Office Button > Excel Options > Add-ins > Go and select it from the menu that appears, or browse to the folder where you put it. That should give you a button under Add-ins in Excel which works fine. At least it works for me. I am running Win XP.
JL 01.13.10 at 03:08
Hi,
For myself, having tried many aspects of excel2latex, and seeing that once a table is coded in Latex, it is very difficult to modify, I decided to do the following: I make a table in Excel, and format it the way I like, and then I just print it as a pdf file with pdf995, and then I add it to my Latex document as if it were a picture. Looks a bit less neat than real Latex tables though, but it’s the easiest way to do it I find.
Jeremie
Alex 01.27.10 at 04:15
I tried the ’solution’ from here:
http://www.idautomation.com/kb/vba-compile-error.html
Just remove the link to the missing package and it started working (on a little test-table).
Now I have to test it on bigger and more complex ones but for now it is working.
Oh, I am using win7 and excel2007 and excel2latex 2.1
Hope it helps anyone here.
thetrystero 02.15.10 at 09:33
unfortunately, mac office does not support visual basic macros. i use the built-in concatenate function in excel. requires a few keystrokes, but this is the quickest i’ve found.
=A1&” & “A2&”\\”