similar to: Writing Reports from R in Microsoft Office Open XML format (follow-up)

can any one help me in customizing output(inserting 2 or more tables in a single sheet,creating table title etc.) in excel? I also need to know whether it is possible to create a page with charts and graphs in word by R? thanks in advance..... -- View this message in context: http://r.789695.n4.nabble.com/customize-output-in-Excel-and-creating-reports-in-word-tp3671447p3671447.html Sent from

Dear "R" list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from "R" output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I

I have a highly formated Excel with multiple tabs. Is it currently possible to read this data into R without changing the format of the Excel file? Also, is it possible to write back to the same Excel file or at least create a new Excel file with the same formatting as before with modified data which has been processed in R. Thanks in advance for any help that you can provide. Dave

Dear R-help, Call RInterface.StartRServer ' Works fine Call RInterface.RRun("objects()") ' Works fine Call Rinterface.RRun( other R commands which do not generate errors, the demos etc ) ' Works fine But ... Call RInterface.RRun("doesnotexist") ' Sends Excel into endless loop it appears After about 90 seconds a dialog box appears "Microsoft

Hi, I am using RExcel both at work and at home and am facing a couple of challenges. The one at home is that when using RExcel and trying to run any code that involves changing the working directory, I get the following error. Error in command: setwd("C:\\Raoul\\R\\R Maps_UK Maps_Test\\NUTS_03M_2006_SH\\shape\\data")\n cannot change working directory The one at office is more

Dear all, Max, first of all, many thanks for providing the odfWeave package. My problem: Whenever I have multiple plots in one single chunk of my ODF file, only the last plot gets shown. The problem can be reproduced with this toy example (to be used in an ODF file together with odfWeave -- I'm using the newest version 0.7.3): <<plot1, echo=FALSE, fig=TRUE>>= for (i in 1:3) {

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

Hola a todos, Mi nombre es Juanjo. Llevo un tiempo intentado hacer funcionar un programa que necesita de la instalación de RPROJECT y REXCEL. He mirado varias guías e instalado los programas pero obtengo varios errores. El principal es que tras instalar RProject, Rexcel y statcon y al intentar correr esta macro desde Visual Basic… Sub Start() RInterface.StartRServer

I am using SWord from statconn: http://rcom.univie.ac.at/download.html It allows you to put r-commands into Word (similar to odfWeave). Output is directed to Word including figures and tables. It is still a beta-version but works fine. Frank Bloos >>> Wenjie Lee <wenjieleemaillist@gmail.com> 12.12.2009 00:28 >>> Hi R Experts, I'm aware of pdf(), jpeg(),...

Hello All, I'm getting my workflow switched over to Sweave, which is very cool. However, I collaborate with folks (as many of you must as well) who use Word to Track Changes amongst a group while crafting a paper. In the simplest case, there will just be two people (one Sweave user and one Word user) editing a paper. I'm wondering, how do Sweave users go about this? I could convert a

I have been looking for a way to write R-generated reports to Microsoft Word documents. In the past, I used the package R2wd, but for some reason I haven't been able to get it to work on my current set up. R version 2.15.0 (64-bit) Windows 7 Enterprise - Service Pack 1 Microsoft Office Professional Plus 2010 - Word version 14.0.6123.5001 (32-bit) I gave the package

# Dear list, # I am an R-beginner and # spent the last days looking for a method to insert tables produced # with R into a word document. I thought about SPPS: copy a table from # an SPO-file and paste it into a word document # (if needed do some formatting with that table). # Annother idea was, to produce a TEX-file, # insert it and make it a word-table. # I found the following libraries, which

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]]

Hi - For a while I've used RExcel without problems to run a repeating portfolio optimization problem where I solve for a portfolio allocation targeting a particular risk, then solve for a different risk, etc. I call the commands with (e.g.) rinterface.Rrun "(R command)" Recently that macro started blowing up, returning #RErrors, and when I try to trace the error I find that it is

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

Hello R friends, I want to use my R script in VB to make macro in Excel. I tried with RExcel but it seems to me that this package is just GUI API and I still have to run(connect) R to use the script. Google tells me there are some ways to make R script as an independent library/module/header so that I can call it in VB, C or JAVA. Where can I get detailed tutorial or manual for that? Thanks in

Hi community. I'm fairly new to R and have a basic question. When I try to install RExcel with the code: install.packages("RExcelInstaller", "rcom", "rsproxy") I get the message below: Warning in install.packages("RExcelInstaller", "rcom", "rsproxy") : 'lib = "rcom"' is not writable Error in

I am having trouble using R routines from the RExcel add-in, that use lapack.dll. As an example if I start the R kernel from within Excel and execute "x<-rbind(c(1,2),c(1,-1)) z<-solve(x)", I get the following error: "Error in solve.default(x): lapack routines could not be loaded. In addition: Warning message: unable to load shared library "C:\Program

I tried odfWeave to create an OpenOffice file and found that it exhausted the memory of my large linux machine and took a long time to run. LaTeX with Sweave is blazing fast and extremely flexible. Most of the time I can give clients a pdf file. Sometimes I'd like to make Sweave LaTeX files more accessible (and editable) to (gulp) Word users, mainly so they can extract tables and other

Hello, I just installed RExcel but I have some problems. I am writing you the set of commands that I used: > install.packages("RExcelInstaller", "rcom", "rsproxy") > library(rcom) > comRegisterRegistry() > library(RExcelInstaller) > installstatconnDCOM() > installRExcel() But when I select RStart from add-ins I see this written "No R server