s-news
[Top] [All Lists]

RE: [S] S-PLUS4.5 import from Excel truncations

To: "'John Maindonald'" <john.maindonald@anu.edu.au>, <s-news@wubios.wustl.edu>
Subject: RE: [S] S-PLUS4.5 import from Excel truncations
From: "J Youngman" <youngman@eisa.net.au>
Date: Fri, 30 Apr 1999 21:10:15 +1000
Importance: Normal
In-reply-to: <199904300555.PAA06767@leonard.anu.edu.au>
Reply-to: <youngman@eisa.net.au>
Sender: owner-s-news@wubios.wustl.edu
John Maindonald wrote:
>
> Now I find that the dataset likewise gets truncated, to 16383 rows
> (additional to the heading).  If one specifies more than 16384 rows,
> then the additional rows are filled with NAs.  It is not nice.
> If one species e. g. rows 16485:18086, import.data responds that
> it cannot find these rows.  At least one is in this case warned
> that something is wring.
>
> I presume import.data is using some register that can spare only
> 14 bits.
>
This looks to me as though S-Plus has been designed for Excel 95 or earlier
with a maximum of 16K rows. I use an Excel add-in, purportedly written for
Excel 97, that does the same thing.

Jim Youngman
Melbourne, Australia

-----------------------------------------------------------------------
This message was distributed by s-news@wubios.wustl.edu.  To unsubscribe
send e-mail to s-news-request@wubios.wustl.edu with the BODY of the
message:  unsubscribe s-news

<Prev in Thread] Current Thread [Next in Thread>