RE: Copying from Excel 97
- To: mathgroup@smc.vnet.net
- Subject: [mg11264] RE: [mg11232] Copying from Excel 97
- From: jmt <jmthomas@cybercable.tm.fr>
- Date: Wed, 4 Mar 1998 01:39:22 -0500
- Organization: TeA
You can try a package I wrote to read Excel97 .CSV files into Mathematica: ftp://tea.fr.eu.org Hope this helps ----------------------------------------------- Jean-Marie THOMAS Conseil et Audit en Ingenierie de Calcul www.cybercable.tm.fr/~jmthomas ------------------------------------------------ -----Message d'origine----- De: Lawrence Walker [SMTP:lwalker701@earthlink.net] Date: mardi 3 mars 1998 05:11 A: mathgroup@smc.vnet.net Objet: [mg11232] Copying from Excel 97 Hi, When I try copying a block of values from Excel 97 to Mathematica3 I get a list of numbers with the first entry of each row running together with the last number from the previous row. As a result I have to manually enter spaces between the numbers. For instance, given the following block of numbers in Excel (each in different cells): 1 2 3 4 5 6 7 8 9 If I copied the block and paste it into Mathematica then I would get... 1 2 34 5 67 8 9 After which I would have to edit the entry with separators. {1, 2, 3,4, 5, 6,7, 8, 9} For this case it was easy, but for large blocks of number this gets somewhat confusing. How do I prevent Mathematica or Excel from forcing numbers to run together? Thanks, Lawrence