[R] WriteXLS problem

Kenneth Roy Cabrera Torres krcabrer at une.net.co
Mon Sep 6 18:03:31 CEST 2010


Hi R users:

I don't know if you have had the following problem trying to
export to an "xls" format file in a non windows platform.

I try to use the following packages:
1. dataframes2xls (version 0.4.4) (with phyton 2.7 and 3.1)
2. WriteXLS (version 1.9.0) (with perl and testPerl working)

Even "xlsx" package that take too long and do not finish.

The data frame I try to export has 269363 row and 116 columns.
In the first one (dataframe2xls) I get this message:

Traceback (most recent call last):
 File
"C:/PROGRA~2/R/R-211~1.1PA/library/dataframes2xls/python/csv2xls.py",
line 18, in <module>
import pyexcelerator
File
"C:\PROGRA~2\R\R-211~1.1PA\library\dataframes2xls\python\pyexcelerator
\__init__.py",
line 12, in <module>     from Workbook import Workbook
File
"C:\PROGRA~2\R\R-211~1.1PA\library\dataframes2xls\python\pyexcelerator
\Workbook.py",
line 526     boundsheets_len += len(BIFFRecords.BoundSheetRecord(0x00L,
sheet.hidden, sheet.name).get())
                                                            ^
SyntaxError: invalid syntax

Using the second option I get this message:

Error en get(as.character(i)),envr=envir) :
  objeto '00000000089' no encontrado

Object '00000000089' not found.

Im using this R platform:
sessionInfo()
R version 2.11.1 Patched (2010-08-30 r52848)
Platform: x86_64-unknown-linux-gnu (64-bit)

Locale:
LC_CTYPE=es_CO.UTF-8 

Is the only solution to export to ".csv" and then
to ".xls" format with other program like openoffice?

Thank you for your help and advice.

Kenneth



More information about the R-help mailing list