Re: PSPP and excel

[John Darrington]

Here is the way I import a spreadsheet file into pspp:

1. Using Gnumeric, I save it as a native gnumeric file.  Let us
   assume it has the name "Book1.gnumeric".

2. From PSPP, I can then import it with the command:
   GET DATA /TYPE=GNM /FILE='Book1.gnumeric'.

For simple cases it's as easy as that.  If your spreadsheet is more 
complicated, you may have to give it a /SHEET and /CELLRANGE subcommand.
See the section in the user manual entitled "Spreadsheet Files".

J'


On Fri, Feb 10, 2012 at 09:17:30AM +0100, Gaia Vicenzi wrote:
     
     -----------------------------------------------------
     Gaia Vicenzi, Ph.D.
     psicologa psicoterapeuta cognitivo comportamentale 
     viale Golgi, 48 
     27100 Pavia 
     www.gaiavicenzi.com
     cell. 338 3889474 
     ------------------------- 
     AVVERTENZA: La presente comunicazione ? confidenziale, tutelata dal 
segreto 
     professionale e strettamente riservata a chi ? esplicitamente indicato 
come 
     destinatario della stessa. Ogni indebita diffusione, anche parziale, di 
ci? 
     che la stessa contiene ed esprime, pu? essere sanzionata. 
     Dear all, i gave some trouble in importing in PSPP excel data.
     I know that there can exist three methods in order tu succed in it:
     
     1. Open the excel file using Gnumeric or LibreOffice.  Then save as the 
native
        format.  Pspp can read both gnumeric and OpenDocument spreadsheets.
     
     2. Using excel, save the file as comma seperated values, and import that 
into
        pspp.
     
     3. If it's a small dataset, a simple Copy and Paste should work.
     
     The 3rd doesn't work,
     I can't understand the second.
     Abou the first, I've downloaded gnumeric but, when I open PSPP, appears 
just
     an empty window.
     
     Could you help me?
     
     Regards,
     Gaia Vicenzi

     _______________________________________________
     Pspp-users mailing list
     address@hidden
     https://lists.gnu.org/mailman/listinfo/pspp-users


-- 
PGP Public key ID: 1024D/2DE827B3 
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See http://keys.gnupg.net or any PGP keyserver for public key.

signature.asc
Description: Digital signature