Graphics, Figures & Tables ⇒ Import Excel tables

[localghost]

For OpenOffice.org (OOo) there is the Calc2LaTeX macro. But it is only save for work with OOo version 2.0 and earlier.

I'm using Latable but I'm having problems. I save my file in CVS format and after I open the file with Latable but the columns remains in just one column. I don't Understand Why. I've experimented other possibilities to do the same but nothings worked.

If you are willing to provide the CSV file, we could try our luck with latable.

[tdcpina]

Thanks for your sugestions. Anyway I attach the CSV file. If Latable works seems the easiest method.

Best regards,
Tiago

[tdcpina]

Hi,

The macro Excel2latex works perfectly in the computers of my friends. In my office it doesn't work I don't know Why.

Thanks a lot for the suggestions of all of you,
Tiago

[localghost]

[…] The macro Excel2latex works perfectly in the computers of my friends. In my office it doesn't work I don't know Why. […]

Presumably the functionality of the macro depends on the Excel version.

Thanks for your sugestions. Anyway I attach the CSV file. If Latable works seems the easiest method.

Sorry for the long delay and the belated response. I installed LaTable, but there are more bad news to come.

Installation was no big deal. After getting the provided CSV file I started importing it. In the import dialog I choose the semicolon as cell delimiter. The dialog window is very in that.

Import dialog of LaTable.

LaTable-Import.png (19.76 KiB) Viewed 4738 times

But the import doesn't work as expected. I thought that by choosing this setting I would get code ready to copy into a document. But the code preview tells me something else.

Code preview window of LaTable.

LaTable-CodePreview.png (15.42 KiB) Viewed 4738 times

As you can see, there is nothing done to the LaTeX code. The cell delimiters have not been transformed to the alignment character "&" and there is no correct number of columns generated. And it seems that there is no possibility for editing the code except copying it as LaTeX code.

Editing options of LaTable.

LaTable-Edit.png (26.05 KiB) Viewed 4738 times

Finally this is very disappointing and I have to withdraw my recommendation. Moreover the program is rather old.

Version information of LaTable.

LaTable-About.png (10.29 KiB) Viewed 4738 times

Another bad circumstance is the the homepage of the software is down and there seems to be no other source where to get a newer version.

The bottom line is that this program is not the appropriate solution for importing tables from other formats.

I also tested the formerly mentioned Calc2LaTeX macro for OpenOffice.org (OOo). But the latest version is also about four years old and doesn't work with current versions of OOo.

[tdcpina]

I've remarked the same thing with Latable. In respect to Open office... I've searched more recent macros to Open Office but without success.

I solved my problem with Gnumeric. Gnumeric can read excel and open office formats and permits saving documents in Tex. It's very good and works perfectly.

Cheers,
Tiago

[oabcxp]

Yes, you can export tables from excel to LaTeX. Previously I had used excel2latex addon of excel to import selected tables in latex but I had to modify the LaTeX codes according to my requirement.

Later, I accidentally came to know a beautiful GUI tool for importing excel tables to LaTeX and modifying the table according to the requirement in a What You See Is What You Get fashion. The tool is LaTable. Just simply select your excel table and paste it to LaTable. Then modify the table like bordering cell, merging horizontal cells, text alignment etc and then copy LaTeX code for table into your LaTeX editor. The details about it is given in my blog with pictures as well.
Here's the link http://zigzag00.blogspot.com/2010/08/la ... es-in.html.

I think LaTable is the best tool for you.

With best regards,
Yubaraj