You can also use the LaTeX2RTF freeware program. ----- Original Message ----- From: Tennessee Carmel-Veilleux To: Paul Cvancara Cc: lyx-users Sent: Tuesday, July 27, 2010 4:16 PM Subject: Re: Import von Excel-Tabellen in Lyx
2010/7/27 Paul Cvancara <[email protected]> Sehr geehrte Damen und Herren, ich sitze zur Zeit an meiner Bachelorarbeit und versuche Messdaten, welche ich in Excel bearbeitet habe in Lyx zu importieren. Also besser gesagt, ganze Tabellen. Wenn ich die Tabelle kopiere und in einer Lyx-Tabelle einfügen möchte, dann werden alle Daten in eine Zelle kopiert. Wie schaffe ich es, dass Zelle für Zelle kopiert wird? Vielen Dank im Voraus für Ihre Antwort! Ich spreche nicht Deutsch, so die Antwort ist in Englisch. Verwenden Sie Microsoft Bing Language Tools (http://www.microsofttranslator.com) oder Google Translate (http://translate.google.com), um eine Übersetzung zu erhalten. I do not speak german, so the answer is in English. Use Microsoft Bing language tools (http://www.microsofttranslator.com) or Google Translate (http://translate.google.com) to get a translation. The question was basically: "How do I import tables from Excel into Lyx. When I copy&paste directly, it all goes in one cell". To import a table in LyX, you have to use the Import submenu of the File menu. There, you can import a "CSV" file (comma-separated values) which Excel can write. This will create a new LyX file with the table in it. From there you can cut and paste it. I have made an example screencast (see it at http://screencast.com/t/NThmOTBj) that shows the full process of conversion and reformating: 1.. I export the Excel file as a "CSV" file 2.. I show the resulting CSV file contents 3.. I import the CSV file in LyX 4.. I reformat the table (by default it has no lines) 5.. I change the language of the contents (it may not be the right language by default, which is why the cells have blue-underlined values) 6.. I copy & paste the new table in a LyX document Hope this helps. Best regards, Tennessee Carmel-Veilleux, ing. jr. Electrical engineering masters student, ETS (http://www.etsmtl.ca) Project AREXIMAS (http://areximas.etsmtl.ca)
