Displaying 20 results from an estimated 10000 matches similar to: "I have some compatibility questions"
2012 Apr 20
1
odbcConnectExcel() fails to fetch all columns
Folks,
Is there a parameter somewhere in RODBC that enables more columns to be
retrieved from an Excel worksheet?
# This next bit uses an undocumented call in RODBC
z <- odbcConnectExcel("./BBaselinePtQaires_apr2011.xls")
BQ <- sqlFetch(z, "BBaselinePtQaires")
Gives me:
z RODBC[1]
And
BQ 134 obs. of 59 variables
I have all the rows in the worksheet but only the
2006 Jun 29
1
RCOM Package
Hi list,
I just installed the rcom package and tried to read/give out some values
from/to Excel. Altogether it works great... but nevertheless I don't know
how the syntax works or in other words: "Which command needs which
parameters?"
Is there somwhere a manual about this package with good examples? I've read
the Package description... but there are not really good
2011 Jun 14
3
Read in from multiple Excel wksheets
I?ve got an Excel workbook with about 30 worksheets. Each worksheet
has 10000 rows of data over 30 columns.
I?d like to read the data from each worksheet into a dataframe or
matrix in R for processing. Normally, I use read.csv when interacting
with Excel but I?d rather manipulate a multisheet workbook directly
than set about splitting the original workbook and saving down each
part as a csv.
2004 Mar 02
2
Import range of cells from Excel
Dear all,
I would like to import a range of cells (e.g. F10:K234) from an Excel
worksheet to R. I have looked for documentation on RODBC and RDCOMClient but
I was not able to find enough information to solve my problem and all the
examples I have seen were dealing with an entire worksheet, not a range of
cells.
Thanks,
Jean-Noel
Jean-Noel Candau
INRA - Unit? de Recherches Foresti?res
2011 Jul 10
3
OpenOffice ods spreadsheets in R?
I would like to open OpenOffice (LibreOffice) .ods files in R. I've
tried the ROpenOffice package from omegahat, but unfortunately, the
read.ods() function attempts to use the values of the first column in a
worksheet as row names, and thus does not allow duplicates in there
(which, even more unfortunately, occur in my files). Also, the function
does not allow to forward any other
2010 Oct 13
2
Read Particular Cells within Excel
Hello all,
I have a business user who generates monthly reports in MS Excel in a particular
format. The data I need is present in different portions of this excel file. Is
there a way to read different cells from a particular excel worksheet? i.e.,
cells b50:d100 in the Inputs worksheet. I am investigating odbcConnectExcel but
did not yet see such capability.
Appreciate your help.
Jeevan
2012 Feb 12
2
Reading data from a worksheet on the Internet
Dear R-users,
I have to read data from a worksheet that is available on the Internet. I
have been doing this by copying the worksheet from the browser.
But I would like to be able to copy the data automatically using the url
command.
But when using "url" command the result is the source code, I mean, a html
code.
I see that the data I need is in the source code but before thinking
2009 Mar 12
1
read.xls and name of worksheet
Hi,
I would like to some excel files with some worksheets. I tried this with
the following R script:
library(gdata)
i<-1
rc<-0
while(rc != "try-error") {
wksh<-try(read.xls("cluster-microarray-FW.xls",sheet=i,verbose=TRUE,perl="perl"))
rc<-class(wksh)
print(sprintf("------- i=%2d rc=%s ---------------",i,rc))
if (rc !=
2007 Feb 09
1
append within worksheet in write.xls
I can currently append an entire worksheet with write.xls, but would
also like to be able to append within the same worksheet. Is this
possible? It doesn't seem to work if I use append = T
Thanks,
Mark
--
Mark W. Kimpel MD
Neuroinformatics
Department of Psychiatry
Indiana University School of Medicine
2013 Feb 11
1
Putting an array from excel into R Studio
Dear All,
I have been using RExcel for some time and find two features especially useful:
i) The ability to select part of a worksheet and put it into R
ii) The way of viewing the code, the output and the alerts in separate panes.
The rest of R Excel I don't really use.
The major benefit for me is i) as I can use the excel as a sort of
fast access database which is convenient to edit. I can
2011 Jun 24
3
extract worksheet names from an Excel file
Hi list,
Is there a R function I can use to extract the worksheet names from an Excel file?? If no, any other automatic ways (not using R) to do this?
thanks!
...Tao
2001 Mar 10
1
wine-20010305 MS Excel97 *.xls -> .xls.xls
Hi,
If I open up a worksheet in MS Excel 97, the file name is modified
by appending an extra .xls to the name. Multiple .xls's are possible,
and it is not necessary to save the worksheet.
I'm running Wine-20010305 compiled on a SuSE 7.0 running a stock
2.4.2 Linux kernel. MS Excel is being run from an existing Win98
system partition.
Thought someone might want to know,
Dick
--
2005 Jun 30
1
Trouble with Excel table connection
Hello,
I've been using odbcConnectExcel to connect to a spreadsheet database
containing a single worksheet. Unfortunately when I try to access the
data R cannot see the table. When I run sqlTables it shows the worksheet
as a SYSTEM TABLE instead of as a TABLE that I can access. I am fairly
certain that I am do all of the same things I've done in the past when
it worked just fine.
2008 Mar 20
2
I need help integrating ggplot2 into Excel
Dear all
I use ggplot2 extensively for my plotting routines and rexcel to have the
best of two worlds. (RExcel v 1.75 and R (D)Com v. 2.5)
I can run my ggplot functions, such as qplot(...), in scratchpad mode, but
not in Macro nor Worksheet functions mode.
I have tried the following in Macro mode:
Call RInterface.RRun("library(ggplot2)")
...
Call
2010 Mar 17
3
rails+prawnto: setting :type to :prawn in a #render_to_string call not working
Hello, my question is rails related though it is also somewhat
specific to the prawnto plugin (installed latest version as of
2010-03-15). I would ask on a prawnto forum/list if I knew where one
was.
Anyhow, I''m using rails 2.3.5 (with ruby 1.8.6 patchlevel 111) in an
app that is successfully using the prawnto gem (with the prawn gem
version 0.7.1). I''ve got a a
2010 Nov 22
4
Rexcel
Hello I am new to RExcel and I would like to run a source code form the
excel worksheet. I would like to run the following code
source("C:\\Quantil Aplicativos\\Genercauca\\BackwardSelectionNC.r")
from the excel wroksheet. Does anybody know how to do this?
Thank you
Felipe Parra
[[alternative HTML version deleted]]
2007 Feb 09
1
newline with cell of Excel worksheet created with write.xls
As part of my project to put different types of results into worksheets,
I would like to be able to put an auto-generated methods section. If I
compose in RWinEdt, read into R, and use write.table with a .txt file
extension, what I get out has line-breaks that correspond to those I put
in in the first place.
If I do the same thing but write.xls with .xls extention, I get an Excel
worksheet
2010 Feb 16
2
Issue with trying to dial two different servers at the same time.
Okay, so my issue isn't really a technical one but more of needing
advice on the best way to program this. I have a user in Colorado who
works from home but frequents our office in Colorado. All of our
remote users connect to a server in Dallas the users at the HQ in
Colorado connect to a separate server in the Colorado office that is
on the private network. I have an IAX trunk between the
2002 Jul 05
1
[jlevine@utcnist.colorado.edu: Privilege separation]
Is this a known problem?
Niels.
----- Forwarded message from Judah Levine <jlevine at utcnist.colorado.edu> -----
Date: Fri, 5 Jul 2002 08:58:46 -0600 (MDT)
From: Judah Levine <jlevine at utcnist.colorado.edu>
To: provos at citi.umich.edu
Subject: Privilege separation
Hello,
I have just installed openssh-3.4p1 on a COMPAQ/DEC/HP Alpha running
True64 UNIX v4.0F. The privilege
2009 Nov 19
1
Problem with sqlSave
Hello, the sqlSave function is used in order to write a dataframe on excel.
This function creates worksheets using the attribute tablename and writes
the data.frame in it. What I want to do is to create this data.frame but
being able in case this worksheet already exists to delete the former datas
and write the new ones in it. I used the safer and append attributes. When
you set safer to false,