Hi Mike,
Following your suggestion, I read the .csv file that I saved from Excel as
.csv, into Notepad and it was there as expected.
The interesting thing is that after saving the file as .csv and looking at
it in explorer, it has an Excel logo on it. So dubl clicking just brought it
up as another Excel spreadsheet.
But opening it with notepad, gave me what I was looking for.
Then I was able to get it into R:Base.
So thanks for your help!
Bernie Lis
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, June 14, 2008 10:42 AM
Subject: [RBASE-L] - Re: Gateway error importing .xls file
----- Original Message -----
From: "Bernard Lis" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, June 14, 2008 10:32 AM
Subject: [RBASE-L] - Re: Gateway error importing .xls file
Hi Mike,
I get the same error whether I use workbook or spreadsheet.
When I try to export from excel as csv, it creates another excel
It doesn't mean anything special because the "File Association" for *.csv
is set to Excel as Excel can read *.csv files natively.
An exported CSV file is still just that, a CSV file. If you would turn
off "hide file extensions of known FileTypes" in your Windows Folder
settings:
Windows Explorer>Tools>Folder Options>View>Hiden Files and Folders>hide
file extensions of known File Types
Then you would see that the Exported file has the CSV extension. Also,
just open it with Notepad and take a look.
spreadsheet -- I don't understand why that is so.
Bernie
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, June 14, 2008 7:34 AM
Subject: [RBASE-L] - Re: Gateway error importing .xls file
Have you tried importing an "Excel WorkBook" as opposed to an "Excel
SpreadSheet" ?
----- Original Message -----
From: "Bernard Lis" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, June 13, 2008 9:08 PM
Subject: [RBASE-L] - Gateway error importing .xls file
Hi Experts,
I have an Excel spreadsheet and when trying to import it I get the
following error:
Invalid variant type.
There are 3 sheets but sheets 2 and 3 are empty,
I only want to import from sheet 1
What should I look for?
Bernie Lis
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to
search for.
================================================
