similar to: Excel-Export

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.

Dear list members, I'm using R in connection with the RDCOMClient and Excel. The more I use the package, the more I'm fascinated of it. The possibilities of R can be brought together with the necessities of outputing my socio-economical research results in MS Office! But I have some special questions concering the use of RDCOMClient and perhaps you can help me solving them: 1. Problems

Hello everybody, at work I want to start R within an VBA program. First I calculate something in Excel 2003. After that I want to start within my VBA makro R wich should start an R file, say i.g, superplot.R which plots me the data well. So is it possible? Maybe something like that: sub test() 'calculate something start R superplot.R end test() Thank you so much. Kindly

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my

Hi all: I wanna know how to expoort ".xls" file. And in the exported ".xls" file, how to set different cells with different color? Thanks a lot! My best. ------------------------------ ******************************************* Xin Meng Capitalbio Corporation National Engineering Research Center for Beijing Biochip Technology BioPharma-informatics & Software

Hi all, i am new here and this is my first posting. My coding experience in R ist okay, but I have a problem which is related to another aspect of R. I am searching for a surface which execute my commands in R via a click on a button OUTSIDE of R. Concrete: I will write some programs in R and want to execute this files outside of R, so I don't want to start R eyery time if i want an

Hi, i'm trying to read some data from excel files but it seems that neither xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0). When i open the file in Excel and save it in a new format Excel 97 -2003 everything works fine. Is it possible to use ODBC connection to open old format files, or i guess i will have to open and save every file in Excel in new format, which

Hi Does anyone know of any R routines to send emails from R, under Windows? I thought about writing such a facility using the R(D)COM package to drive e.g. MS Outlook, but I don't want to reinvent the wheel. I have found a function Sys.mail in the library syskern, but this only works under Unix by shelling out a mail command. Thanks, David

Hi Does anyone know of any R routines to send emails from R, under Windows? I thought about writing such a facility using the R(D)COM package to drive e.g. MS Outlook, but I don't want to reinvent the wheel. I have found a function Sys.mail in the library syskern, but this only works under Unix by shelling out a mail command. Thanks, David

Hello together, i have a list of numbers, like this one A B C 1.1 1.2 1.3 i export this list into an excel file and want now color these numbers according to her value. I want every color under 1,25 is red, and every color over 1,25 is green. How can i do this with "RDCOMClient" ? I know how to colour a complete row, like this task: U3R <- sh$Range(zellen_blue) U3RF <-

Yes: I have Tufte's monograph on my desk. (along with 4 statistics texts) Yes: I am not the biggest fan of PowerPoint. Yes: I am using R to generate charts, plots, trends, etc. I have to summarize them each week. When I consider how to organize this data my first thought is to generate an HTML file with links to the R-generated plots, which HTML file organizes the plots in the required

exportData(MU.Cost,paste("C:/RAUDSL/S",as.character(MU.Cost$Run.Id[1])," .",as.character(MU.Cost$MU.Id[1]),".MU.PRICE.OUTPUT.txt",sep=""),append = FALSE,type="ASCII",quote=FALSE) [[alternative HTML version deleted]]

Dear Listers: I have a couple of data frames to report and each corresponds to different condtions, e.g. conditions=c(10, 15, 20, 25). In this examples, four data frames need to be exported in a "pretty" report. I knew Perl has some module for exporting data to Excel and after googling, I found R does not. So I am wondering if there is a package in R for generating good reports. I

Dear R-experts, It is a quite stupid question but please help me. I am very confuced. I am able to import normal txt ant mat-files to R but unable to import .xls-file I do not understand the online help. Can please anyone send me the corresponding command lines? The .xls-file is attached. In my file we use commas for the decimal format (example: 0,712), changes might be needed. Thanks, Corinna

Dear R Folks, I know that Enrique Bengoechea ( Credit Suisse ) had posted some code snippets for importing Bloomberg historical data into R. I found them to be very useful. Has anyone succeeded in getting the below items from Bloomberg to R? (a) historical economic release data, (b) tick/intra-day data (c) bulk data such as Index membership info, etc. If someone is willing to share their code

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

-----Original Message----- From: MAKRO BAGAFORO, Melvin Sent: Friday, November 16, 2001 11:52 AM To: 'Ben Elliston' Subject: RE: samba error Hi Guys, I already downloaded the latest config.guess and config.sub files, './configure' command is now error free. However, I have another problem, samba won't start. Samba test results:

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

Hi This is Vignesh with Makro Technologies, Inc. We have been in business for over 10 years and we are one of the Fast 500 National IT staffing and Solution firms in USA. Our clients include country’s top-notch IT, Healthcare, Pharmaceutical, Financial, Telecom,Government and other industries. Staying current with technology, finding great consultants and exceeding our clients''

Hello, markdown (Python implementation) seems to render:  to <img src="pfad/und/eine" title="lange/url zum bild.jpg" alt="alternativer text"/> breaking the URL at the whitespace. AFAIK whitespaces are ok in URLs so why is it breaking up the URL here? Thanks, Florian -- I'm using an