similar to: read.xls (gdata) problem

I can use gdata to successfully read in the example Excel file, but not any other excel files. Why might this be the case? It seems that the problem has something to do with opening the database but no indication as to what the problem is. So i'm at a loss of how to fix it. > library(gdata) gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED. gdata: read.xls support

Dear All, When I use read.xls() in gdata package to read xls files, I noticed an issue and couldn't find any solutions after I serched all previous posts. In the excel file, the number value, for example, is actually 2.3456789 but formatted as 2.3 (Format Cells ---> Decimal places:1). After I use read.xls() to import the excel file, I found that, in R, this number is read as the formatted

Hi: Im trying to use gdata 1.1.2 on a rails3 ruby1.9 project I added gem ''gdata'' to Gemfile but keep getting the error: uninitialized constant GData:: I installed the gem with no problem Does anybody knows how to setup rails3 with gdata? I''ll really appreciate any advice -- You received this message because you are subscribed to the Google Groups "Ruby on

I wanted to install the package "gdata". Here are the commands I gave and the responses: install.packages("gdata") Warning in install.packages("gdata") : argument 'lib' is missing: using '/Users/dbae/Library/R/library' trying URL 'http://cran.uk.r-project.org/bin/macosx/universal/contrib/2.8/gdata_2.4.2.tgz' Content type

Hi one col in my Excel file contains many numbers. But on line 3000 and some other lines are strings like "FG 1". "RODBS" seems to omit this lines. "gdata" works, but is much slower. Is this a bug of RODBC or do I apply it wrong? Example with the same "file.xlsx" library(RODBC); excel <- odbcConnectExcel2007("file.xlsx") tab <-

Hi Using R 2.10.1 on a mac os 10.6.2, I have have a problem with gdata package. When I use the command read.xls, I get this error-message: Erreur dans xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Unable to read translated csv file '/var/folders/gb/gbzQ4sqTF-KK3D5m6v-IJE+++TI/-Tmp-//Rtmp3Hprw9/file10d63af1.csv'. Erreur dans file.exists(tfn) : argument 'file'

Dear R-list members, I have a data file with thousands of lines (cases), where each line contains the values of several variables. I would like to separate these lines in small groups, with each group followed by a blank line, to ease the visual inspection of the data in some situations. I am writing the output files with function write.fwf in library gdata, for correct column alignment. Below

Hello, We have submitted the updated version of gdata, gmodels, gplots and gtools to CRAN. Summary of the changes is attached at the end. Best, Nitin ______________________ Nitin Jain, PhD <nitin.jain at pfizer.com> Non Clinical Statistics Pfizer, Inc. (Groton, CT) Bldg: 260, # 1451 Ph: (860) 686-2526 (Office) Fax: (860) 686-6170 Brief description of changes: CHANGES IN GDATA 2.1.2

Hello, We have submitted the updated version of gdata, gmodels, gplots and gtools to CRAN. Summary of the changes is attached at the end. Best, Nitin ______________________ Nitin Jain, PhD <nitin.jain at pfizer.com> Non Clinical Statistics Pfizer, Inc. (Groton, CT) Bldg: 260, # 1451 Ph: (860) 686-2526 (Office) Fax: (860) 686-6170 Brief description of changes: CHANGES IN GDATA 2.1.2

Dear List: I encountered this strange problem. I want to read dates in a R program. This is a sample data: Dates 12/12/08 14/12/08 18/01/08 28/02/08 16/06/08 19/07/08 28/09/08 If I save these dates in a .csv file, and read it in R using "read.csv", I can perfectly read the data, and the commands "months(Dates)", "days(Dates)" work perfectly fine. On the other hand,

Dear R-list This is just message to inform that the there is an issue with write.fwf in the gdata library (from version 2.5.0 on). It does not seem to accept further arguments to write.table like "eol" as the help file indicates as it stops when executing tmp <- lapply(x, format.info, ...). Great package though - I use it a lot except for this function :) See example below. >

Dear list, I have some .xls files that I need to read into R. I am able to do so using read.xls in the gdata package, however the helper functions sheetNames and sheetCount fail. This is the error: Unable to open file '~/SharedFolder/MyData/mydata.xls'. Warning: running command ''/usr/bin/perl' '/usr/local/lib/R/site-library/gdata/perl/sheetCount.pl'

Dear R People: If I put in: > findPerl Error: object 'findPerl' not found But if I use: > gdata:::findPerl function (perl, verbose = "FALSE") { errorMsg <- "perl executable not found. Use perl= argument to specify the correct path." if (missing(perl)) { perl = "perl" } perl = Sys.which(perl) if (perl == "" ||

I'm trying to make a factor with levels for day of week, appear as Monday-Sunday, rather than alphabetically. I'm using reorder.factor from gdata package, but obviously not using it properly. What am I doing wrong? Thanks. >data <- read.table("DataEarly2008.txt", sep=" ", header=T, as.is=1:2) >str(data) 'data.frame': 7953 obs. of 9 variables: $

hi see below's conversation. it seems the e100p card doesn't work with BT. Any idea how this'll work against Telenor (norway)? roy <RoyK> does anyone know if I can trust the E100P to do full PRI stuff in .no? <cypromis> dunno about no <cypromis> I cannot use it in UK <cypromis> cause the framer has problems with system-x switches at bt

Hello eveRybody (and probably special regards to Gabor G....), I recently upgraded from R-2.9.2-win32 to R-10.1.0-win32, and I'm using Windows XP Professional 2002 with service pack 3 on a PC with IntelCore Duo CPU@ 3.00 GHz. Last time I used it (some weeks ago, before upgrading), one of my scripts (including the two lines cited below) used to run OK. When I ran it yesterday evening (after

Dear R-list members, I have just downloaded R version 2.11.0. Then I installed package gdata. At the end of the installation, a warning message said that package gtools could not be found. Package gdata was, after the installation, included in the "Package Index" in the help files. Messages during installation (which was made through the menu Packages / Instal package(s), choosing the

(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

this may be an easy question, but i am unable to solve it: i want to take the selected choice and process it in the controller: TEMPLATE: <%=start_form_tag :action => ''get_article'' %> <select name=pricelist> <%= options_from_collection_for_select (@customers, "id", "name") %> </select> <%= submit_tag "Get" %>

Hi, I just installed Ubuntu 12.04.4. I installed R by following instructions from CRAN after modification into my /etc/apt/sources.list file sudo apt-get update sudo apt-get install r-base sudo apt-get install r-base-dev When I try to load library(gdata) ou library(gplots), I have error message : library(gdata) gdata: read.xls support for 'XLS' (Excel 97-2004) files