Others ⇒ Excel to LaTeX

[MatthiasN]

Hi everyone,

this may sound stupid, but the last hour or so I've been trying to insert a macro in excel to convert tables in excel to LaTeX code. I've found the macro here: ftp://cam.ctan.org/tex-archive/support/xl2latex/. A university linked me to it, so it should be alright.

Now the problem I'm having is that I use Excel 2010 and apparently the way to insert a macro is completely different than when you use Excel 2007 or any older version. I have been looking for a while, searching every tab and looking on the internet. But the only thing I find is how to use a macro that is already present in excel, but not how to import one (at least not for the 2010 version).

So I really hope someone can help me.

Greetings,

Matthias

[mas]

No idea about excel macros as I do not use MS Office. But, this is an idea you can try. Why not export your cells/table to a csv file with "&" as the separator? All that remains to be done is to just add the tabular definitions in the file.

Regards.

[nlct]

You could also just export to csv and use the datatool package.

Regards
Nicola Talbot

[MatthiasN]

I can do that, but then I might as well make the table in LaTeX. The reason I would like to use this macro, is because it doesn't only make the table with everything you put in it, but it also takes over the complete layout.

[eric-wood]

I never managed to get Excel plugins to do this working, so I wrote my own utility:

http://ericwood.org/excel2latex/

Just drag the Excel file onto the page and it'll spit out the LaTeX code for the table! No need to install anything.

It's still kind of new and I'm working out some kinks, but for the stuff I've been using it for it's been doing a great job.

Hope that helps!

[bebelher]

You can also download excel2latex, and move it to :

Code: Select all

1
C:\Users\[USER]\AppData\Roaming\Microsoft\AddIns
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

or

Code: Select all

1
C:\Documents and Settings\[USER]\Application Data\Microsoft\AddIns
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

It should appear now in Excel !

[dota_m4n]

I have a simple method.

Put the excel table that you want to export alone on an excel sheet. Export it to PDF. Crop the pdf to only include the actual table. I use a program called inkspace. In inkspace I simply open the pdf and then press save as pdf. I tick the "file is drawing" and it automatically crops it. Include your cropped table using ./includegraphics in latex. Images based on pdf come out with good quality, pictures and tables alike.

[Johannes_B]

Just to be sure, do you mean Inkscape?

[dota_m4n]

Inkscape is the one.