[EMAIL PROTECTED] wrote:

Hi, I'm using LyX 1.5.3 and have a situation where I need to put spreadsheet data into tables in LyX -- several of them actually. I'm able to paste the spreadsheet data into LyX. But so far I haven't figured out a way other than the tedious method of cutting and pasting every cell's contents one-by-one into place in the table.

Is there any way I can at least do columns or rows at a time if not a the whole block of columns and rows at once?

There is another option too.
Gnumeric can export a spreadsheet as latex code for a longtable.
This works for spreadsheets made with gnumeric, openoffice and excel.
The entire thing can then be imported by importing the latex file.

This works fine for text and numbers, I don't know about bar graphs and such.

I made an "external inset" that automates this process - there has been no
interest so far though.

Helge Hafting

Reply via email to