Discussion:
Import excel problems
(too old to reply)
Joseph Greenberg
2017-10-22 16:13:04 UTC
Permalink
I'm using GNU pspp 1.0.1-g818227 on Windows 10 64-bit.



When I try to import Excel data, the import screens do not preview the data
so I can't select which lines to import, which is the first line, which are
the separators, etc. The large panel is entirely blank. Any ideas?
Alan Mead
2017-10-22 20:29:27 UTC
Permalink
AFAIK, no Excel format is a supported format (but PSPP is open-source,
so feel free to write that missing functionality and contribute it to
our community).

I suggest that you save the excel file as a Tab-delimited, CSV or ODS
file and try importing that.  ODS would be the closest to the Excel formats.

Maybe you also found a bug: I just tried saving a small Excel file using
Office 2010 as "OpenDocument Spreadsheet format" and importing into GNU
pspp 0.10.4-g50f7b7 and I do see that there is a mostly blank screen at
the end of the import wizard. But I clicked "apply" and it imported OK.

If you think you might be seeing a bug (e.g., if by "import Excel data"
you do mean something like tab-delimited or CSV) then please be more
specific about the steps required to replicate the bug. Also include a
short dataset (or information that is OK to make public) that triggers
the bug, ideally as a plan ASCII (tab-delimited or CSV).

-Alan
I’m using GNU pspp 1.0.1-g818227 on Windows 10 64-bit.
 
When I try to import Excel data, the import screens do not preview the
data so I can’t select which lines to import, which is the first line,
which are the separators, etc. The large panel is entirely blank. Any
ideas?
 
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
--
Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.

science + technology = better workers

http://www.alanmead.org

I've... seen things you people wouldn't believe...
functions on fire in a copy of Orion.
I watched C-Sharp glitter in the dark near a programmable gate.
All those moments will be lost in time, like Ruby... on... Rails... Time for Pi.

--"The Register" user Alister, applying the famous
"Blade Runner" speech to software development
Loading...