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] Any reason not to use RUnit any longer?

. 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 mailing list

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

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/listinfo/r-help PLEASE

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

the advantage that it is FOSS, something I cannot do because of the usage of a proprietary library. 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

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

be interested 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/posting

[R] Free license for xlsReadWritePro

, WhereToStore = ProgramFolder ) ) Info/download at http://swissr.org. Direct download links at http://dl.dropbox.com/u/2602516/swissrpkg/index.html. Support (tracker) at http://dev.swissr.org/. Let's hope that Libya will become free, Hans-Peter __ R-help@r

[R] xlsReadWrite 1.5.4 and xlsReadWritePro 1.6.4 released

/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 PLEASE do read the posting guide http://www.R-project.org/posting

Re: [R] ReadWrite.xls problem

/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:ms_windows) Cheers, Hans-Peter PS. not that I mind to discuss things here, but as these are package

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

time formats added - yesterday() and tomorrow() give back dates instead of oledatetimes o misc. other bugfixes (writing RUnit tests exposes glitches, ahem...) --- 'technical' --- o move from Subversion to git o quite substancial code refactoring Cheers, Hans-Peter

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

)) When executing 'library(xlsReadWrite)' with the updated dll, the startup message will read '..version 1.5.2 (sha1: commit_info_missing)'. Changes have been pushed as http://github.com/swissr/xlsreadwrite/commit/17a8d1c076b622f842cae443ebff00b1bb254bbe. Cheers, Hans-Peter (author of xlsReadWrite

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

://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/mailman/listinfo/r-packages __ R-help@r-project.org

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, Hans-Peter

Re: [R] reading dates in Excel into R

.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] Need to read an Excel File

'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 https://stat.ethz.ch/mailman/listinfo/r-help

Re: [R] Image into Excel file from R

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(tmpWriteData, tmpWriteImage, wfile, fixed = TRUE) pics - c(pic1.jpeg, pic2

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-help@r

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

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 __ R-help@r-project.org mailing list https://stat.ethz.ch

Re: [R] Failed install of package xlsReadWrite

: 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 must work). Cheers, Hans-Peter

Re: [R] Failed install of package xlsReadWrite

-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 __ R-help@r-project.org

Re: [R] Excel-Export

, 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.org

Re: [R] Excel-Export

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/posting

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

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 list https://stat.ethz.ch/mailman

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

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 commented, minimal, self-contained

Re: [R] what happened to the xlsReadWrite package

. 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] Export data to Multiple Sheets in Excel via xlsReadWritePro

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

prefered as it's probably better not to use the r-help mailling list for questions about a non-free library). Btw, there will be a forum some time later. Cheers, Hans-Peter __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help

Re: [R] reading Excel file

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-project.org/posting

[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

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

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

2009/5/28 Dieter Menne dieter.me...@menne-biomed.de: 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

?  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/mailman/listinfo/r-help

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 posting guide http://www.R-project.org/posting-guide.html and provide

Re: [R] xlsReadWrite library

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-Peter

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-help

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

2009/3/9 Phil Spector spec...@stat.berkeley.edu: 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

Re: [R] xlsReadWrite package repository for Ubuntu

is, that it 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

, 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

- 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 https://stat.ethz.ch/mailman/listinfo/r-help PLEASE

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

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 'mxFinance': * checking

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.ch/mailman

[R] Small xlsReadWritePro update

://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.html and provide

[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]] __ R

Re: [R] reading Excel file

] - 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, Hans-Peter [[alternative HTML version deleted

Re: [R] reading Excel file

( 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-Peter [[alternative HTML version deleted

Re: [R] Importing an Excel spreadsheet

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 [[alternative HTML version deleted

Re: [R] Export csv data

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 read the posting guide http://www.R-project.org/posting-guide.html and provide commented

Re: [R] R data Export to Excel

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.org/posting-guide.html and provide

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 version deleted

[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

(::) -- 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.org/posting-guide.html and provide commented