similar to: customize output in Excel and creating reports in word.

Hi, somebody can help me. Idon't understand very well the manual of the this package, I suppose I must enter "wdtxtStart", before I start working, but is supposed that this command should open Word, but nothing happens. I use Rgui, not Rcmdr. Thanks ----- Mario Garrido Escudero PhD student Dpto. de Biolog?a Animal, Ecolog?a, Parasitolog?a, Edafolog?a y Qca. Agr?cola Universidad de

i am trying to fit a linear model with both continuous covariates and factors. When fitted with the intercept term the first level of the factor is treated by R as intercept and the estimate of the effects of remaining levels(say i th level) are given as true estimate of i th level - estimate of 1st level.can any please help me? thanks in advance..... -- View this message in context:

Hi All, I'm trying to use R2wd to send a dataframe to Word. The dataframe isn't huge - 300 rows, 12 variables, although it has some long strings in it. Using: wdTable(format(myDataFrame)) or wdTable(myDataFrame) Produces a very complex table, which Word struggles to process and layout. (I can't work out what the table is - it seems to be nested tables. Converting to text gives

Dear Rxperts, I am aware of Sweave that generates reports into a pdf, but do know of any tools to generate to export to a MS Word document... Is there a way to use R to generate and export report/publication quality tables and figures and export them to MS word (for reporting purposes)? Thanks so much, Santosh [[alternative HTML version deleted]]

can anyone tell me how can i control the method of estimation (i.e. scoring method or Newton raphson method) in glm and compute deviance function ? -- View this message in context: http://r.789695.n4.nabble.com/changing-method-of-estimation-in-GLM-tp3170836p3170836.html Sent from the R help mailing list archive at Nabble.com.

Hi all, I would like to read the results of the commands type in the terminal window in Microsoft Word. As a blind user my options are somewhat limited and are time consuming if I want to see the results of the commands that I have type earlier. for example if my first two commands were x<-c(1,2,3,4,5) mean(x) and I have typed ten more commands after the first two commands it is not easy

i am new to the quantmod package . so if the answer is trivial please excuse me. i want to study stock values within a day. i get current stock updates using getQuotes and then want to produce usual quantmod graphs with that values. also the graph should be able of adding technical indicators. please help. in addition it will be helpful if anyone suggests how to run that code continuously to get

Hello All I've just started to use RExcel instead of CMD Batches. But I don't get the console output to an data.frame and push to Excel. With the CMD batch you got the console out relatively easy with C:\LocalData\R\bin\R CMD BATCH --slave %rscript% %logfile% to a file. But how can I get it to Excel with RExcel an VBA? Thanks, Dario [[alternative HTML version deleted]]

I have an R file R_test.R saved in C:\R_test folder. The R_test.R looks like this: setwd("C:/R_test") rnorm(100) write(rnorm(100),"data.txt") q(save="no", runLast = F) Next I would like use an Excel VBA/macro Shell() function to call R and execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)* I wrote an Excel macro RunRcode like this: Sub

Hi, I was trying to run your code in my VBA editor, however could not succeed. The execution stumbled in the line "Call Rinterface.StartRServer" itself. I have RCOM package installed into my R environment. Do I need to install anything else to run that? Would guys here guide me? Thanks -- View this message in context: http://n4.nabble.com/R-Excel-Macro-Problem-tp858831p1592196.html

Hi R users, Could anyone let me know how to export a paired t-test output table (see below) to an excel file? Jason, with(score2,pairwise.t.test(values,ind, + p.adjust.method="holm", paired=T)) Pairwise comparisons using paired t tests data: values and ind test1 test2 test3 test4 test5 test6 test1 1.0000 - - -

Does anyone know a way that an function written in R can be called within a cell of an Excel spreadsheet. I would like to use the R function much as I use the native Excel functions, e.g. instead of using the excel function sum, =sum(A2,A6), I would like to use the function mysum written in R, e.g. =mysum(A2,A6). Thanks, John John Sorkin M.D., Ph.D. Chief, Biostatistics and Informatics

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

Hello!!! I have been read a much about as read data from Excel File, but I haven?t found the necesary information to read the data. Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I don?t know as read the data?? I hope that you could help me. Thank you very much. -- View this message in context:

I wrote a R script say called computeCovarMatrix.R and i want to call and run this piece from Excel visual basic. does anyone know how to do that? thanks, KZ [[alternative HTML version deleted]]

Dear R users, I've just posted a similar question about Illustrator. This time I would like to export the results of my statistic tables and my dataframes into Excel files. Up to now I've used write.csv(), but I have to resave every file in .xls in Excel. I would like to know if there is a function or package to export directly into *.xls. I have found xlsReadWrite which would be

Hello Everyone,   Been learning R over the past several months. Read several books and have learned a great deal about data manipulation, statistical analysis, and graphics.   Now I want to learn how to make nice looking documents and about "literate programming." My understanding is that R users normally do this using LaTeX, MiKTeX, LyX, etc. in conjuction with Sweave. An alternative

Hi, I am using Rstudio in Ubuntu . While installing R from the terminal I got the version R 2.13.1 . But the problem is that knitr 0.5 requires higher versions. So is there any way to get the latest version of R in ubuntu (or 2.13.1 is the maximum I can get)? In case the higher R version is not available can anybody please help me how do I use the "knitr Html" option in R studio.

I assume R won't easily generate nice reports (unless one starts using Sweave and LaTeX) but perhaps somebody here knows a package that can create report like output for special cases? How can I simply plot output into PDF? Perhaps you know a package I should check out? What do you guys do to create handouts (before actually publishing)? Thanks in advance, Ralf

i am trying to solve a partial differential equation analytically(PDE) in R . i have found some functions that do the stuff numerically. But that will not meet my purpose. is there any function to solve PDE analytically. please help. -- View this message in context: http://r.789695.n4.nabble.com/analytical-solution-of-partial-differential-equation-tp4291618p4291618.html Sent from the R help