similar to: RODBC - XLSX files - dropping/clearing sheets

Hi all, This is a little off-topic, but it is on the general topic of getting data in R. I'm looking for a excel macro / vba script that will export all spreadsheets in a directory (with one file per tab) into csv. Does anyone have anything like this? Thanks, Hadley -- http://had.co.nz/

Hi, How can I attach chart/plot to a excel file? I would like to create a plot in R eg. plot(1) and save it into a Excel file, eg. test.xls in a same working directory. Regrads, -J

Dear all, I use the package RCOM to manipulate Excel-Files (Windows). After opening the Excel-File and formatting the cells I want to save the file automatically without request. If I use y[["Save"]] <- TRUE it opens the saving dialog and I have to select the destination for saving. But I simply want to overwrite the existing file without any other workings. Thany your very much

Hello together, i have a list of numbers, like this one A B C 1.1 1.2 1.3 i export this list into an excel file and want now color these numbers according to her value. I want every color under 1,25 is red, and every color over 1,25 is green. How can i do this with "RDCOMClient" ? I know how to colour a complete row, like this task: U3R <- sh$Range(zellen_blue) U3RF <-

Hi all, I have got 27 graphs to export (not a lot...I know!). How can I fit all of them into a single file like PNG without adjusting the size of the graphs? What's in my mind is like pasting graphs into Word, in which I can just scroll down to view the graphs. Thanks for your attention. Much appreciated. Chris -- View this message in context:

I have several hundred Excel 2007 data files in a folder. I would like to read every file in a single given folder using a loop. I have searched the FAQ, the forum archives here, other or older R boards and the R Import / Export documentation, and have asked some very knowledgeable R users without learning of a solution. I hope someone here can help. I understand that the most common

Hi,   I am trying to import data directly from an excel spreadsheet using the RODBC package. I am getting the following error messages, wondering if anyone can help me with it?   > connection = odbcConnectExcel('D:\\R files\\TestData.xls') > tables = sqlTables(connection) > tables    TABLE_CAT TABLE_SCHEM  TABLE_NAME TABLE_TYPE REMARKS 1 D:\\R files\\TestData        <NA>

Dear List, I have a problem with RODBC on a Paradox-DB, sqlQuery, and special characters in table names. Unfortunately, some of the latter include the underscore <_>. And I am not able to change them. That's not a problem, when I quote the table name: > sqlQuery(channel2, 'SELECT * FROM "anmeldung-alt"') Btw, if I swap ' and " it does not work: >

Goldmine seems to a compiled database application compiled in something likeClipper. Clipper applications record lock through ISAM like files (DBF). However, in Windows NT/2000/XP, Opportunistic locking is turned on by default in order to accelerate file transfer from file services. [Windows 95/98 did not Opportunisticly lock] However, opportunistic locking corrupts ISAM and ISAM like

Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) > channel <- odbcConnectExcel("results.xlsx") Error in odbcConnectExcel("results.xlsx") : odbcConnectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel

I've a weird problem with Samba. I'm using Samba to share a filesystem between two linux systems because I believe I need byte range locking to prevent multiple processes on different computers from reading/writing the same ISAM records. I have a Debian wheezy file server running Samba; no domain controller, just a simple, single share. I have a debian wheezy KVM mounting a share via

You were correct. The problem was with smbfs. But now I have aproblem I didn`t have before: if a file is open by the application in Linux I can not create new records thru the application in Win. I can modify existing records but I can not create new records. Any ideas Jos? Guimar?es [ pg@moose-software.com ] Director Moose Software http://www.moose-software.com -----Mensaje original-----

Dear Listers: I have a couple of data frames to report and each corresponds to different condtions, e.g. conditions=c(10, 15, 20, 25). In this examples, four data frames need to be exported in a "pretty" report. I knew Perl has some module for exporting data to Excel and after googling, I found R does not. So I am wondering if there is a package in R for generating good reports. I

Hello friends, I've got a strange problem with my cluster-setup. I've got two nodes called www1 and www2 running Ubuntu Linux 8.10. The have a 50G volume which is replicated in primary/primary mode with DRBD. On this volume there is an OCSF2 filesystem with this two nodes. Everything is working really fine, files are perfectly mirrored, really nice. On one of the

Dear Adrian, I would like to export a quite large matrix from R to Excel (40 columns, 257 597 rows). After 10 minutes of work, I get the following error message: Error in .jcall(row[[ir]], "Lorg/apache/poi/ss/usermodel/Cell;", "createCell", : Java Exception <no description because toString() failed> This is the code I used: write.xlsx(wvs19812008hm,

Hi Adrian, dat=data.frame(matrix(0,3,3)) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F) The above code works and creates new worksheets. But if I want to append to an existing worksheet I seem to get an error.

I have a heterogeneous network with a R.H. Linux server running Samba 3.0.5 and various Win clients (from Win 98 to Win XP Pro). On a Samba share I have an ISAM database (Access, FoxPro etc. like) that is being accessed by applications running on the Win clients and by applications running in Linux. I have disabled "opplocks" in both Win9x clients and on the Samba share. I have

Hi, I've got a problem with RODBC and saving (sqlSave) of a dataframe in Access. R 2.0.1 is running on windows XP. When executing the examples in R help for the "USArrests" data set "sqlSAve" works fine, but running sqlSave() for a dataframe "Adat" > str(Adat) `data.frame': 1202 obs. of 18 variables: containing 18 columns and ca. 1200 rows fails.

essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15" ,case="oracle") > sqlTables(essai)$ORESTE ... 1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA> 1316 <NA> ORESTE S_PROVENANCES TABLE <NA> 1317 <NA> ORESTE

Hi, everyone, I try to run as follows: Z>library("RODBC") Z>cnct<-odbcConnectExcel("Forbes2000.xls") Z>cnct RODB Connection 1 Details: case=nochange DBQ=C:\Program Files\R\R-2.5.0\Forbes2000.xls DefaultDir=C:\Program Files\R\R-2.5.0 Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5 Z>sqlQuery(cnct, "select