Since some years I have the following domains which I don't need any longer
(and in fact never used despite some plans)
- developr.org
- editr.org
- helpr.org
It makes no sense to hoard domains and I plan to give them away for a 'good
cause'. I'd like to have a small fee for the costs but t
Hello,
I see that quite some packages nowadays use testthat and that RUnit doesn't
have recent updates. On the other hand Rccp, fTrading and others (still)
test with RUnit.
My old code uses RUnit and I would prefer to keep it that way unless there
is an important reason to switch to testthat. If
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
> 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/lis
>> Also - is there a better way for the future? I know some people use IDE's
>> but is that for serious programming or for building a small function and
>> tweaking it?
What about a version control system to (locally) save the different
stages of your script files?
(I use git but Subversion (SVN)
2010/2/11 :
> Does anyone have a work-around for a failed installation of this package?
>> library(xlsReadWrite)
...
> xls.getshlib()
>
> However, the xls.getshlib() command fails with this error:
(For the record) It probably was a corporate firewall problem.
Apart from info on www.swissr.org (t
> Hi, all. I too got this error, and when I went to register the correct DLL
> (thinking the one downloaded but not installed might have been the
> development version) I got an error that the registration had failed.
>
> What I typed:
>
> C:\Program Files\R\R-2.10.0\library\xlsReadWrite\libs>regsv
> I’m trying to export a file from R to excel using the xlsReadWritePro
> function and I keep getting the error below.
POSIXt is not currently supported (neither in data.frames nor vectors)
and must be converted to other types (see ?write.xls). I almost never
use POSIXlt/ct myself but it would pr
> what happened to the xlsReadWrite package?
[snip]
> Are there any plans for it be available again?
Yes. (I do have a halfway finished version but then had much work on
my regular job, my 'free-programming-time' got eaten by a e-texteditor
plugin (http://github.com/swissr/rmate.tmbundle/tree/mast
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-Peter
(emacs newb here)
After having made some changes in an \items paragraph of \arguments
the lines are no longer nicely wrapped. I was looking for a command to
reindent/rewrap/reformat the whole \items paragraph but couldn't find
anything.
The only way, I found, was to go to the end of the first lin
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-projec
> I am aware of the various packages (xlsReadWrite, RODBC) to get data
> frames into R, but I would like to copy images too.
The xlsReadWritePro version could do it (see code below). It's a
shareware package, but if people need/ask for a gratis license I send
it (please download and check ?xls.lic
> Marc -
> I thank you for the links and ideas. Thanks to your advice I will look more
> into SVN in the future, although it sounds on the surface to require some
> learning curve, so It could take me some time to start using it.
If you consider investing time to learn a version control system, I
Jens,
2009/11/23 koj :
> library(xlsReadWrite)
> Everything is fine, but the format of the export is not the best. For
> example, I every time have to adjust the column width. Furthermore there is
> no possibility to highlight some cell or make them colourful.
Auto-col is supported by the underly
2009/11/24 Kevin Wright :
> If had done a little searching before posting, you surely would have found
> this link
> https://stat.ethz.ch/pipermail/r-help/2008-July/169149.html
> which describes how to create .xls files that are customized any way that
> you desire.
Manually convert to html, then
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
__
R-help@r
>> I am a little lonely as R users in my group. So, I would like to know which
>> editor is the most used in the R community.
I think Emacs+ESS is most used and the most capable (if you are
willing to invest the time to learn it properly).
Personally I mostly use TextMate with the R bundle (or R
2009/6/2 Mark Na :
> library(xlsReadWrite)
> data <- read.xls(data,colClasses=c("character"))
>
> and this results in all of the empty (blank) cells in the imported
> Excel file also being empty (blank) in the resulting dataframe.
The pro version has an 'naStrings' argument. But this is something
I have uploaded RMate to Github. From the readme:
RMate is a [TextMate](http://macromates.com/) bundle for
[R](http://www.r-project.org/about.html). It is based on the [R/R
Console/Rdaemon](http://svn.textmate.org/trunk/Bundles) bundles and is
focused on:
- easy to use, clear interface/menu
- sup
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@
> I was using older version of R (installed early). I install new version of R
> (R.2.9.0) but i could not find package "xlsReadWrite" to read Excel file.
As others have pointed out (thanks) you can find it here:
http://treetron.googlepages.com/.
It runs fine in 2.9.0.
> Is there any alternative
2009/3/19 Pascal Candolfi :
> Any idea why this library was removed and where could I find it for Windows
> (only Unix in the Archive) ?
As indicated it was for for the binary (non FOSS) component.
Yesterday I checked the existing packages (xlsReadWrite(Pro) on
http://treetron.googlepages.com) if
>> 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
an
> want an analysis. The best case were a surface of e.g. 8 Buttons, each click
> leads to start a specific R file. My outputs are JPEG or CSV, so I don`t
> need the output inside of R. Could anyone can give me some recommendations,
> what could be a solution (e. g. Java)? Is such a solution possibl
Argh, just now I saw a scrambled start-up message when running
xlsReadWrite1.5.2 in R2.12.0 (32-bit) on a Win7 64-bit platform. If
you have this situation and use xlsReadWrite 1.5.2 (probably all
earlier versions also) you can download a quick fix, see below. I
don't know if this also affects Vista
The xlsReadWrite[Pro] packages allow to natively read/write Excel files (.xls)
on the Win 32-bit platform.
About a week ago new package versions have been released:
* xlsReadWrite 1.5.3 is available at CRAN (for R2.11/2.12) and from
www.swissr.org/download (binary builds for R2.9 - R2.12)
* xlsRea
Toby, haruo0409,
2010/12/8 tkdweber :
> This is my Error-Message in its German original:
> Fehler in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, :
> Falsche Anzahl von Argumenten (11), erwarte 10 für ReadXls
There was a wrong DLL for a short while in the old 1.5.2 version (I
f
The xlsReadWrite[Pro] package allows to natively read and write Excel
files (.xls) on the Win 32-bit platform.
Changes:
o fix bug with integer conversion (http://dev.swissr.org/issues/113)
PROBLEM: values outside the integer range (i.e. 12345678901) didn't give an NA
(and a warning
2010/7/30 Dimitri Liakhovitski :
> I've wasted a lot of time trying to read in dates from Excel. Even
> importing .csv files has not guarantees and often produces garbage
> instead of dates.
> What I found works best is saving the Excel data base as a
> tab-delimited file .txt (after having formatt
2010/7/30 rajibshibly :
>
> I am trying to read an Excel file using the following:
> a<-read.xls("mydata.xls", sheet=1)
[snip]
> Error in findPerl(verbose = verbose) :
> perl executable not found. Use perl= argument to specify the correct path.
> Error in file.exists(tfn) : invalid 'file' argument
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
__
Natively read and write Excel (.xls) files. Supports Windows 32-bit only (atm).
A new version has been released:
-- changes --
o read.xls
- new arguments 'checkNames'
- recognize NA values according to a new 'naStrings' argument
- recognize NaN values
- recognize 'true', 'false' (not cas
Some years ago I travelled through Libya and it's with much emotion
that I follow the news.
The license below is dedicated to Mohammed Nabbous and will let you
run xlsReadWritePro for free (Windows, R 32-bit):
library( "xlsReadWritePro" )
xls.lic( action = "register",
miscData = list(
Jim,
2011/10/15 jim holtman :
> You might also want to consider the XLConnect package. I have had
> better luck reading/writing Excel files than with xlsReadWrite.
XLConnect looks good but - as the xlsReadWrite author and planing to
release a xlsx/64 bit successor - I'd be interested to learn wh
2011/11/15 jim holtman :
> Part of my problem has to do with getting through the corporate
> firewall to access the other program I have to download to use it. I
> just tried today and this is what I got:
>
>> xls.getshlib()
> Loading required package: tools
> --- xls.getshlib running... ---
> -
On an (Intel Leopard) Mac I try to build a package (mxFinance) which
depends on another package (mxGraphics). The dependendy is 1) a
'Depends:' in DESCRIPTION and 2) an import in NAMESPACE.
- The build fails if the dependent package (mxGraphics) is not
installed in the R.framework
Do I need to ha
> I read data from *.xls file and i did some caliculations on that data and
> now i have to create a column in the same .xls file
> i tried it with *write.xls() *but the thing is it deleted all the columns
> previously presented in that file and it created a column and inserted data
> can any one
> Excel stores times of the day as fractions of a day so I wrote a function to
> convert the fraction to a number of seconds, extract the hours, minutes and
> seconds and output it in ISO standard format (%H:%M:%S).
What about the 'colClasses' or 'dateTimeAs' argument in 'read.xls'
which gives bac
2009/3/2 Prof Brian Ripley :
> The CRAN Windows ones. It is a windows-only package, see
> http://cran.r-project.org/web/packages/xlsReadWrite/index.html
> (incidentally to you: it seems no longer maintained and does not build under
> R-devel on Windows, see
> http://cran.r-project.org/bin/windows/
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 the
2009/3/15 David Scott :
> On Sat, 14 Mar 2009, Mathew, Abraham T wrote:
> [snip]
> Just checking on CRAN xlsReadWrite is not currently available. There is an
> archived version available however.
Thanks for mentioning.
The reason is that CRAN is strict(er) now with binary submissions
(which is no
42 matches
Mail list logo
