i have used excel almost exclusively to import data files and CSV is fine.
why dont you just go to the bottom of the excel sheet after you convert to
CSV and clean out the last rows, delete the end rows. also maybe try another
spread sheet program like open office, openoffice.org.
cls59 wrote:
>
Gabor Grothendieck wrote:
>
> That doesn't necessarily follow since the various methods don't use
> Excel itself to create the csv file.
>
I was trying to point out cases where I have seen this behavior and R wasn't
involved. Now that I think about it, I have observed to blank cells in a
Goo
That doesn't necessarily follow since the various methods don't use
Excel itself to create the csv file.
On Mon, Nov 16, 2009 at 1:22 PM, cls59 wrote:
>
>
> Gabor Grothendieck wrote:
>>
>> You could try one of the other methods of reading Excel files and see
>> if they are affected:
>>
>
> I woul
Gabor Grothendieck wrote:
>
> You could try one of the other methods of reading Excel files and see
> if they are affected:
>
I would guess that since Excel includes the blank rows when exporting to
CSV, then blank cells are being stored by Excel in the data files--
therefore any method of ext
You could try one of the other methods of reading Excel files and see
if they are affected:
http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows
On Mon, Nov 16, 2009 at 8:19 AM, anna_l wrote:
>
> Hello everybody, here is the code I use to read an excel file containing two
> rows,
Thanks Charlie, well yes it included one row with two NA datas. I guess there
is an explanation, let´s wait and see if someone knows more about it :)
cls59 wrote:
>
>
> anna_l wrote:
>>
>> Hello everybody, here is the code I use to read an excel file containing
>> two rows, one of date, the o
anna_l wrote:
>
> Hello everybody, here is the code I use to read an excel file containing
> two rows, one of date, the other of prices:
> library(RODBC)
> z <- odbcConnectExcel("SPX_HistoricalData.xls")
> datas <- sqlFetch(z,"Sheet1")
> close(z)
> It works pretty well but the
Hello everybody, here is the code I use to read an excel file containing two
rows, one of date, the other of prices:
library(RODBC)
z <- odbcConnectExcel("SPX_HistoricalData.xls")
datas <- sqlFetch(z,"Sheet1")
close(z)
It works pretty well but the only thing is that the dat
8 matches
Mail list logo