similar to: newline with cell of Excel worksheet created with write.xls

I have a rails 3.rc app that I''m developing. I have a text entry in one my models that can sometimes be quite big. I tried setting :limit => 4294967296 on the text column in my migration file but this doesn''t seem to have any effect. The column is till created as a TEXT column rather than MEDIUMTEXT or LONGTEXT. Does anyone have any idea why this might be happening? Is there

I can currently append an entire worksheet with write.xls, but would also like to be able to append within the same worksheet. Is this possible? It doesn't seem to work if I use append = T Thanks, Mark -- Mark W. Kimpel MD Neuroinformatics Department of Psychiatry Indiana University School of Medicine

Hi list, Is there a R function I can use to extract the worksheet names from an Excel file?? If no, any other automatic ways (not using R) to do this? thanks! ...Tao

Hi, I would like to some excel files with some worksheets. I tried this with the following R script: library(gdata) i<-1 rc<-0 while(rc != "try-error") { wksh<-try(read.xls("cluster-microarray-FW.xls",sheet=i,verbose=TRUE,perl="perl")) rc<-class(wksh) print(sprintf("------- i=%2d rc=%s ---------------",i,rc)) if (rc !=

(I'm afraid this post didn't reach the list on last Wednesday, here it is again ) hi R-list, And sorry for my frenglish ! I am running R < Good Sport > release ( i386-w64-mingw32/i386 (32-bit) ) ) under Windows 7 Professional, Service Pack 1. My perl executable is ActivePerl build 817 [257965] (i.e. version 5.8.8.817). Usually it is working fine. Using the gdata ::read.xls

Hi - I have a dataframe of (x,y) values. I'd like to fit an exponential curve to the data for further statistical analysis (pretty much the same functionality provided by Excel's LOGEST worksheet array function). Can someone point me to the (set of) functions/ package that is best suited to provide this functionality? Admittedly, I am a novice in the use of R statistical functions,

Dear R-users, I have to read data from a worksheet that is available on the Internet. I have been doing this by copying the worksheet from the browser. But I would like to be able to copy the data automatically using the url command. But when using "url" command the result is the source code, I mean, a html code. I see that the data I need is in the source code but before thinking

I have some files stored in db. When I try to download these I only get 65535 bytes from the database even if the file is a lot bigger. Is it a Rails setting I''ve missed or a database setting? Anything else? Using Rails 1.0, WinXP and MySQL4.1 /Marcus

Hello! I have no problem reading Excel files (each worksheet in the file is a "table" which can be read - at least in my case). What I would like to do is to read such a table, change it (just the contents, not the format) and write it back, and this I can not do. I am getting the following error messages (3 slightly different attempts): > sqlSave(con, x, tablename =

I just upgraded the second half of a two node puppetmaster cluster and now I am having issues with puppet-dashboard report processing. If I have workers running on both servers, they try to process each others reports, but since the report data file is not there, it fails. I would have assumed this data was local, not in the database. Does anyone else have this issue, or have a suggestion

Hi I''ve got the error in the log file "marshal data too short" after I try to store some data into session. After doing some research on the internet, it looks like the problem was caused by pstore.rb. It is there way to solve this problem? Thank you -- Posted via http://www.ruby-forum.com/.

This is apache/fcgi/rails/firefox. When using a rails app we have been experiencing sudden blank pages in the browser. We show an model "new object" page and start changing stuff and all of a sudden the page will be erased to blank! Any idea what could cause something like this? -- Posted with http://DevLists.com. Sign up and save your time!

Dear All, I have a file data.txt as follows: Name_1,A,B,C Name_2,E,F Name_3,I,J,I,K,L,M I will read this with: my_data<- read.csv("data.txt",header=FALSE,col.names=paste0("V", seq(1:10)),fill=TRUE) Then the file will have 10 columns. I am assuming that each row in data.txt will have at the max 10 entries. Note: Here each row will have a different number of columns in

Dear All: I am trying to read the data from the different sheet but in the same Excel file. Does R provide this kind of command to do it? Anyone has experience on this? Thanks! Xin [[alternative HTML version deleted]]

Dear All, I would like to count or list the names of the existing worksheets within an .xls file. Any hints? Thaks, Gabor -- Pozsgai G?bor www.coleoptera.hu www.photogabor.com

Dear R experts, I am trying to import some data from some Excle files into R. My Excle file contains about 50 sheets. One solution I can think about is to convert my Excle file into csv file first and then load data into R using 'read.csv'. But it seems to me that 'read.csv' only supports reading one sheet (or 'one file') each time, so that seems I have to create 50 csv

I want to build an application that lets me (the end user accessing a web page) design a simple list with columns and add records. E.g., if the end user says I want a table that has a list of songs, he can create a list (title, date, artist, label) and then make another list of, e.g., books on his bookshelf with the necessary columns (title, author, pub_date, shelf). The end user

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

Hello all, Has anyone done one of these? I''ve done similar things in java and php, by having easy access to SQL statements. I am new to Ruby/Rails( I''ve been at it for 10 days ) and thus far find it extremely confusing. I''ve got a bit more of a handle on it from the Agile book that someone loaned me, but I still find it hard to understand. Anyway, I''ve got