Re: Import von Excel-Tabellen in Lyx
"Paul Cvancara" wrote: > 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? - as already was written in a reply, export to csv then import, or - use excel2latex http://dante.ctan.org/tex-archive/help/Catalogue/entries/excel2latex.html A possible problem and its solution is discussed in http://www.latex-community.org/forum/viewtopic.php?f=5&p=28364 HTH -- Wilfried Hennings
Re: Import von Excel-Tabellen in Lyx
Open-source, of course... - Original Message - From: "Liviu Andronic" To: Sent: Wednesday, July 28, 2010 10:10 AM Subject: Re: Import von Excel-Tabellen in Lyx On Tue, 27 Jul 2010 18:32:27 +0200 "Yago" wrote: You can also use the LaTeX2RTF freeware program. Open-source, I believe. Some may get picky on the differences from freeware. Liviu
Re: Import von Excel-Tabellen in Lyx
On Tue, 27 Jul 2010 10:16:00 -0400 Tennessee Carmel-Veilleux wrote: > 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. > Other than the CSV route, there was some recent discussions about incorporating an external inset for spreadsheets. Search the archives for more info. Liviu
Re: Import von Excel-Tabellen in Lyx
On Tue, 27 Jul 2010 18:32:27 +0200 "Yago" wrote: > You can also use the LaTeX2RTF freeware program. > Open-source, I believe. Some may get picky on the differences from freeware. Liviu
Re: Import von Excel-Tabellen in Lyx
On 27 July 2010 10:57, Paul Cvancara wrote: > Hi! > Thanks for your quick answer. Now there is another problem... If I want to > import the CSV-file, lyx shows following problem: > "test.lyx was created by another lyx-version, but the lyx2lyx-script > couldn't convert the document" (I hope the translation is correct). > But the problem is, that I am using the newest lyx-version. Do you know > where the problem is? > > The script that was called to do the conversion might have been from a previous version of LyX. This error should not occur. Can you give us the Table (CSV) -> LyX converter configuration command (Menu Preferences:File Handling:Converters), your actual LyX version from the "Help:About" menu and whether your LYX_HOME/Resources/scripts/csv2lyx.py contains the string "#csv2lyx created this file \lyxformat 276" ? My screencast was made with LyX 1.6.7 and my CSV to LyX command configuration was "python -tt $$s/scripts/csv2lyx.py $$i $$o". The intermediate file created by the csv2lyx.py script should be of a format compatible with your current LyX, which would mean that lyx2lyx never would need to be called. lyx2lyx would be called if you were converting from a file created by an older version of LyX, which should not be the case. Best regards, Tennessee Carmel-Veilleux, EIT Electrical engineering masters student, ETS (http://www.etsmtl.ca) Project AREXIMAS (http://areximas.etsmtl.ca)
Re: Import von Excel-Tabellen in Lyx
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 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)
Re: Import von Excel-Tabellen in Lyx
2010/7/27 Paul Cvancara > 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)
Import von Excel-Tabellen in Lyx
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! Mit freundlichen Grüßen, Paul Cvancara
