Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[S\]\s+Re\:\s+Excel\s+Import\s+Problem\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[S\]\s+Re\:\s+Excel\s+Import\s+Problem\s*$/: 7 ]

Total 7 documents matching your query.

1. [S] Re: Excel Import Problem (score: 1): Author: "Peter Wollan" <wollan@mayo.edu>; Date: Tue, 28 Sep 1999 09:08:20 -0500; Another problem with importing from Excel: if a column is mostly numeric, but has a few character values somewhere in the middle, S-plus imports the column as numeric and replaces the characters with; /archives/html/s-news/1999-09/msg00264.html (10,356 bytes)
2. RE: [S] Re: Excel Import Problem (score: 1): Author: "David O. Nelson" <daven@llnl.gov>; Date: Tue, 28 Sep 1999 07:52:49 -0700; There are at least 3 of us. I reported a similar problem in S-PLUS some months ago relating to importing into data FRAMES with missing values in the last few rows of some columns. Statsci asked me fo; /archives/html/s-news/1999-09/msg00265.html (8,896 bytes)
3. RE: [S] Re: Excel Import Problem (score: 1): Author: "Michael Conklin" <mconklin@customresearch.com>; Date: Tue, 28 Sep 1999 10:08:57 -0500; More flexibility in import options would be appreciated in more than just Excel. The ability to force all imported data to be "character" (and not made into factors) would be a step in the right dire; /archives/html/s-news/1999-09/msg00266.html (9,818 bytes)
4. Re: [S] Re: Excel Import Problem (score: 1): Author: Frank E Harrell Jr <fharrell@virginia.edu>; Date: Tue, 28 Sep 1999 12:02:59 -0400; The Hmisc library has a little function cleanup.import that when run on a data imported from an Excel spreadsheet will clear up this kind of problem plus a few others, as well as make the data frame; /archives/html/s-news/1999-09/msg00269.html (12,438 bytes)
5. Re: [S] Re: Excel Import Problem (score: 1): Author: John Maindonald <john.maindonald@anu.edu.au>; Date: Wed, 29 Sep 1999 08:52:52 +1000 (EST); Are you using S-PLUS4 or 4.5, or 2000? In version 4.5 it appeared that the contents of the first row determined the mode for the whole column. It ignores (at all events with Excel 97) rows beyond num; /archives/html/s-news/1999-09/msg00270.html (9,633 bytes)
6. [S] Re: Excel Import Problem (score: 1): Author: Ken Ryder <ryder@icrf.icnet.uk>; Date: Wed, 29 Sep 1999 09:13:16 +0100; I have come across other problems with importing Excel 97 files in S-Plus 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 re; /archives/html/s-news/1999-09/msg00275.html (7,861 bytes)
7. [S] Re: Excel Import Problem (score: 1): Author: "Ed Callahan" <lists@envstat.com>; Date: Wed, 29 Sep 1999 12:17:26 -0500; 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, t; /archives/html/s-news/1999-09/msg00279.html (8,938 bytes)

Current List: 1 - 7
Page: [1]