Re: [R] Any reason not to use RUnit any longer?

Thanks a lot for the feedback, Dirk and Mehmet, My (large) test-code is in RUnit and so I'm glad to hear that it is fine. RUnit worked very well for me and I do not have a reason to switch. [[alternative HTML version deleted]] __ R-help@r-proje

[R] Any reason not to use RUnit any longer?

t. If it makes a difference, I do _not_ use roxygen and stay close to R-exts standards (ok, a testing framework I'd like to have). Thanks for any advise / opinions, Hans-Peter [[alternative HTML version deleted]] __ R-help@r-project.org ma

[R] [offtopic] nice R related domains to give away

ee for the costs but this is not a precondition. My email: gchappi, and then gmail.com. Cheers, Hans-Peter [[alternative HTML version deleted]] __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/li

Re: [R] help to ... import the data from Excel

Writing multiple tabs was never supported in the free version (only in Pro). XLConnect certainly looks good and also has the advantage that it is FOSS, something I cannot do because of the usage of a proprietary library. Cheers, Hans-Peter __ R-help@r

Re: [R] help to ... import the data from Excel

ed to learn what you mean with "better luck reading/writing". Thanks a lot and Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/p

[R] Free license for xlsReadWritePro

uot;, Count = 1, Key = "76991137f5f554a288e8cee343a24722", WhereToStore = "ProgramFolder" ) ) Info/download at http://swissr.org. Direct download links at http://dl.dropbox.com/u/2602516/swissrpkg/index.htm

[R] xlsReadWrite 1.5.4 and xlsReadWritePro 1.6.4 released

ment. Both updated packages are available now from www.swissr.org/download or - full listing - here: http://dl.dropbox.com/u/2602516/swissrpkg/index.html. Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help

Re: [R] ReadWrite.xls problem

s for me :-( There are many ways to read/write data in R: * Other than load/save you could use read.table/write.table (see R Data Import/Export). * Using Excel files is not the recommended way. However when you want/need it, there are several options (see http://rwiki.sciviews.org/doku.php?id=tips:data-io:

[R] Updates for xlsReadWrite (1.5.3) and xlsReadWritePro (1.6.1/3)

;, 'what' arguments dropped (always provide full info) - SOME LIST ELEMENT names have been RENAMED/ADDED - some double types have become integers o date time helper functions: - properly initialize format settings (with GetUserDefaultLangID, it proba

[R] Fix for xlsReadWrite 1.5.2 running in R2.12.0 (32-bit) on a Win7 64-bit platform

r R2.12 building atm)) When executing 'library(xlsReadWrite)' with the updated dll, the startup message will read '..version 1.5.2 (sha1: )'. Changes have been pushed as http://github.com/swissr/xlsreadwrite/commit/17a8d1c076b622f842cae443ebff00b1bb254bbe. Ch

[R] [R-pkgs] xlsReadWrite v1.5.2

ystem' -- o issue tracking (developer) link change: - http://dev.swissr.org (was: https://redmine.swissr.org) - allow guest login and directly mention credentials Cheers, Hans-Peter ___ R-packages mailing list r-packa...@r-project.org https://stat.ethz.ch/m

Re: [R] help

or library(xlsReadWrite) write.xls(tab, "somefile.xls") # not .xlsx or lots of other possibilities (e.g. RODBC, RExcel, gdata, WriteXLS) you would have found searching the mailling list archive or looking in the R import/export manual or the R wiki... Cheers,

Re: [R] Need to read an Excel File

ile.exists(tfn) : invalid 'file' argument The 'read.xls' function in the the xlsReadWrite package (Win32 only) doesn't have external dependencies. Might be an option as well. Cheers, Hans-Peter __ R-help@r-project.org mailing list htt

Re: [R] reading dates in Excel into R

e .txt (after having formatted the dates in the > format you need, e.g., mm/dd/). And then you can read it > (including dates) into R no problems. If you are on windows and (can) use .xls files, my xlsReadWrite package should work well with dates. Cheers, Hans-Peter ___

Re: [R] Image into Excel file from R

d and check ?xls.lic first; www.swissr.org). I'm just finishing 'some' :-) RUnit tests and a new version will be released tomorrow or after tomorrow. Cheers, Hans-Peter rfile.img <- sub("origData", "origImage", rfile, fixed = TRUE) wfile.img <- sub("tmpWr

Re: [R] emacs: reformat \items paragraph in .Rd

Many thanks! The missing empty line was the problem, and M-q works great. Hans-Peter > Esc-q or M-q will wrap a whole paragraph. The only problem is that you need > to make sure the paragraph you want to wrap is separated from other __ R-

[R] emacs: reformat \items paragraph in .Rd

c-j', ... There certainly must be some easier way to reformat a paragraph? (I tried 'm-c-q' (not defined) and 'm-c-\' (but was not able to input the backslash); I'm on GNU Emacs 23.1.1 (i386-mingw-nt5.1.2600). Thanks for your help! Hans-Peter _

Re: [R] Failed install of package xlsReadWrite

, i.e. non-cran version, R2.10.x): 1.5.1: http://dl.dropbox.com/u/2602516/swissrpkg/bin/win32/2.10/xlsReadWrite_1.5.1.zip devel: http://dl.dropbox.com/u/2602516/swissrpkg/bin/win32/2.10/xlsReadWrite_0.0.0.zip Hope this helps! (Otherwise feel free to contact me by email (gchappi gmail), this really

Re: [R] Failed install of package xlsReadWrite

0.0-versions are development versions. They will be updated when there is something 'fixworthy' while a new official version is 'in wait mode'. Currently 0.0.0 fixes a bug with non-absolute file paths in 1.5.1. Cheers, Hans-Peter __

Re: [R] Excel-Export

t to html, then manually hack around with a texteditor..., not a good idea, imho. RDCOM is better. Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/pos

Re: [R] Excel-Export

eR, password: namaste (sha1 fingerprint: A4:28:1D:3A:C3:96:01:4B:8F:4C:FC:AD:E7:B5:B7:84:B1:6B:7A:E7) Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project

Re: [R] Do you keep an archive of "useful" R code? and if so - how?

ol system, I would recommend looking into a distributed one. - Personally I use git. http://git-scm.com/ is a good start, http://www.github.com can be used to store code 'in the cloud'. Cheers, Hans-Peter __ R-help@r-project.org mailing lis

Re: [R] PowerCut Killed R - is my code retrievable?

git but Subversion (SVN) may be easier and do the job). Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide c

Re: [R] Export data to Multiple Sheets in Excel via xlsReadWritePro

2009/7/2 Chris Anderson : > Is there a way to export multiple datasets into multiple excel spreadsheets > using xlsReadWritePro or with xlsReadWrite? I have answered the question in your other thread. See: http://thread.gmane.org/gmane.comp.lang.r.general/154614/focus=154752 Cheers, Hans

Re: [R] what happened to the xlsReadWrite package

the recent 2.9.1. Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

Re: [R] help exporting to excel via xlsReadWritePro

# first sheet shall be active when spreadsheet is opened xls.close( xls )# save and close memory represention Hope this helps/clarifies things. Otherwise feel free to ask again (PM prefered as it's probably better not to use the r-help mailli

Re: [R] reading Excel file

> Is there any alternatives to read Excel file ? RODBC, RExcel, gdata, use COM (search this forum for code). Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-

[R] fix for RMate (TextMate/E-Texteditor bundle)

Arg, I already needed to fix the bundle. If anyone downloaded it yesterday, please update, the help index building was broken (on Macs). Should work now. Repo/Infos: http://github.com/swissr/rmate.tmbundle/tree/master -- Regards, Hans-Peter __ R-help

[R] [Ann] RMate, a bundle for TextMate and E-Texteditor

(http://github.com/swissr/rmate.tmbundle/downloads) - unzip and rename to 'rmate.tmbundle' (i.e. remove swissr- and -hash) - double click to import into TextMate' Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/m

Re: [R] How to convert blanks to NA

' argument. But this is something that should be supported since longtime also in the normal xlsReadWrite. Thanks for reminding me :-) and it's now - at least - in my Redmine tracker. Cheers, Hans-Peter __ R-help@r-project.org mailing list h

Re: [R] Most used R editors

R bundle (or RMate, own variant thereof). On Windows I use E-Texteditor, TM's cousin. Albeit there are some bugs & issues, E-Texteditor is quite a decent editor and with the RMate bundle (will publish it sometime) lines can be sent to RGui and info/help pops up. Wouldn't go back to Ti

Re: [R] Re ad & name multiple excel sheets using RODBC

2009/5/28 Dieter Menne : > If you only have the sheet names, you should use package xlsReadWrite which > is rather fast, but has some limitations in the non-commercial version. what limitations, i.e. features do you miss? Cheers, Hans-Peter __

Re: [R] Surface for R outside of R

h a solution possible?  What about batch scripts which would be called by your GUI? (maybe you could even skip the gui...) (see ?Rscript (unix alike) or Windows FAQ, 2.12) -- Regards, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailma

Re: [R] Environments

>> rename(x,"C","Z") > x <- rename(x,"C","Z") > x A B Z D 1 2 3 4 -- Regards, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the po

Re: [R] xlsReadWrite library

w RUnit tests, adapted build scripts, etc., I'll ask again if 'xlsReadWrite' will be accepted on CRAN in this new source-only form. I hope so, but if not then there are other possibilities. In any case I intend to put the repo at some public space (most probably github). Cheers, Hans-Pete

Re: [R] read.xls question

imho. Reading natively without depending on additional layers (driver, perl, COM) benefits too. - If you mean 'more R standard' or OSS then I agree. Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-h

Re: [R] Creating an Excel file with multiple spreadsheets

2009/3/9 Phil Spector : > The xlsReadWrite package provides write.xls for Windows, but it cannot write _multiple_ spreadsheets -- Regards, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read

Re: [R] xlsReadWrite package repository for Ubuntu

t uses a third party library (Flexcel, TMSSoftware). This library supports FreePascal which means that theoretically xlsReadWrite could be compiled for Linux/Mac (tried once, didn't succeed, will try again later (now also using Macs and Debian/Ubuntu)). -- Regards, Hans-Peter

Re: [R] Dates and times from Excel

ndatetime' for the 'colClasses' argument be useful? -- Regards, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

Re: [R] problem with writing data to *.xls file

calculate and prepare full data to write calc <- dat[,2] + 1 dat <- cbind( dat[,1], dat[,2], calc, dat[,3] ) # write (sheet will be overwritten with new data) #write.xls( dat, myfile ) -- Regards, Hans-Peter __ R-help@r-project.org mailing list

[R] Building binary package fails because of missing dependent package

I need to have installed all packages which are required by packages to be built binary (source builds are ok)? Cheers, Hans-Peter --- Macintosh:mxFinance chappi$ R CMD BUILD --binary mxFinance * checking for file 'mxFinance/DESCRIPTION' ... OK * preparing &#x

Re: [R] Editor for Mac

> Thanks for the answers, > but I'm looking for an editor like Tinn-R. What about VM Fusion and continue to use Tinn-R then? -- Regards, Hans-Peter PS: I use TextMate (and like it) __ R-help@r-project.org mailing list https://stat.ethz

[R] Small xlsReadWritePro update

Brochure: http://treetron.googlepages.com/xlsReadWrite_Pro_Datasheet.pdf Best regards, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.h

[R] publish R on gotAPI ?

I recently stumbled across www.gotAPI.com which is a really nice site to lookup infos of many different languages. - Wouldn't it be a good idea to submit a request to add R? -- Regards, Hans-Peter [[alternative HTML version deleted]] ___

Re: [R] reading Excel file

ile = fn, dateTimeAs = "numeric" ) dat[,3] <- dateTimeToStr( dat[,3] ) # or any other conversion function dat } 'dateTimeAs' argument is (probably) needed to retrieve plain numbers and override the default conversion to date string. -- Regards,

Re: [R] reading Excel file

d.xls( "D:\\file.xls", colClasses = c( rep( NA , 2 ),"isodate", rep( NA, 9 ) ) ) should work. But you still have to know the total number of columns. (The pro version does have a xls.info command and/or you could read in just the first row and check its content). -- Regards, Hans-P

Re: [R] Importing an Excel spreadsheet

adsheets -> you can also find my package xlsReadWrite which natively reads Excel files (Windows only). Using *.csv file is probably the more common/recommended way but be careful with 'cutted decimal places'. -- Regards, Hans-Peter [[alte

Re: [R] Reading microsoft .xls format and openoffice OpenDocument files

> > I looked at the package (it's > http://cran.r-project.org/web/packages/xlsReadWrite/index.html) but > it's windows only. So no joy yet. which platform would you need it? Regards, Hans-Peter [[alternative HTML version deleted]] ___

Re: [R] Export csv data

r with the writing. If you provide me a small mydat dataset I could probably help better. Best, Hans-Peter [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do rea

Re: [R] R data Export to Excel

RAN mirror)->(Select the package)->done. Best regards, Hans-Peter [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.

Re: [R] Hiding a function

> > After some private email with some high level programmer (Gabor), I have shouldn't that rather be: high in knowledge but low in level? Best, Hans-Peter [[alternative HTML vers

[R] Update xlsReadWritePro v1.3.2

need/want it. Otherwise there is always our free xlsReadWrite version (where our own code is free (GPLv2). Best regards, Hans-Peter [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r

Re: [R] How to make own function load automatically on startup

ore about this > function? > help("::") -- Regards, Hans-Peter [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-p

Re: [R] Import from excel 2007

l be a Mac, therefore...) - it reads and write in the Excel 97-2003 xls format (BIFF8). (With Excel 2007 you'd have to choose the compatibility mode for now and thus fall back to the 65536 rows and 256 columns limit). Regards, Hans-Peter [[altern

[R] Download old R-2.5.1 version?

Is it possible to download somewhere the former 2.5.1 windows bin version of R? (Need it for testing). Thanks, Hans-Peter [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help

Re: [R] Read in date fomat while colClasses="character"

ever starts from row 10. So to read data from column one I use > colClasses="character". But this overrules the isodatetime. another possibility would be to give a vector for the colClasses argument, e.g. colClasses = c( "character", "character", "double&q