search for: displayalerts

...un my entire code I simply write on line: source("S:/Folder/FileName.R") As mentioned in RExcel I can run by selecting the cell and choosing Run Code. I have tried to write the macro for this operation as the following: Sub FindIndex() ' To run the price index in R Application.DisplayAlerts = False Rinterface.StartRServer Rinterface.RunRFile "S:/Folder/FileName.R" 'RInterface.StopRServer Application.DisplayAlerts = True End Sub But it returns the error "Error when sourcing R file S:/Folder/FileName.R" I have also tried a simple RInterface.RRun...

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

Hi all, This is a little off-topic, but it is on the general topic of getting data in R. I'm looking for a excel macro / vba script that will export all spreadsheets in a directory (with one file per tab) into csv. Does anyone have anything like this? Thanks, Hadley -- http://had.co.nz/

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

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

...:conditions => ["created_by = ?", self.current_user.login.to_s] #, #:order => @sort_by ) # Creates OLE object to Excel excel = WIN32OLE.new("excel.application") # Create the chart excel[''Visible''] = TRUE; excel.DisplayAlerts = false #Supress''s Excel warnings workbook = excel.Workbooks.Add(); excel.Range("a1")[''Value''] = ''First Name''; excel.Range("b1")[''Value''] = ''Last Name''; excel.Range("c1&q...

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

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