search for: treetron

...) ? Append data (several possibilities) ? Work with multiple files at the same time ? Inside information of an Excelfile ? oledatetime classes (Beta) with many additional functions ? the pro version is formally supported. Please have a look for yourself. I have put the documentation online: http://treetron.googlepages.com/00Index.html, http://treetron.googlepages.com/read.xls.html, http://treetron.googlepages.com/xls.sheet.html, and more... You can download a free trial (of 30 days) here: http://treetron.googlepages.com/ or direct: http://treetron.googlepages.com/xlsReadWritePro_1.0.1.zip and http:/...

...atures are + possibility to read/write dates/times + rownames for matrices + checknames (colnames) + better factor support + 'stringsAsFactors' and 'rownames' argument. I also added 4 general purpose datetime functions to convert excel dates from/to strings. Download: - zip: http://treetron.googlepages.com/BETAxlsReadWrite_1.2.1.zip - source: http://treetron.googlepages.com/BETAxlsReadWrite_1.2.1.tar.gz - testdata: http://treetron.googlepages.com/BETAxlsReadWrite_TestData_1.2.1.zip Some of you may be aware that this package is made with Delphi and contains Object Pascal code. It does...

...andling (select/ins/copy/del/...) ? data area subsets (rows/cols/from/to/area) ? use (named) ranges and pick individual cells ? insert images, hyperlinks, work with formulas ? oledatetime type and many helper functions ? get information about an Excelfile. Browse the (shortened) help files: http://treetron.googlepages.com/00Index.html Download a brochure: http://treetron.googlepages.com/xlsReadWrite_Pro_Datasheet.pdf Download the package: http://treetron.googlepages.com/xlsReadWritePro_1.2.1.zip Download Test-/Demoscripts: http://treetron.googlepages.com/xlsReadWritePro_TestData_1.2.1.zip The pro v...

A naive question: what happened to the xlsReadWrite package? http://cran.r-project.org/web/packages/xlsReadWrite/ It says that it was removed from the CRAN repository. Are there any plans for it be available again? Thanks, Andrew [[alternative HTML version deleted]]

...from = 1, rowNames = NA ) - dateTimeToStr( odate, format = "" ) - strToDateTime( sdate ) - dateTimeToIsoStr( odate, isoformat = "YYYY-MM-DD hh:mm:ss" ) - isoStrToDateTime( sdate ) o Download - CRAN (v1.3.2; from within RGui) or - http://treetron.googlepages.com/ (v1.3.3) - direct link to package: http://treetron.googlepages.com/xlsReadWrite_1.3.3.zip - direct link to test-/demoscripts: http://treetron.googlepages.com/xlsReadWrite_TestData_1.3.3.zip - the testscript is used for our internal "unittests". It will show you...

Dear all, I often use dates and times in analyses. I just can't figure out how to format my date or time column in R. So, apparently R sees the date as something other than date (character). Let's say I am opening a CSV file, one of the columns of which is a date or time. How do I specify that when opening the file? Thanks for the help, Jim --

Dear list Some time ago I told about the translation of the LGPL'ed R headerfiles to Delphi. I am happy that most of them are translated now and the code, demo and description is online (licensed under GPLv2): http://treetron.googlepages.com I just annonced a native Excel reader/writer in R-help which is based on this headerfile translation. Probably most of you won't care (using Linux) but it still would be nice if someone knowledgeable could have a look into it. It is my first package... and if there should be t...

Dear all, I installed xlsReadWrite package under Windows 7, and got error when trying to run xls.getshlib(). Please, see the errors below: > require(xlsReadWrite) Loading required package: xlsReadWrite xlsReadWrite version (cran shlib) Copyright (C) 2010 Hans-Peter Suter, Treetron, Switzerland. !! Your installation contains the cran placeholder shlib (dll/so). Please get the regular shlib (420 KB) by executing the following command: xls.getshlib() Info, forum, issue tracker and manual download at http://www.swissr.org. BACKGROUND: Our own xlsReadWrite code is free, bu...

Does anyone have a work-around for a failed installation of this package? > library(xlsReadWrite) xlsReadWrite version (cran shlib) Copyright (C) 2010 Hans-Peter Suter, Treetron, Switzerland. !! Your installation contains the cran placeholder shlib (dll/so). Please get the regular shlib (420 KB) by executing the following command: xls.getshlib() However, the xls.getshlib() command fails with this error: > xls.getshlib() Loading required package: tools --- xls.getshl...

Dear all,   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. Is there any alternatives to read Excel file ? I hope it should be. I need help although it is minor querry. Thanks in advance.   Sincerely, Ram Kumar Basnet Wageningen University, The Netherlands   [[alternative HTML

...tive Excel reader/writer. It's wrapped up in two packages: either "xlsReadWrite" (open source) or the slightly beefed-up "xlsReadWritePro" (shareware). Working with Excel data is now as easy as writing read.xls and write.xls. Some more details: - Infos and download: http://treetron.googlepages.com - for detailed documentation pls. download and see: help files, DESCRIPTION and README. - I set up a newsgroup for technical questions and feedback: http://groups.google.ch/group/supportR - while it could be ported to other platforms, currently it is WINDOWS only (see technical bel...

...it's windows only (at least for the moment)). Best regards, Hans-Peter *After R2.3; also I need to do larger tests and think about some kind of testframework **I already sent them to the few persons I know who might be interested - - - | Hans-Peter Suter, Dipl. Natw. ETH / SW-Entwickler | Treetron Umweltinformatik, Zuerich Tel +41(1)242 22 55 | mailto: <firstname>.<name>@treetronPUNKTch | or: gchappi at gmail.com -------------- next part -------------- DEMOS ======================================================== Available: - Convolve | - RegisteredConvolve | - Initialize | - Gl...

...a Mac version. - While I started to port it, I didn't succeed in the 2 days I have given me. - If there are any "pascal-lovers" out there I would be very interested to get in touch, it would be more fun to do it together than to try all by myself. -- MORE INFOS / CONTACT: At http://treetron.googlepages.com/ you will find an additional file with testdata/-scripts and more infos (contact, bugs (currently nothing), suggestions and todos). I hope you enjoy using this package (I certainly do...) and am looking forward to any feedback you might have. Best regards, Hans-Peter [[alternati...

An updated version 1.1.1 of xlsReadWrite has been submitted to cran. Currently the cran version is still 1.0, but you can download the updated version already here: http://treetron.googlepages.com. xlsReadWrite is a package which allows you to natively read and write Excelfiles (windows only). Changes from xlsReadWrite 1.0.0 to 1.1.1 -> added colClasses argument ("rowname", "integer", "double", "factor", "character" a...

Any idea why this library was removed and where could I find it for Windows (only Unix in the Archive) ? Much thanks in advance. Pascal [[alternative HTML version deleted]]

Hi Every one, I have a problem with Reading Excel file into R 2.9.0 version. In older versions it is working with "xlsReadWrite" package. But in 2.9.0 version there is no package like that. so help me out in this aspect. Thanks in Advance. -- View this message in context: http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html Sent from the R help

Hi all, There have been quite a few threads in the recent months pertaining to the ability to directly write native Excel (.xls) files from R. For example, exporting R matrices and/or data frames to an Excel file, with perhaps the ability to create multiple tabs (worksheets) within a single file, with one tab/sheet per R object. There exists the xlsReadWrite package on CRAN by Hans-Peter Suter,

R I am taking an excel dataset and reading it into R using read.table. (actually I am dumping the data into a .txt file first and then reading data in to R). Here is snippet: > head(data); Date Price Open.Int. Comm.Long Comm.Short net.comm 1 15-Jan-86 673.25 175645 65910 28425 37485 2 31-Jan-86 677.00 167350 54060 27120 26940 3 14-Feb-86 680.25

Hello All, We would like to call quantile() function from the R-package STATS in a Delphi program. If this is possible, could anyone provide us with an example? Thanks in advance. --Anna ----------------------------------------- Anna Belova Abt Associates Inc. 4800 Montgomery Ln, St 600 Bethesda, MD-20814 phone: 301-347-5304 fax: 301-652-7530 http://www.abtassociates.com/environment