search for: excel

Hey Seniors, Really new to R, please has anyone imported a dataset from MS office excel 2007 into R yet? It seem to be giving me hard times which I did not expect as it use to go well with the previous versions. Thanks in advance. arnoldo --------------------------------- [[alternative HTML version deleted]]

Hello!!! I have been read a much about as read data from Excel File, but I haven?t found the necesary information to read the data. Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I don?t know as read the data?? I hope that you could help me. Thank you very much. -- View this message in context: http://www.nabble.com/R...

Dear All, I am using excel.link package to open and modify Excel files. When I manually open Excel, all my add-ins are loaded without a problem. But when I open Excel using excel.link package, like: xls<-xl.get.excel() xl.workbook.open("MyFile.xlsx") some Excel add-ins are (installed but) not loaded. Since th...

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

Hello. I am using some dates I read in excel in R. I know the excel origin is supposed to be 1900-1-1. But when I used as.Date with origin=1900-1-1 the dates that R reported me where two days ahead than the ones I read from Excel. I noticed that when I did in R the following: > as.Date("2011-3-4")-as.Date("1900-1-1") T...

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

I have recently installed MS Office 2007 in Wine 1.2 on Ubuntu 10.04 64-bit I have noticed that I cannot switch between two excel workbooks. I can either work on only one excel at a time or do a lot of jugglery to switch between the two. It will be great if anyone can give me a solution as I need to work on multiple excels most of the time. Thanks Prasad

What is the equivalent for formatted tabular output of the various very sophisticated plotting tools in R (plot, lattice, ggplot2)? In particular, I'd like to be able to produce formatted Excel spreadsheets (using color, fonts, borders, etc. -- probably via Excel XML) and formatted HTML tables (ideally through a format-independent interface), and preview them using commands within R, just as I would do with R graphics. The reason I'd like to produce Excel or HTML rather than (say) Te...

Hi Experts, I was trying to write a data frame which has a header row, from R to Excel disk file using RODBC ( RODBC_1.3-1) package. I met with an issue:- If in sqlSave(), I set a parameter "colnames=FALSE" then I get first row as header in excel file. If 'colnames=TRUE' then it gives me first 2 rows as header in excel file. Actually, according to my u...

How would one server out to excel a html table with the mime/content type application/vnd.ms-excel ? In PHP it would be something like ?php header("Content-Type: application/vnd.ms-excel"); ------ But how do I do this in rails? Cheers Glenn -- Posted via http://www.ruby-forum.com/.

Folks: I thought the following excerpt from Bruce McCullough's post would be a good candidate for the R fortunes package -- except that it's about Excel, not R! So I nominate it... but leave it to others to say whether it's really "qualified" to be nominated. ---- "The idea that the Excel solver "has a good reputation for being fast and accurate" does not withstand an examination of the Excel solver's ability to...

...@sort_by = ''last_name'' current_user = ''steve'' @records = Contact.find( :all, :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''] =...

Hi list, Despite the question I asked last time (I will re-install the FC3 with Samba 3.0.14a on another computer for replacement soon), I still have one more question on Excel files. I found that Excel file opening is extremely slow (especially on slow connections, i.e. VPN). The case is really bad, it takes around 2 mins to open a excel file of around 400k. Actually we got both side having 4M/4M DSL line. One side is Hong Kong, and the other side is China. However if we...

Hello, I just discovered that I cannot close the Excel application and task manager shows numerous copies of Excel.exe I tried both x$Quit() # shown in the rcom archive and x$Exit() and Excel refuses to die. Thank you very much. S. "You can't kill me, I will not die" Mojo Nixon I also have a problem with saving. It produces a pop-...

The idea that the Excel solver "has a good reputation for being fast and accurate" does not withstand an examination of the Excel solver's ability to solve the StRD nls test problems. Solver's ability is abysmal. 13 of 27 "answers" have zero accurate digits, and three more have fewer tha...

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 the error occurs when the excel sheet is open while R tries to write to it. But n...

Y muchas veces, se guardan los datos en esas hojas excel, donde los usuarios, que no son estadísticos, que no conocen R y no lo van a conocer completan esos excel. Es más cómodo hacer que guarden los datos en esos ficheros fijos respetando ciertas reglas en cuanto a formatos, estando dichos ficheros en ubicaciones fijas y llamar los datos desde R direct...

Dear all, I am interested in reading Excel spreadsheets (*.xls) directly into R (I am using version 1.1.1 at the moment). I have not had much luck so far. For the time being, I have been converting Excel files to comma delimited files (*.csv) and reading these into R (using commands such as "read.csv"). This works well, but it w...

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

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 http://www.r-bloggers.com/export-data-frames-to-multi-worksheet-excel-file-2...