similar to: read.xls counts more rows than I really have in my Excel file

some times ago i was playing with coding, shannon theoremes and other stuff, i have tried without success to compress audio wave, and i have notice that simply oversampling audio material enacnhe a lot compression ratio i only take awav file, oversampled it by 20 tiimes and then compressi it using pkzip or rar. i don0't remember if i also do a CONSTANT PREDICTION, iony know that pkzip and

Hi, I have 12 independent variables and one dependent variable. Now I want to select the best adj. R squared model by using the regsubsets command, so I code: > plot(regsubsets(Gesamt ~ CommunistSocialist + CountrySize + GNI + Lifeexp + Schoolyears + ExpMilitary + Mortality + + PopPoverty + PopTotal + ExpEdu + ExpHealth, data=olympiadaten, nbest=1, nvmax=12), scale='adjr2') Then I

Hi, I encountered a problem of not being able to read in an excel spreadsheet using read.xls() in the xlsReadWrite package. can anyone help? Here is an example code write.xls(matrix(1:9,nrow=3),"ttt.xls") read.xls("ttt.xls") Error in read.xls("ttt.xls") : Unexpected error. Message: Can't find the file "ttt.xls" The "ttt.xls" file was

One can import data from Excel ODBC source, but of course it is user's responsibility to ensure that the data are consistent. Each worksheet in the Excel workbook can be accessed as a table (for example, for Sheet1, you should type "select * from [Sheet1$]". The worksheet should have first row containing the column names, and the data rows should follow (the

As part of my project to put different types of results into worksheets, I would like to be able to put an auto-generated methods section. If I compose in RWinEdt, read into R, and use write.table with a .txt file extension, what I get out has line-breaks that correspond to those I put in in the first place. If I do the same thing but write.xls with .xls extention, I get an Excel worksheet

Sorry for this trivial question. I have just installed R on SuSE/Linux and cannot cope with the character terminal. I am going to install JGR that will make my life easier at searching for existing R functions/packages. In the meantime (higher-priority things to do) I would appreciate your answer. Thank you for your patience. Maura tutti i telefonini TIM! [[alternative HTML version

A path like this: \\samba\ä\a.xls cannot be found by Excel unless the user (or his group) has the write privilege on the file. (The funny looking directory name is a German "a" with a lazy colon on top of it, ASCII code 0xe4.) A symbolic link "ae->ä" solves the problem: \\samba\ae\a.xls pointing to the same file through an ASCII symbolic link is OK but

Hello everyone, What is the simplest, most RELIABLE way to import data from MS EXCEL (.xls) format to R? In the past I have used the read.xls() function from the xlsReadWrite package, however, I have been wrestling with it all afternoon long with no success. I continue to receive the following error message: > {widge<-read.xls("F:\\Classes\\Z1.Data\\stat.3010\\WidgeOne.xls", +

Hi all, I have a queston about Categorical response. i have a data frame containing age, sex, class, success(1=success, 0=non sucess). age, sex,class are the explantory variables, and sucess is the response variable. and i can get n (the nunber of times each age occurs) and r (the number of sucess of that age). when I try to creat the regression relationship for these variables, I have seen

Hi all, There have been quite a few threads in the recent months pertaining to the ability to directly write native Excel (.xls) files from R. For example, exporting R matrices and/or data frames to an Excel file, with perhaps the ability to create multiple tabs (worksheets) within a single file, with one tab/sheet per R object. There exists the xlsReadWrite package on CRAN by Hans-Peter Suter,

I gather from reading the back-issues of r-help that it should be possible (modulo a number of caveats) to read an excel (yuck!) file into R using RODBC. I have obtained and installed ODBC and the RODBC package, but cannot for the life of me figure out how to go about it. Can anyone give me a simple recipe? I have an excel file on cdrom, say: /mnt/cdrom/melvin.xls I have started R and loaded

Dear, I have a Linux Samba server and a Windows XP SP2 client joined to the "g-company.net" domain. I want to access a Linux share resource in /var/share without password from WXP desktop FROM ANY USER. This is my scenario: - I don't create any Linux local user because I want total access from any user - I use security = share - My smbusers file is: root = administrator admin

r-help, Is there a package available for R which allows you to export data directly to .xls, much like exportData(foo,"foo.xls","EXCEL") in S-PLUS ? If not, is anyone working on this, or thinking about working on this? I apologise in advance if this question has already been answered. Many thanks, Matthew

Hi, If I open up a worksheet in MS Excel 97, the file name is modified by appending an extra .xls to the name. Multiple .xls's are possible, and it is not necessary to save the worksheet. I'm running Wine-20010305 compiled on a SuSE 7.0 running a stock 2.4.2 Linux kernel. MS Excel is being run from an existing Win98 system partition. Thought someone might want to know, Dick --

Hi, I am having problem with the read.xls function. I am trying to read a .xls file but it's giving me error. > read.xls("XXX.xls") Error parsing file 'XXX.xls'. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file '/tmp/Rtmp5QQjSI/file1665315c.csv' missing! In addition: Warning message: running command

Dear R list, I am trying to read in .xls files. I have tried using package 'gdata', I get the following error. > dataset <- read.xls("June.xls") Wide character in print at /Library/Frameworks/R.framework/Versions/2.14/Resources/library/gdata/perl/ xls2csv.pl line 262. Seems like this is a problem coming from Perl? I tried to install package 'xlsReadWrite', it

Hi All, In my code @format_text = @workbook.add_format(:bold =>false) I get following error undefined method `font'' for {:bold =>false}:Hash in gems/spreadsheet-0.6.4/lib/spreadsheet/excel/writer/workbook.rb:352 when i try to export data into the XLS i am using following gems spreadsheet --version 0.6.4 spreadsheet-excel --version 0.3.5.1 My problem is when i use same code

Dear list, I used read.xls to read in an excel file, which has both character and numeric columns. Everything seems fine except in the last column, I have this character value "ng/ml". When reading in, read.xls seems to add a space at the end of it, became "ng/ml ". How can I prevent read.xls doing so? Thanks. >read.xls(data, header=T, as.is=T) Jun [[alternative HTML

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

I know a lot of people asked similar questions like this. I have tried using read.xls () Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Incorrect number of arguments (11), expecting 10 for ReadXls read.table or read.csv (Wrong table format) odbcConnectExcel have problem with the URL I want to import this excel file