While we're at it: character values in a MS Excel 97 file created via a
formula get imported to S-Plus as NA. Like several other bugs that I've
reported and MathSoft has acknowledged in S-Plus 4.5, this one persists in
S-Plus 2000.
I still find that simply exporting to a CSV file in Excel and importing to
S-Plus using read.table() is the most dependable method of getting Excel
data into S-plus.
------------------------------------------
Ed Callahan
Environmental Statistics
callahan@envstat.com
www.envstat.com
------------------------------------------
Ken Ryder wrote:
>
> I have come across other problems with importing Excel 97 files in S-Plus
> 2000.
> 1) ensuring the work sheet which I wish to import is the first in line, as
> there is no option to select which worksheet to read from and
> 2) S-Plus seems to ignore a columns which reference other worksheets via a
> function such a VLOOKUP.
>
> I have imported my Excel file into another stats package which allow
> selection of both worksheet and columns to read and then exported to
> another Excel file with one worksheet before importing into S-Plus.
-----------------------------------------------------------------------
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
|