similar to: how to export ".xls" file with colorful cells?

Displaying 20 results from an estimated 600 matches similar to: "how to export ".xls" file with colorful cells?"

2006 Jun 06
2
about string
Hello sir: There are 2 questions about string. 1 How to calculate the width of a string? e.g string "abc"'s width is 3; 2 How can I get the "substring" in such kind of condition: "f:\\JPCS_signal.txt" "f:\\PC1_signal.txt" "f:\\PC2_signal.txt" What I wanna get is "JPCS" "PC1" "PC2".How can I achieve them by R
2006 Sep 27
3
exact 95% confidence intervals
Hello sir: As to the 2*2 table format for reporting results comparing a new test to true diagnosis,when I got the sensitivity and specificity,how can I calculate the exact 95% confidence intervals (based on the binomial distribution) for sensitivity and specificity via R? Thanks a lot! My best! ------------------------------ ******************************************* Xin Meng Capitalbio
2006 Apr 13
1
about McNemar
Hello sir: How can I perform McNemar (paired chi square test) by using R? Thanks! ------------------------------ ******************************************* Xin Meng Capitalbio Corporation National Engineering Research Center for Beijing Biochip Technology BioPharma-informatics & Software Dept. Research Engineer Tel: +86-10-80715888/80726868-6438 Fax: +86-10-80726790 Email??xmeng
2006 Apr 19
1
about "intersection set" and "union set"
Hello sir: group1:1,2,3,4 group2:1,3,4,5 group3:2,4,8,9 .. ... group1000:9,3,8,2 I wanna get the "intersection set" and "union set". I've tried command "setdiff"and "union",but only two groups is permited.How can I deal with multi groups to find the "intersection set" and "union set"? Thanks a lot! My best
2006 Sep 20
1
about BATCH and parameter file
Hello sir: I use Rcmd to execute R code,such as : "C:\\Program Files\\R\\R-2.2.1\\bin\\Rcmd.exe" BATCH globalLowessRun.r globalLowessRun.r is a R function written by myself. But I wanna make the "globalLowessRun.r" changeable,such as globalLinearRun.r or gridbasedLowessRun.r,and so on. How can I achieve this goal via Rcmd.exe BATCH ? The only finding is: Rcmd BATCH
2005 Nov 24
1
a question
Hello sir: Here's a question: x<-1:5 y<-c(2,1,4) I wanna get the different elements between x & y,i.e. 3,5. How can I get the result(3,5) via R function? Thanks a lot for your help. My best! ------------------------------ ******************************************* Xin Meng Capitalbio Corporation National Engineering Research Center for Beijing Biochip Technology
2005 Apr 04
1
How to extrct F value
Hello sir: Here's the result of repeated measures ANOVA. $"Error: Within" Df Sum Sq Mean Sq F value Pr(>F) t 2 524177 262089 258.24 1.514e-06 *** Residuals 6 6089 1015 --- Signif. codes: 0 `***' 0.001 `**' 0.01 `*' 0.05 `.' 0.1 ` ' 1 My question is: How to extract the F value only? If the result is a
2005 May 18
1
covariance analysis by using R
Hello sir: Here's a question on covariance analysis which needs your help. There're 3 experiments,and x refers to control while y refers to experimental result. The purpose is to compare the "y" values across the 3 experiments. experiment_1: x:0.1 0.2 0.3 0.4 0.5 y:0.5 0.6 0.6 0.7 0.9 experiment_2: x:1 2 3 4 5 y:3 4 6.5 7.5 11 experiment_3: x:10 20 30 40 50 y:18 35 75 90
2005 Aug 30
2
about "pnorm"
As to the function"pnorm",the default degree of freedom(df) is infinite. I wanna know how to set the df as I want. Help on pnorm doesn't have df setting.The only choice are:"mean, sd, lower.tail, log.p",but no df. For instance: sample size=6 df=6-1=5 t value=9.143 I wanna to the corresponding p value by using function "pnorm". How can I do it? Thanks a lot
2006 Feb 23
4
read file of EXCEL format
Hello sir: How can I read data file of EXCEL format from disk("d:\\data.XLS" for example)? I can only read data file of .txt format read.delim("d:\\data.txt",header=T,as.is=T),but only EXCEL format is available at present. Thanks a lot
2006 Dec 18
3
plot
Hello sir: a data with 2 columns: id x a 1 b 2 c 3 I wanna get such kind of plot: x: a b c y:1 2 3 But the plot command doesn't permit string character as x. How can I get it ? Thanks a lot ! My best
2007 Mar 20
1
about hcluster
Hi all: As to hcluster,how can I control the cluster is performed according to rows(genes for instance) or columns(samples for instance)? I can't find the parameters for it. Thanks a lot! My best!
2007 May 18
1
add info
hi all: If there's a dataframe: x y 1 a 2 b 3 c The info of the data such as : name date author The result I want is: name date author x y 1 a 2 b 3 c In other words,I wanna add the info above the dataframe. How can I do it ? Thanks a lot! My best
2004 Sep 08
3
Thanks
Thanks a lot for your timely rely. I still wonder whether I can use "a":"d" instead of 1:4. I remember I fulfill it successfully according to the guidance of some materials on R,but fail to find it now. Thanks again! ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting
2004 Sep 08
5
a little question about R
Hello,sir: Here's a little question about R which needs your help.Thanks in advance. If I wanna make a sequence just like a,b,c,d (In other words,a vector consists of 4 characters :a,b,c,d ).How can I do it in a shortcut manner? Yes,I can do it as following: c("a","b","c","d") and the result is:[1] "a" "b" "c"
2007 Jul 08
1
Writing Excel (.xls) files on non-Windows OSs using Perl
Hi all, There have been quite a few threads in the recent months pertaining to the ability to directly write native Excel (.xls) files from R. For example, exporting R matrices and/or data frames to an Excel file, with perhaps the ability to create multiple tabs (worksheets) within a single file, with one tab/sheet per R object. There exists the xlsReadWrite package on CRAN by Hans-Peter Suter,
2002 Jul 31
7
exportData(foo,"foo.xls","EXCEL") for R ?
r-help, Is there a package available for R which allows you to export data directly to .xls, much like exportData(foo,"foo.xls","EXCEL") in S-PLUS ? If not, is anyone working on this, or thinking about working on this? I apologise in advance if this question has already been answered. Many thanks, Matthew
2006 Aug 11
6
Exporting to Excel ( all versions )
Hello, Thanks in advance for reading. I''m attempting to export data to an excel spreadsheet, and have done so successfully using RubySpreadsheet ( http://sourceforge.net/projects/rubyspreadsheet/ ) which is a port of the Perl WriteExcel module... Many of the methods however were left out, one of them being "insert_bitmap" and unfortunatley the bitmap is an important part
2007 Feb 09
1
"class" package
Hello sir: Where can I download the package "class"? What I can find is only: http://www.stat.ucl.ac.be/ISdidactique/Rhelp/library/class/html/00Index.html But I can't find where I can download it. Thanks!
2004 Dec 21
1
about colnames
Try colnames(df)[4:6] <- c("x","y","z") -----Original Message----- From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of xmeng at capitalbio.com Sent: 21 December 2004 09:45 To: r-help at stat.math.ethz.ch Subject: [R] about colnames Hello sir: If there's a data frame(with name "df"): a b c d e f