On Sep 6, 2010, at 12:25 PM, Kenneth Roy Cabrera Torres wrote:
Thank you Ivan for you answer:
El lun, 06-09-2010 a las 18:11 +0200, Ivan Calandra escribió:
Hi,
Are you sure you used the correct syntax and object names? It might
just
be because of that...(reading the error messages)
Im sure, because it works with write.csv or write.table.
Sure? You are making the incorrect assumption that those write
functions have the same syntax. At least for WriteXLS that assumption
is false. The help page clearly states that the objects need to be
quoted rather than being referred to by their "naked" names. The error
you are getting with your "second option" suggests to me that you
offered an unquoted name of an object.
You can offer a vector of quoted names of dataframes to WriteXLS and
each named dataframe will be converted to a worksheet within the
workbook.
--
David.
There is another function, xlsReadWrite::write.xls(), that I like a
lot:
it is really easy to use and does not require Perl or Python.
Unfortunately it works on windows, and I am in a non windows platform
(ubuntu).
Thank you for you advice and help.
Kenneth
HTH,
Ivan
Le 9/6/2010 18:03, Kenneth Roy Cabrera Torres a crit :
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
______________________________________________
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.
______________________________________________
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.
______________________________________________
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.
David Winsemius, MD
West Hartford, CT
______________________________________________
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.
