similar to: Office Excel 2007 dynamic link issue #3

Hey all, We're having some trouble saving Excel documents on our Samba Fileserver. We are moving people over to our Samba box, and have moved most of our documents over. Now, we have people opening their Excel documents, but are unable to save them. When something is saved, we see this message: Your changes could not be saved to 'document.xls', but were saved to a temporary document

Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we get the following error, when trying to write the data frames to the excel sheets: Error in ls(envir = envir, all.names = private) : invalid 'envir' argument We figured out that

Hi, I?m using R package RDCOMClient (http://www.omegahat.org/RDCOMClient/) to retrieve data from MS Excel workbook. I?m using the code below to count the number of sheets in the workbook and then loop the data from sheets in to a list. ############# R code ################### library(gdata) library(RDCOMClient) xl <- COMCreate("Excel.Application") sh <-

Hello R-users, Checking the archives, I recently came across this topic: "export tables to Excel files" (http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679), and the following interesting references have been proposed: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows

Hello all, I have always experienced VERY SLOW response times on opening an EXCEL sheet ever since I had started to use SAMBA WAY back. I have been hoping that a newer release would fix this one issue but it never seems to happen. Does anyone know what could be the problem? I can open the same Excel sheet on a Novell server and it opens instantly. I have no problems with WORD documents. They

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, This may be due to several reasons. That I can think about: 1) Ensure you close *all* possibly open workbooks: nBooks <- xl[["Workbooks"]]$Count(); for (i in seq_len(nBooks)) xl[["Workbooks"]]$item(i)$Close(SaveChanges=FALSE); 2) The excel application reference does not seem to be really released until the garbage collector runs. So this may help: xl$Quit();

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

I'd like to be able to read multiple sheets from an excel workbook and use the sheet name to name the resulting dataframe using RODBC. at the moment i've figured out how to do it the long way (see below) but feel sure that there is a speedier & possibly automatic way to do it in R. i've tried to run a loop using sqlTables but it seemed to break the connection. unless i've

L.S. I am trying to get data from an excel sheet using the RODBC library, quite like the example on page 34 of the 'Data manipulation with R' book written by Phil Spector. It seems very straightforward, yet I get the same error everytime I try it, with different excel sheets and trying to tweek the code a bit. This is what I do: library(RODBC) sheet='X:\\example.xls'

Nathan, Thanks for the tips. Most of these settings were already in place, but the ones that were not already there I set up, with the exception of the 'force group' setting. I hesitate to try this simply because many of the subfolders under the shared volume are have their access controlled by group, and I didn't want to risk preventing others from accessing their files in the middle

I’m trying to export a file from R to excel using the xlsReadWritePro function and I keep getting the error below. I get the same error when I use the oledatetime function. My current date format is mm/dd/yyyy, which is how I want it in excel. Also is there anyway to export different datasets to multiple sheets similar to the ods function in SAS? <?xml:namespace prefix = o ns =

Dear all, i use the following package/syntax to export data to excel: library(xlsReadWrite) write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) Everything is fine, but the format of the export is not the best. For example, I every time have to adjust the column width. Furthermore there is no possibility to highlight some cell or make them colourful. I create a lot

Hi useRs, I would like to know what R users are employing to get their images/plots created in R, into Excel sheets. I am aware of the various packages (xlsReadWrite, RODBC) to get data frames into R, but I would like to copy images too. Thank you for any help in solving this problem. Regards, Harsh Singhal

HI, I have large dataset of many countries. I have written the program to run through each country to generate one output for each country. I want to put the output like this: one sheet has output for one country. How do I achieve it by r. I have tried this: library(xlsx) write.xlsx(nnn, "vn.xlsx", sheetName="Sheet1") [1] but when I change sheetName="Sheet2"

Hi, I'm trying to read several Excel sheets from an Excel file into a list. I'm using read.xls from package 'gdata'. I would like to know how I can check the number of sheets before the loop (in the example below) so that I could adjust the loop counter? Any suggestions? DF.list <- list() for (i in 1:4) { DF.list[[i]] <- read.xls("sample_file.xls", sheet=i,

hello, does anyone know how I can write several matrices from R into one exel-file using different sheets for the different matrices? thank you very much in advance for your help. Marion [[alternative HTML version deleted]]

Hi all, I am using RODB to export multiple data.frames into one excel file with multiple sheets. One thing I can't seem to unserdatand is way the command adds the character: ' To the beginning of each of my (non numeric) values. Here is an example code: library(RODBC) library(MASS) data(anorexia) save2excel <- function(x, t.name) sqlSave(xlsFile, x, tablename = t.name, rownames =

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, Apologies if I violate any posting etiquette - this is my first submission to the R mailing list. I regularly use 'odbcConnectExcel2007' (from package 'RODBC') to read data from named ranges in excel workbooks into R. I recently received the following error message when attempting to set up a connection channel (i.e. ch1 <- odbcConnectExcel2007('path to excel 2007