similar to: Downloading Excel file & reading a range

Hi, I'm attempting to use the RODBC package on Windows Vista to import an excel spreadsheet. The spreadsheet has three worksheets the last of which is blank. Following an example in Phil Spector's book (p. 34), after creating a connection named con I did the following: > con RODBC Connection 3 Details: case=nochange DBQ=c:\temp\test.xls DefaultDir=c:\temp

Can someone throw light on the following problem I am having with RODBC? There's an Excel file I am trying to read from, it has one sheet named 'nameclass'. Thanks in anticipation. Vishal Belsare > library(RODBC) > con = odbcConnectExcel(file.choose()) > tbls <- sqlTables(con) > tbls TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1

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'

Hi List, I'm trying to upgrade our llvm-c based compiler from JIT to MCJIT. While trying to do so I encountered several problems. Looks like C API does not have proper functions to intialize LLVM with MCJIT. I ended up wrapping the following functions in my own init routine. LLVMInitializeX86TargetInfo(); LLVMInitializeX86Target(); LLVMInitializeX86TargetMC(); LLVMInitializeX86AsmPrinter();

I managed to make it work by cloning code from lli and making my own cpp wrapper. 2013/9/22 Konstantin Olkhovskiy <lupus at oxnull.net> > Hi List, > > I'm trying to upgrade our llvm-c based compiler from JIT to MCJIT. > While trying to do so I encountered several problems. Looks like C > API does not have proper functions to intialize LLVM with MCJIT. > I ended up

Hi all, Been working with prototype and script.aculo.us now for around 3 days after never really touching javascript so I am still getting to grips with things. So far I have successfully created 4 ajax based functions, or so I thought until I stupidly showed a client one of them before I had tested it in IE. The function in question works fine in FireFox succesfully inserting any new values

Is anyone successfully using the AGI script calleridnamelookup.agi (or anything similar) ? I get both name and number caller ID from my POTS line, but I'd save money if I had them deliver ANI only. I've downloaded and installed the AGI script calleridnamelookup.agi, but I always get -- Executing AGI("SIP/9525485560-5359", "calleridnamelookup.agi") in new stack

Dear R Users, I was using R to import five years traffic data, but the error always come up as shown below. The data frame contains 12 columns and unknown number of records. Would you have any ideas that how I should deal with this situation?? Many thanks for any hints. >wim<-sqlQuery(channel,qry) Error: cannot allocate vector of size 24.0 Mb In addition: There were 16 warnings (use

R-help list, I ported some R code from MS Windows PC to sun-solaris. Both do queries on the same MySQL database. PC version of R is 1.6.1 and solaris version is 1.6.0. I use RMySQL_0.5-0 (on solaris) and RODBC 1.0-1 on PC to connect to MySQL. The PC version took about 65 mins. to run wheras the Solaris (SunOS 5.7) version took 375 mins. (> 6 hrs). R and RMySQL are resident on the same host

One of the things my employer uses dovecot for is as mail download server for an 'e-mail purification service' (AV/ anti-spam) for smartphones. The service itself presently runs on a rented server somewhere in the UK and the corresponding 'web service' front-end and user account/ mail account database resides on a server in Germany. The UK dovecot server uses the PostgreSQL server

R 2.8.1 Ubuntu 64amd RODBC 1.2-5 --------------------------------- This was a hard-to-track bug for me, because sqlQuery() did not fail - instead, it looked like it returned some good data and some NA where there should have been numbers and 0 where there should have been NAs. I did: (a) sqlQuery( o, qry, as.is=TRUE, errors=TRUE, rows_at_time=1024 ); (b) sqlQuery( o, qry, as.is=TRUE,

Hi, First of all, thanks for the efforts of all the developers and contributors - I'm very new to R and at the moment am just using it to create some graphics, but it seems to be quite powerful. I've googled the archives and wasn't able to find anyhting that dealt with this problem, so would appreciate any suggestions/tips. In a pairs plot I'd like to plot a linear regression line

Dear list. Has anybody had any issues with ROracle, namely consistently leading to a segmentation fault? One of our oracle databases seems to have certain issues at the moment (do not know what exactly though) and if that one is queried ROracle definitely fails with a segmentation fault. Any ideas? Here is the trace and below is also a type of query that crashes it: *** caught segfault ***

Hi First off, thanks to all the various R developers, your package is very impressive. I'm not sure what the protocols are for contributing, and I've not done this before, so please excuse nay obvious errors or oversights... Also I'm by no means an R,TeX/LaTeX, or typesetting expert, I have largely stumbled my way to this point. Objective: I'd like to get R postscript(...) to

Dear all, I have some problems with importing data from an Access data base via RODBC to R. The data base contains several tables, which all are imported consecutively. One table has a column with column name "NO". If I run the code attached on the bottom of the mail I get no complain, but the column name (name of the respective vector of the data.frame) is "Expr1014" instead

This code below produces empty XXX.png files - if I use plot(), it works and if I enter the commands png(filename=fn) bubble(positions, do.sqrt=FALSE, main=q) dev.off() manually, it works as well. I am lost - any help appreciated. The weird thing is that it worked before I made some changes... (I don't have a copy of the working version...). R version: platform i686-pc-linux-gnu arch

# Set everything else to deny all other network access (debug=1): $tbls -A dsl-for -j LOG --log-level $debug --log-prefix "dsl-for Everything Else " $tbls -A dsl-for -j DROP packets originating on my VLAN (eth0.5) destined for the Internet get logged with their IN/SRC, OUT/DST logged backwards. For instance, this is Cobian Backup (http://www.cobian.se/cobianbackup.htm) on my Windows

Hi All, My Samba server/firewall has three (two real, one virtual) network cards: eth0.5: connects to a terminal server eth0: internal network with about 10 XP workstations eth1: the Internet Samba is set to talk to only 12.0.0.1, eth0.5 and eth0. I have my firewall iptables rules set so that users on eth0.5 can only use the samba server on my server. They can not share with any other user on

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

Sure I will split it and put it in two patches. Give me few hours. I need to test those patches. Sirish On 4/19/2012 8:40 AM, Tom Stellard wrote: > On Wed, Apr 18, 2012 at 11:18:05PM -0500, Sirish Pande wrote: >> Hi, >> >> Here's a patch for Hexagon Packetizer for review. This patch does >> not yield any warnings. >> > Would it be possible to split this