Is it possible to paste tables from MS Excel into LyX, like into MS Word?
LyX ⇒ MS Excel table in LyX
MS Excel table in LyX
I've got a question and I hope you will help me
Is it possible to paste tables from MS Excel into LyX, like into MS Word?
Is it possible to paste tables from MS Excel into LyX, like into MS Word?
NEW: TikZ book now 40% off at Amazon.com for a short time.
And: Currently, Packt sells ebooks for $4.99 each if you buy 5 of their over 1000 ebooks. If you choose only a single one, $9.99. How about combining 3 LaTeX books with Python, gnuplot, mathplotlib, Matlab, ChatGPT or other AI books? Epub and PDF. Bundle (3 books, add more for higher discount): https://packt.link/MDH5p
-
scottkosty
- Site Moderator
- Posts: 542
- Joined: Sat Sep 01, 2012 6:38 am
Re: MS Excel table in LyX
Hi kielon,
1. In LyX, insert a table with the same dimensions as the one in the excel.
2. Place the mouse cursor in the top left cell of the table.
3. From the menu of LyX, choose Edit → Paste Special → Plain Text, Join Lines.
I took the above from http://www3.nd.edu/~zzhang4/doku.php?id ... cel_to_lyx which in turn was linked to from https://twitter.com/imLinJ/status/394782205022437376
However, note that is never I good idea to paste. You should link the two documents so that if you change one the other is automatically updated. You can do this with an Excel spreadsheet if you have Gnumeric. In LyX, go to Insert > File > External Material and use the Template "Spreadsheet".
1. In LyX, insert a table with the same dimensions as the one in the excel.
2. Place the mouse cursor in the top left cell of the table.
3. From the menu of LyX, choose Edit → Paste Special → Plain Text, Join Lines.
I took the above from http://www3.nd.edu/~zzhang4/doku.php?id ... cel_to_lyx which in turn was linked to from https://twitter.com/imLinJ/status/394782205022437376
However, note that is never I good idea to paste. You should link the two documents so that if you change one the other is automatically updated. You can do this with an Excel spreadsheet if you have Gnumeric. In LyX, go to Insert > File > External Material and use the Template "Spreadsheet".
Re: MS Excel table in LyX
Thanks, now that works.