Displaying 20 results from an estimated 600 matches similar to: "RCOM Package"
2007 Dec 14
4
rcom close Excel problem
Hello,
I just discovered that I cannot close the Excel application and task
manager shows numerous copies of Excel.exe
I tried both
x$Quit() # shown in the rcom archive
and
x$Exit()
and Excel refuses to die.
Thank you very much.
S.
"You can't kill me, I will not die" Mojo Nixon
I also have a problem with saving. It produces a pop-up dialog and
does
not take my second
2009 Aug 18
2
(no subject)
Dear all,
I have a problem with the function read.xls from the gdata package, error message see below. Two examples:
First, I try to read my data, which does not work;
Secondly, I tried the example code/data with the Iris data, which worked
Any idea?
Thanks,
Lars
> path<-"I:/subProjects/bh/HPGD/"
>
> setwd(path)
>
> xls <- "Platten_Liste_090421.xls"
2009 Sep 15
0
chinese character support issue of rcom
Dear Sir,
rcom is a great package of R. Yet it seems that there is some problem of
Chinese character supporting.
comGetPropery() always get the part of the Chinese character.
Any suggestion would be appreciated.
Thanks.
Michael
> library(rcom)
Loading required package: rscproxy
> txe<-comCreateObject("Excel.Application")
> comSetProperty(txe,"Visible",TRUE);
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 !=
2010 Apr 29
1
UpdateLinks = FALSE
Hi,
I'm reading 100s of excel files and many of them contain links to external files (I hate that, but that aside). Every time such a file is opened, a menu pops up asking if I want to update the links. I never want to update the links. I used the macro recorder to see what code would be needed to suppress that message, but to no avail (I tried more variations, but one attempt is shown
2010 Oct 01
0
Populating values in a PowerPoint table
Dear R-help,
I managed (thanks to the R2PPT package) to create a PowerPoint
presentation and create a table in it but for the life of me I can't
find a way to populate the table with values and text. I'm aware of
the function 'PPT.AddDataFrame' which creates an Excel object from a
data frame, but the excel object is not nearly as nice looking and
easy to manipulate (and apply
2012 Jun 20
2
passing function parameters into a 'with' statement to dynamically pick out columns
Hi,
I've built a function to generate plots and would like to be able pass in column names as a parameter. Here's a boiled down version of what I have right now:
pmts <- data.frame(date=c(1,2,3), all=c(5,6,7),maj=c(4,5,6),ind=c(3,4,5))
perc.mktshare <- function(df){
range1 <- floor(min(with(df, 100*ind/all)))
range2 <- ceiling(max(with(df, 100*ind/all)))
2013 Feb 18
2
error: Error in if (is.na(f0$objective)) { : argument is of length zero
Dear all,
I tried running the following syntax but it keeps running for about 4 hours
and then i got the following errors:
Error in if (is.na(f0$objective)) { : argument is of length zero
In addition: Warning message:
In is.na(f0$objective) :
is.na() applied to non-(list or vector) of type 'NULL'
Here is the syntax itself:
library('nloptr')
library('pracma')
#
2012 Aug 02
5
IP range
Hi all
Can someone explain me this:
ifcfg-eth0-range1:
ONBOOT="yes"
IPADDR_START="192.168.1.48"
IPADDR_END="192.168.1.55"
CLONENUM_START="1"
Why Bcast is 192.168.1.51 and why Mask is 255.255.255.252 ?
OS: Centos 6.3/64bit
Thanks
Levi
# ifconfig
eth0:1 Link encap:Ethernet HWaddr 00:9C:02:99:FA:00
inet addr:192.168.1.48
2015 Jan 11
1
Help with IPv6 /48 block
On 1/10/2015 8:38 PM, Gordon Messmer wrote:
> On 01/10/2015 08:10 PM, F. Mendez wrote:
>> Hello. Yes I confirm...its a /48 (this guys are crazy here at my
>> work...).
>
> It's not crazy, that's the standard deployment for a building. It's
> almost certainly not possible to use all of the addresses in such a
> space, but that's the point. IPv6 is
2006 Nov 23
0
W3C Range specification conceptually flawed?
hi all!
check this one:
<html>
<head>
<title>Range test</title>
</head>
<body>
<div id="myText">FooBarBaz</div>
<script type="text/javascript">
myText = document.getElementById(''myText'').firstChild;
var range1 = document.createRange();
range1.setStart(myText, 3);
range1.setEnd(myText, 6);
var
2015 Jan 10
3
Help with IPv6 /48 block
Hello.
It happens that at the company I'm working decided to start migration of
IPs tech.
So they got a /48 block. I were trying to add it with:
ifcfg-eth0-range1 (0 is already in use with IPv4 range):
IPV6ADDR_START=xxxx
IPV6ADDR_END=xxxx
CLONENUM_START=0
But of course I am assuming that like in IPv4 IPADDR_START/END is
implemented.
Please give some guidance as I need this to done
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
2007 Feb 08
5
xlsReadWrite Pro and embedding objects and files in Excel worksheets
Hans-Peter and other R developers,
How are you? Have you made any progess with embedding Url's in Excel?
Well, I have been busy thinking of more things for you to do;)
My colleagues in the lab are not R literate, and some are barely
computer literate, so I give them everything in Excel workbooks. I have
gradually evolved a system such that these workbooks have become
compendia of my
2013 Feb 27
0
A program running for a too long time
Dear all,
The attached code is supposed to minimize a numerical integration subject
to a non linear constraint. The code runs for 2 days& more without giving
an output. Also, when i change the value of "m<-100" to "m<-1" it gives an
output in areasonable period but with a message " maximum number of
iterations in romberg has been reached". I need to :
1-
2012 Dec 20
2
How to count the nos. in a range?
Dear R forum
I have a following vector of random no.s
x = runif(100, 0.01, 0.99)
[1] 0.47212037 0.77867992 0.33947474 0.93369035
[5] 0.03720073 0.79307831 0.81801835 0.92710688
.................................................
I need to count the random no. falling in the range (0 - 0.10), (0.10 - 0.20), (0.20 - 0.30)..upto (0.90 - 1)
Thus, I
need to have a data frame as
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.
2010 Jun 03
3
Multiple Serial Port Passthrough in HVM domU
So, I made a mistake a bought four systems with the Intel Core i3 processors, without doing my homework to make sure that these systems actually supported VTd. Turns out there''s plenty of information out there indicating that the Core i3 processors do *not* support VTd. I was counting on VTd for two applications: Graphics Passthrough and passing through a PCIe 4-port serial card. Of
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
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