Re: Excell to PSPP direct?

[John Darrington]

On Fri, Feb 14, 2014 at 07:30:06PM +0530, Thambu David wrote:

     Is it possible for PSPP to directly import files from Excell without 
making them CSV-often this does not seem v straightforward

Importing directly from Excel is not possible. So you have to convert to 
*something*.
Something could include CSV, ODT, Gnumeric or HTML.

     It would make implementing this as a SPSS alternate much easier
     Most students and faculty are looking for a legal free alternate,but this 
is one area of difficulty

One way to mitigate this difficulty would be to encourage your students to 
use either Libreoffice/Openoffice or Gnumeric.  (In a few weeks' time there is 
the 
international "Document Freedom Day" 
https://en.wikipedia.org/wiki/Document_Freedom_Day - 
this would be an ideal time for them to make the change!)

     I hope the plan for this year could include this (if possible) being added 
to the to-do list

There are dozens of mutually incompatble "excel" formats which microsoft have 
developed in the 
past.  It is possible that in the future, import from the more recent XML based 
one (I forget what 
it is called) may be feasible in PSPP, but the other ones seem unlikely.  
Exporting to excel 
formats is equally unlikely.

Just as PSPP is a free replacement for SPSS, Libreoffice is a free replacement 
for Excel (which CAN read native excel docs) so by using the free programs, you 
win both ways!

J'

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

signature.asc
Description: Digital signature