Graphics, Figures & Tables

artemff · Post by **artemff** » Wed Nov 25, 2009 12:42 am

What is the simplest method to move table from Excel to tabular or array of latex?

Learn LaTeX easily with newest books:

The LaTeX Beginner's Guide: 2nd edition and perfect for students writing a thesis

The LaTeX Cookbook: 2nd edition full of practical examples for mathematics, physics, chemistry, and more

LaTeX Graphics with TikZ: the first book about TikZ for perfect drawings in your LaTeX thesis

fatra2 · Post by **fatra2** » Wed Nov 25, 2009 9:28 am

A wonderful little macro call Excel2LaTeX. You can find it on the web.

The only little hick behind it, or advice I can give you is to store this macro in a safe place on your PC, somewhere you will not need to move anymore. Then open this macro with Excel. It will display a click button.

Once you have a table made in excel, you simply need to block it, click this button and it will automatically convert it to LaTeX tabular environment.

You might need to tweek very complex table once in a while. But all in all, it works great.

Cheers

Post by **josephwright** » Wed Nov 25, 2009 10:16 am

I'd recommend thinking carefully before blindly copying data from Excel to LaTeX. Excel is not really about good presentation: it's a calculation tool, and so does things very differently. If you do need data from Excel in LaTeX, consider exporting as .csv and using pgfplotstable to print it properly. But first consider what exactly you are presenting, and read the booktabs manual.

Faust · Post by **Faust** » Wed Nov 25, 2009 10:23 pm

Attached the file, in case you cant find it.

Its a sort of macro; gives you an extra button in Excel 'export to latex'

The selected cells are converted to Tex code, including borders and alignment. Very, very useful. Its called xl2latex (attached), but you can find it on the web too.

Works for me on Windows 7 64 bit; but wont work that well with Excel 2007 I guess. Im using 2004

magicmoose · Post by **magicmoose** » Thu Nov 26, 2009 1:14 am

I just tried it with Word 2007 and it did work nicely

fatra2 · Post by **fatra2** » Thu Nov 26, 2009 11:02 am

Hi there,

josephwright wrote:I'd recommend thinking carefully before blindly copying data from Excel to LaTeX. Excel is not really about good presentation: it's a calculation tool, and so does things very differently.

Since when is Excel a calculation tool. Excel is a spreasheet, made for presenting result of calculations for example. Excel does a great, but not as a calculation tool. If you are really looking for number crunching, I would recommend something like C/C++, Fortran, and other programming tools, way over Excel.

Cheers

nlct · Post by **nlct** » Thu Nov 26, 2009 12:10 pm

Another possiblity is to convert the xls file to csv and use datatool.

Regards
Nicola Talbot

LaTeX.org

Graphics, Figures & Tables ⇒ xls=>tex

xls=>tex

Re: xls=>tex

xls=>tex

Re: xls=>tex

Re: xls=>tex

xls=>tex

xls=>tex