similar to: Problem of using wdTable() within R2wd package

Hi All, I am trying to use the wdTable() function within R2wd package to send a dataframe to MS-word. However, there is a problem with the tables that are generated by R. For some reason the header row of the table also contains all the data. You can see it by dragging the bottom border of the table down to make the row wider. For example, the data named 'bod' should look like as:

Hi all, I've been using the wdTable() function from R2wd package and it's been working great. However I just tried to do the following: > table.2 Waste Rebate code Chargeable (fin_map) Quantity (qty) Total [1,] "Waste" "Rebate code" "CHG" "121" "$22,534.01" [2,]

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

I think you meant to call BOD[,1] From ?transform, the ... arguments are supposed to be vectors, and BOD[1] is still a data.frame (with one column). So I don't think it's surprising transform gets confused by which name to use (X, or Time?), and kind of compromises on the name "Time". It's also in a note in ?transform: "If some of the values are not vectors of the

I don't think it has much to do with transform in particular: > BOD <- data.frame(Time = 1:6, demand = runif(6)) > BOD[["X"]] <- BOD[1:2] * seq(6); BOD Time demand X.Time X.demand 1 1 0.8649628 1 0.8649628 2 2 0.5895380 4 1.1790761 3 3 0.6854635 9 2.0563906 4 4 0.4255801 16 1.7023206 5 5 0.5738793 25 2.8693967 6 6 0.9996713

Note the inconsistency in the names in these two examples. X.Time in the first case and Time.1 in the second case. > transform(BOD, X = BOD[1:2] * seq(6)) Time demand X.Time X.demand 1 1 8.3 1 8.3 2 2 10.3 4 20.6 3 3 19.0 9 57.0 4 4 16.0 16 64.0 5 5 15.6 25 78.0 6 7 19.8 42 118.8 >

The idea is that one wants to write the line of code below in a general way which works the same whether you specify ix as one column or multiple columns but the naming entirely changes when you do this and BOD[, 1] and transform(BOD, X=..., Y=...) or other hard coding solutions still require writing multiple cases. ix <- 1:2 transform(BOD, X = BOD[ix] * seq(6)) On Tue, Jul 24, 2018 at

Hi,My major problem with R was always the quality of the output. Recently I found R2wd, which solved this problem. R2wd makes it possible to write output directly to a word file, end to produce high-quality tables.I have two problems with R2wd, however.1. The documentation says it is possible to open an existing doc file in R2wd (wdGet(filename="hoepedepoep.doc")). This does not work

Hello Everyone, the basic idea is to generate an initial (MS Word) report by R (plots, tables and outline structure), pass this document around so everyone can add / change content (except plots and tables) and later to be able to update the R plot / table logic and update the already modified word file. I was toying around with the R2wd [1] package to test whether it is a viable way of writing

I am having trouble using the R2wd package. The last time I used it successfully, I was running an earlier version of R and an earlier version of Word with an earlier Windows OS. I'm not sure which if any of these changes might be contributing to the problem. Right now I'm using R version 2.15.0 (2012-03-30) for Windows MS Word 2010 version 14.0.6112.5000 (32-bit)

Dear list, I'm trying to use R2wd package. I've installed the package and try wdGet(). However a error message came up. I'm presently using R 2.15.0 > wdGet() Error in if (wdapp[["Documents"]][["Count"]] == 0) wdapp[["Documents"]]$Add() : argument is of length zero Does anyone knows what this means? Thanks a lot. Andreia Leite -- View this

Hi all, I'm currently trying to get accustomed to R and some of its packages, thus need some help for a package called R2wd. As I am trying to use the wdGET() function I'm getting the following message: Error in if (!(tmp[["ActiveDocument"]][["Name"]] == filename)) tmp$Open(paste("path", : argument is of length zero Does anybody know what that means?

I've been following the "R Reports" topic in the digest mode, so apologies if this has already been mentioned. On a Windows platform, there is a package called R2wd which I've recently discovered and have been using. It allows one to put data frames (it's the only object I've tried so far) into a very nicely Word formatted table. E.g in its documentation it has this

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm using R2wd and ESS. ESS-mode doesn't let one fill wdBody() calls, and printing out of Emacs (M-x print-buffer or M-x print-region) doesn't wrap, so I miss most of the text on printed listings. What do others do to address that? Thanks, Bill - -- Bill Harris http://makingsense.facilitatedsystems.com/ Facilitated

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

Hi, R-users, data is a matrix like this AMR BS GE HR MO UK SP500 1974 -0.3505 -0.1154 -0.4246 -0.2107 -0.0758 0.2331 -0.2647 1975 0.7083 0.2472 0.3719 0.2227 0.0213 0.3569 0.3720 1976 0.7329 0.3665 0.2550 0.5815 0.1276 0.0781 0.2384 1977 -0.2034 -0.4271 -0.0490 -0.0938 0.0712 -0.2721 -0.0718 1978 0.1663 -0.0452 -0.0573 0.2751 0.1372 -0.1346

Dear All, Is sqldf equipped with delete queries? I have tried delete queries but with no success. Thanks in advance, Paul

Hi All, I want to "merge" two datasets by column "ID" and I don't want the result to be sorted by "ID". I am doing the following: > z = merge(x, y, by = "ID", sort=F) The result is not sorted by "ID". But (as oppose to what I expected) it is not even in the original order of either "x" or "y". Can

Hi: How?can one open an existing word document with wdGet() I?am getting an error message when trying to open it like this: wdGet(filename="myDoc.doc",path="c/mydata") Looking at Tal Galili's website example it appears that double backslashes are used but i tried it and didn't work either. Thanks ? Felipe D. Carrillo Supervisory Fishery Biologist Department of the

Full_Name: Joann Williamson Version: 1.9.0 OS: Windows XP Submission from: (NULL) (129.252.198.28) I installed R project 1.9.0 on Windows XP. The installation went well. Then, I rebooted. Next, I clicked the icon under Programs in the Start menu and received this error, "Fatal Error: Invalid HOMEDRIVE". I clicked OK to the error message. The program does not start. I went to a DOS