similar to: Tabular output: from R to Excel or HTML

Displaying 20 results from an estimated 10000 matches similar to: "Tabular output: from R to Excel or HTML"

2011 May 09
3
converting a matrix or data.frame into an html table
Dear all, Is there a function in R to convert a matrix or a data.frame into an html table? Many thanks, Samuel [[alternative HTML version deleted]]
2009 Jan 08
1
R and Excel
Even using the VBA back of Excel to create interfaces with R would make a lot of sense. Suppose I could have access to VBA macros that import and export data into R , it would be great. The R GUI series like Rattle come even closer to Excel...so a VBA _R_ExCel package might be useful to ordinary folks . Besides Excel costs money, so adding R functions to Open Office would help both of them ( if
2001 Feb 09
1
tabular data (was RE: [R] Removing "row.names")
Hi, I agree that replacing data.frames for modeling functions would be too painful. Also I agree with Thomas that new class(es) for tabular data should not inherit from data.frame, and that data.frames should conceptually inherit from some other base tabular data class. At this point I'm not suggesting anything in concrete --- I haven't sorted it out in my own mind --- but I want
2011 Oct 28
1
xtable with \begin{tabular} and only.contents
I have found that I like having my captions and labels in my latex document rather than having them contained in my xtable output file (I haven't fully gone to sweave yet). I know I can do something like this by using the 'only.contents' argument in xtable. Unfortunately, the only.contents argument also removes the \begin{tabular}{rrrrrr} & \end{tabular} (in the example below) of
2009 Apr 10
1
How to handle tabular form data in lmer without expanding the data into binary outcome form?
Dear R-gurus: I have a question about lmer. Basically, I have a dataset, in which each observation records number of trials (N) and number of events (Y) given a covariate combination(X) and group id (grp_id). So, my dataset is in tabular form. (in case my explanation of tabular form is unclear, please see the link:
2004 Jan 20
2
Error: unknown identifier {|} in tabular format {|l|c|c|c|}
I've got a package I would like to send out for testing and have noticed a "problem" with the \tabular portion of the help "compiler" the code for inserting vertical lines, in the tabular environment, causes the build to choke, but not the check command. C:\>rcmd build --binary -docs=all nlsystemfit \tabular{|l|c|c|c|}{ \hline Method \tab Instruments \tab
2012 Jul 26
4
Variables in a Tabular form. easily saved in a txt file
Dear all, I would like to save few variable-names with their values in a tabular form, with that I mean that files can be printed easily in R in a tabular form and also saved in a ascii file that when one opens it see also the variables in a nice tabular format. IS that possible? Below a small example of how should look results in R and in a txt file.              Postal Code | Superb
2015 Jun 09
3
Tablas con tabular en latex
Buenos días, estoy tratando de encontrar la manera de generar tablas en ficheros pdf (sweave) a través del paquete tables. He mirado que este tema esta activo en las listas pero no logro localizar las respuestas antes dadas, por eso lanzo esta consulta. Mi fichero .rnw tiene el siguiente aspecto: ******* \documentclass{article} \usepackage{array,booktabs,caption} \begin{document}
2009 Jul 01
5
convert tabular time series into a matrix format
Hi, thanks everyone for any help in advance. I found myself dealing with a tabular time-series data formatted each row like [ time stamp, ID, values]. I made a small examples: X = data.frame(t=c(1,1,1,2,2,2,2,3,3,3,4,4,4,5,5),id =
2009 Mar 05
4
including tabular information with a plot in R Graphics
Hi all, I have a presentation problem that I cannot find a solution to in the documetnation. I have a nice barplot. Below this I would also like a table with some information relating to the plot. My idea was to have the plot and table on the same graphics window so I can output them as an image file for a report. Does anybody know how to include tabular information from a dataset or table into
2010 Dec 01
3
Save R2HTML as an object instead of file
Hi Is it possible to instead of getting the HTML code written to a file, get it saved as a string in an object instead? Or is there any kind of package that can do this? //Joel -- View this message in context: http://r.789695.n4.nabble.com/Save-R2HTML-as-an-object-instead-of-file-tp3066776p3066776.html Sent from the R help mailing list archive at Nabble.com.
2006 Dec 14
5
Nicely formatted tables
If I use latex(summary(X)) where X is a data frame with four variables I get something like Rainfall Education Popden Nonwhite Min. :10.00 Min. : 9.00 Min. :1441 Min. : 0.80 1st Qu.:32.75 1st Qu.:10.40 1st Qu.:3104 1st Qu.: 4.95 Median :38.00 Median :11.05 Median :3567 Median :10.40 Mean :37.37 Mean :10.97 Mean :3866
2009 Apr 16
3
Presenting R Results in Webpages
I apologize in advance that this question is not specific to R, but I thought some R users may be using this in their work process flow. I would like to be able to have a tool (prefer "scriptable") that will take two images and some pre-written text and put it on an simple webpage. That is, it would look something like the following: |---------------------------------------------|
2006 Jul 21
4
Printed/PDF Reports (Text/Tabular/Summary) in Rails
The recent discussion about different graphing solutions made me think. What is everyone using for general reports? Currently I have a web based application at work that has roughly 20 different reports ranging from simple tabular data with totaling at the bottom to pretty, colorized, graphic logo''s,etc... going to clients, and finally complex ones I hate to think about such as
2012 Oct 28
1
Tabular datos de Encuesta Continua de Hogares
Buenas, tengo la siguiente inquietud. Tengo un data frame con los microdatos de la ECH de mi pais. He realizado un cuadro sin problemas en excel pero me gustaria una rutina de R para poder generar la tabla. El data.frame se llama ECH2009. Cuenta con las siguientes variables para este caso: idhogar region estrato integranteshogar expansor ingpercapsvl Computador TvAbonado Internet 1 capital 1 2
2009 Jun 03
4
Excel Export in a beauty way
Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there is no frame between the cells. And I missing the possibility to make some headers bold or coloured.
2012 Feb 17
4
How can I tabulate time series data (in RStudio or any other R editor)?
Hello, I have a question on how to tabulate the time series data. I use RStudio, but if can be done in any other R editor, it should work in RStudio as well. > a1<-11:22 > a1ts<-ts(a1, frequency=4, start=c(1978,1)) > a1ts Qtr1 Qtr2 Qtr3 Qtr4 1978 11 12 13 14 1979 15 16 17 18 1980 19 20 21 22 If I click the variable "a1ts" on the
2008 Dec 05
2
xtable html links
Hi, I was trying to get hyperlinks using xtable, but couldn't get the hyperlinks to function properly. For example, if I use ## Try to link NY times website to every figure in column 4 mat <- matrix(1:43,6,5) mat[,5] <- "http://nytimes.com" for(i in 1:nrow(mat)){ strr <- paste('<a href="', mat[i,5],'">', mat[i,4], '</a>',
2007 Nov 05
1
R2HTML package and Open Office: text only pasted
I am trying to use R2HTML (just downloaded from CRAN) to paste R (2.6.0) results output via the clipboard to OpenOffice Writer and Calc (version 2.3on WinXPPro) Pasting into Excel gives a formatted table of results (as expected), but pasting into Calc simply pastes the HTML code. Trying paste special only gives an option to paste unformatted text. Equally, with Writer, in the past when I tried
2013 Apr 25
0
tables: proper use of Hline() in tabular()
Dear all, I am unable to understand how Hline() works in tabular(). I've read the vignette and the help page, and here this example compiles perfectly fine: latex( tabular( Species + Hline() + 1 ~ Heading()*mean*All(iris), data=iris) ) However, if I try it on my own data it fails. Consider this: set.seed(1) Xa <- data.frame(p=rep(c("First group","Second