similar to: [OT] VBA to save excel as csv

Hi, How can I attach chart/plot to a excel file? I would like to create a plot in R eg. plot(1) and save it into a Excel file, eg. test.xls in a same working directory. Regrads, -J

hi, i am using the RODBC package to read excel files using odbcConnectExcel and susequently sqlFetch to read the contents of the file. the file that i use is just a matrix of numbers thats all. no headers and column names. what happens is that the sqlFetch is not reading my first row of numbers. i have tried different combinations of colnames and rownames logical values but that first row is not

Hi all, I have got 27 graphs to export (not a lot...I know!). How can I fit all of them into a single file like PNG without adjusting the size of the graphs? What's in my mind is like pasting graphs into Word, in which I can just scroll down to view the graphs. Thanks for your attention. Much appreciated. Chris -- View this message in context:

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

If you are running on Windows you can use create and read speadsheets using the ''win32ole'' require This sample should give you the basic idea ------ def export require ''win32ole'' @sort_by = ''last_name'' current_user = ''steve'' @records = Contact.find( :all, :conditions =>

https://bugzilla.samba.org/show_bug.cgi?id=5728 Summary: Rsync --min-size and --max-size filter too late in the process. Product: rsync Version: 2.6.9 Platform: x86 OS/Version: Linux Status: NEW Severity: minor Priority: P3 Component: core AssignedTo: wayned@samba.org

I am having a problem writing/saving to a SMB share with O2K3(Word). In WORD, if I File/SaveAs \\machine\share\fred.doc - the windows machine hangs completely (Explorer+Word immediately, then all other processes after a period of say 1min). Most other scenarios succeed: ok: File/SaveAs C:\fred.doc, then move to \\machine\share using explorer. ok: Outlook.PST file on \\machine\share can be written

Hi! I'm manipulating XLSX data using RODBC, however a limitation which appears to be driver based is that you can't clear or drop sheets from the XLSX files, as per the following example: > library(RODBC) > xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx; ReadOnly=False") >

I have a smb server (2.2.4 on a linux slackware 8.1). It will substitute a windows NT server. Right now, we are testing it on a client using windows XP professional spanish edition with the service packs installed. After it works, we will migrate from the NT to the samba server,a nd the clients will be xp professional, xp home edition and windows 98. Now, the problems... I can access the smb

Dear all, I use the package RCOM to manipulate Excel-Files (Windows). After opening the Excel-File and formatting the cells I want to save the file automatically without request. If I use y[["Save"]] <- TRUE it opens the saving dialog and I have to select the destination for saving. But I simply want to overwrite the existing file without any other workings. Thany your very much

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

Dear all, I have been looking for possibilities to read and write Excel 2007-files in and from R. The 'reading' part is ok through odbcConnectExcel2007 and sqlFetch(RODBC). For 'writing' I thought of using sqlSave in the same package, but it does not work (I think because this function starts from an existing file). Is there a workaround for this, or are there other plausible

Hi all, I am creating MS word document using ruby. can I use a "template" document in Microsoft word with place holders for dynamic data from database using ruby. Like, I''ve a template, I want to fill it by data from database, using ruby. Please help me out. Thanks, -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received

Hi, I am revising a paper that I am a co-author of. The figures are plots generated from R but at the moment I do not have the R code that generates them. As this is time critical I would like to slightly abuse the list by asking whether anyone knows how to extract from MS Word into a stand-alone graphics file a plot that was pasted into Word from R (probably as a Windows Metafile, but possibly

Hi, I am running a test to call an R script with in excel using VBA. My VBA code is shown bellow. The middle section of this mail also includes the content of my Rscript. The bottom part shows the error message form the R console. It seems that Excel is opening the R console without any problems. The problem I am seeing is that Rinterface.RRun instruction is interpreting the "\T"

Hi I have just started to have a look at R. I have used most stats software packages and can use perl, visual basic etc. I am interested in how well it handles lots of output e.g. tables or charts. How would you get lots of output most easily and quickly into a Word document? Sharon Snowdon ------------------------------------------------------------------------ - FIGHT BACK AGAINST SPAM!

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

Issue: Usage of ETS R codes through RExcel macros in VBA Given below is my command code: Rinterface.runrcodefromrange Range(?Sheet1!B2:D8?) Following are the codes written in the given cell reference: #!rput zz 'Sheet1'!$B$2:$B$22 library(forecast) zz <- ts(zz,freq=365,start=c(2009,1)) etsz <- ets(zz,model='AAN') etszP <- forecast(etsz,h=34) write.table(etszP) How

Dear all, I am trying to use R within Excel 97. Seems the VBA with Excel 97 does not recognize function "InStrRev" (it gives error message when I try to launch RExcel Help, just the same as that it doesn't recognize function "Replace"). A solution for frunction Replace has been provided (Ritter, Christian ,

Hi all, Are there any known dll overrides for Visual Basic (wine 20020412 & Suse 7.3) ? It doesn't work in MSOffice. Does an extra installation of Visual Studio help ? Any ideas ? Cheers : Daniel