Table from Numbers to LateX

Question

Level 1

5 points

Table from Numbers to LateX

Is there any way to export a table in numbers to latex-code?
On Windows, you can use excel2latex, but since Excel for mac doesn't support visual basic macro's, this doesn't work with Excel 2008 for mac.
Entering a table in latex is too much work if you 're working with large tables.

So I'm looking for a way to use Numbers for entering the data (and for applying layout preferences such as lines between the data, outline, bold/italic,..), and exporting the whole to latex-code. Since it's possible on Windows with Excel, I guess it's not impossible.

Macbook, Mac OS X (10.5.7)

Posted on Jun 11, 2009 1:00 AM

Reply

Answer 1

Badunit

Level 7

30,708 points

Jun 11, 2009 5:57 AM in response to jefkool

I never heard of LaTeX until just now. The wiki was an interesting read. I couldn't tell from the excel2latex site what exactly gets converted; does it convert just the data (cells) or does it also convert the lines (cell borders)? If you are only concerned about the cells, from browsing the web it looks like you might be able to export from Numbers to a CSV file and import into LaTeX that way. One link I found is below. Again, this is beyond my knowledge so I apologize in advance if it isn't helpful.

http://brouits.free.fr/csv2latex/

Reply

Answer 2

bhh48

Level 1

60 points

Jun 12, 2009 2:09 AM in response to jefkool

I use LaTeX frequently. I don't use Numbers.
The csv2latex program mentioned by others is certainly an option.
But AFAIK no layout information such as bold, italic, etc is written to a csv file.
Maybe Applescript could do the trick but then you would have to be able to get hold of layout information from Numbers; I don't know if that is possible.
You could also consider one of the scripting languages such as Perl, Python or Ruby to do what you want.

Berend

Reply

Answer 3

Jun 12, 2009 8:36 AM in response to jefkool

I would recommend you to use LyX (www.lyx.org) as a frontend for latex. LyX makes it easy to make tables in latex.

Reply

Answer 4

jefkool Author

Level 1

5 points

Jun 12, 2009 10:23 AM in response to bhh48

The Mac version for csvtolatex is is an old PowerPC program 😟 And also it doesn't copy the layout..

I was hoping that somebody else had already scripted something that could help me, in Applescript or some other programming language, because I've only got a little knowledge of Java and that's not quite the right programming language for this problem :P

Reply