news - swissr - ch eese + r and om

Future plans (xlReadWrite[Pro])

posted Nov 9, 2011 1:06 PM by Hans-Peter Suter [ updated Nov 10, 2011 1:05 AM ]

If everything works out as planed then two new packages 'xlReadWrite[Pro]' should be released in December 2011. They will be based on a new (currently in beta) version of Flexcel and support:

    - xlsx file format (in addition to .xls/BIFF8 format)
    - support for 64 bit Windows (in addition to 32 bit)
    - support for 32 bit Mac OSX

Some time later (depending on time/motivation/pro-sales) the API is planned to be improved considerably. Towards the end of 2012 (depends on Embarcadero getting a suitable Delphi XE3 version out of the door) we intend to finally support 64 bit Macs and 32/64 bit Linux(en).

xlsReadWrite[Pro] tested with R2.14.0

posted Nov 9, 2011 1:00 PM by Hans-Peter Suter

I've tested the R2.12.x versions xlsReadWrite 1.5.4 and xlsReadWritePro 1.6.4 with the new R2.14.0 and they run well.

There would be minor updates to both packages but I currently do have problems compiling the C-based placeholder dll (for CRAN) with R2.14.0. It works fine in R2.12 and R2.13 but no longer in R2.14. It's probably due to the fact that I use a cygwin based toolchain instead of the R-specific MinGW etc. Some error messages also surfaced in other projects and - considering the minor package updates - I think I am lazy now and wait for the eventual R2.14.1 update which may fix things. I'll also will try to get rid of the placeholder dll altogether and avoid these troubles.

dev.swissr (forum/tracker) now https

posted Jul 6, 2011 9:31 AM by Hans-Peter Suter

Got a proper ssl certificate and url changed from http://dev.swissr.org to https://dev.swissr.org. The old address will be redirected.

R2.13.0 version planned for 23.4.

posted Apr 17, 2011 3:06 AM by Hans-Peter Suter

xlsReadWrite[Pro] versions for R2.13.0 are planned to be released until 23.4.2011.

dev.swissr.org temp down

posted Mar 28, 2011 2:31 AM by Hans-Peter Suter [ updated Apr 2, 2011 5:42 AM ]

Due to a failed conversion from VMware to VirtualBox, dev.swissr.org is temporary down. As it is not a very important site, it may take a week or so until we find/take time to fix it.

[Edit: we also upgrade the (physical) server and dev.swissr will be down a lil longer]

Free license :-(

posted Mar 26, 2011 10:38 AM by Hans-Peter Suter

http://www.livestream.com/libya17feb/video?clipId=pla_9745ec21-c64d-440f-abe7-a412e7db456d&utm_source=lslibrary&utm_medium=ui-thumb

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(
            User = "R.I.P. Mohammed Nabbous",
            Company = "Let's hope that Libya will become free",
            Product = "xlsReadWritePro",
            Date = "2011-03-19",
            LicenseType = "SingleUser",
            Count = 1,
            Key = "76991137f5f554a288e8cee343a24722",
            WhereToStore = "ProgramFolder" ) )

xlsReadWrite 1.5.4 and xlsReadWritePro 1.6.4 released

posted Jan 25, 2011 5:59 AM by Hans-Peter Suter

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 message) but have been converted to a wrong value
WHERE:

free/pro: reading an Excel sheet and explicitely defining: 'colClasses = "integer"' or 'type = "integer". It's assumed that only very few people do this.
pro: when (auto) detecting a data.frame column type for numeric values the type become an 'integer' in some situations. This probably affects more people than above

SOLUTION:

an error will be raised for too large/small values (same as in read.table)
numeric data.frame column types default to 'double' (as in the free version)

adapt RUnit tests to new behaviour
some small cosmetic changes

Credits to Gyorgy Ottucsak who found the problem in xlsReadWritePro and send us a report (incl. testfile). Thanks a lot!

xlsReadWritePro 1.6.3 (93a6d7) released

posted Nov 29, 2010 5:42 AM by Hans-Peter Suter [ updated Nov 29, 2010 5:56 AM ]

[2010-11-21]
bugfixes/changes:

- fix for startup message scrambling (use LF instead of CRLF - reported to Rdevel)
- (internal) update makefile: also support R2.12/2.9, much simplify targets,
set/modify Windows System Path from within the makefile

Please checkout the 1.6.1 release notes further below if you do not yet use that version. There had been some important changes.

xlsReadWrite 1.5.3 (0b78c1) released

posted Nov 29, 2010 5:38 AM by Hans-Peter Suter

[2010-11-21]
bugfixes/changes:

- *important*: fix AV when reading large data (issue #110: in a subroutine a
    pointer (pSExp) had been 'riUnprotect'ed (Rf_unprotect) too early, the total
    protect/unprotect count was correct (of course) but when 'anyDuplicated' got
    called in the subroutine, the control flow switched to R and R then had the
    possibility to free 'my' pointer. Not good).
    Thanks to the (anonymous) user which submitted the nice bug report!

- NaN values will be written as 'NaN' and behaviour (e.g. coercion) better
    accounts R (see read.xls.Rd, write.xls.Rd and unitTests/runitNaNaN.R).

- 'dateTimeAs' argument in read.xls has been renamed to 'dateTime'. When using
    the default (which should be fine in most cases) this change won't affect you.

- fix startup message scrambling in R2.12.0 (LF instead of CRLF - reported to Rdevel)
- simplified file (unitTests/execManually.R) to run RUnit tests
- misc. small/cosmetic changes (see github commits)
- (internal) update makefile: support R2.12, much simplify targets, set/modify
    Windows System Path from within the makefile

dl.dropbox down - shlib problem

posted Nov 18, 2010 7:36 AM by Hans-Peter Suter

Seems that 'http://dl.dropbox.com/...' is down atm and - as our resources are hosted there - we are affected by this. Mirrors, e.g. 'dl4', 'dl5' instead of 'dl', seem to work.

While testing the makefile for the new 1.5.3 version we errouneously replaced the shlib for 1.5.2 and when downloading the shlib from the xlsReadWrite CRAN version an error with 'Incorrect number of arguments' has been displayed. Correct shlib restored again. Thanks to Suray Menon for notifying us.

	Search this site