Graphics, Figures & Tables ⇒ xls=>tex

[artemff]

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

[fatra2]

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

[josephwright]

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]

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]

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

[fatra2]

Hi there,

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]

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

Regards
Nicola Talbot