OpenOffice Calc ODBC equivalent

[Kenneth Roy Cabrera Torres]

Hi R users:

I am using RODBC to create some new ".xls" files each with
several sheets (about 100) with sqlSave() from a data.frame
inside R  without any problem, but on windows XP platform.

I would like to know if it is posible to make a similar
solution on linux with openoffice?

RODBC work only (for the moment) with ".xls" on windows,
via the ODBC driver.

Is it posible to make the same thing on openoffice?
I mean, an ".odt" file with several sheets each, generated from
a data.frame in R?

Thank you for your help.

Kenneth

______________________________________________
[hidden email] 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.

[Marc Schwartz-3]

On Nov 2, 2009, at 10:10 PM, Kenneth Roy Cabrera Torres wrote:

> Hi R users:
>
> I am using RODBC to create some new ".xls" files each with
> several sheets (about 100) with sqlSave() from a data.frame
> inside R  without any problem, but on windows XP platform.
>
> I would like to know if it is posible to make a similar
> solution on linux with openoffice?
>
> RODBC work only (for the moment) with ".xls" on windows,
> via the ODBC driver.
>
> Is it posible to make the same thing on openoffice?
> I mean, an ".odt" file with several sheets each, generated from
> a data.frame in R?
>
> Thank you for your help.
>
> Kenneth

See this post from late 2007:

   http://tolstoy.newcastle.edu.au/R/e3/help/07/12/6478.html

As far as I know, nothing has changed vis-a-via ODBC connectivity TO  
OpenOffice files. You can use ODBC FROM OpenOffice to connect to  
external data sources.

A search of CRAN does not reveal any packages/functions to would  
appear to provide a facility to directly write data frames to a Calc  
file. However, you can always write to a XLS file, open it in Calc and  
re-save it as a native Calc file. Of course, anyone with Calc can open  
an XLS file, so you are not losing much in terms of portability by  
saving to an XLS file and distributing that. You also make it easier  
for folks who may be using other 'office' applications that do not  
have import filters for OO.org file formats.

HTH,

Marc Schwartz

______________________________________________
[hidden email] 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.

[Kenneth Roy Cabrera Torres]

Thank you Dr. Schwartz:

I did not read this post before,
> See this post from late 2007:
>
>    http://tolstoy.newcastle.edu.au/R/e3/help/07/12/6478.html
>
> As far as I know, nothing has changed vis-a-via ODBC connectivity TO  
> OpenOffice files. You can use ODBC FROM OpenOffice to connect to  
> external data sources.
Yes, I found that too.
> A search of CRAN does not reveal any packages/functions to would  
> appear to provide a facility to directly write data frames to a Calc  
> file. However, you can always write to a XLS file,
Yes, I am going to do that.
> open it in Calc and  
> re-save it as a native Calc file. Of course, anyone with Calc can open  
> an XLS file, so you are not losing much in terms of portability by  
> saving to an XLS file and distributing that. You also make it easier  
> for folks who may be using other 'office' applications that do not  
> have import filters for OO.org file formats.

I was looking for xlsReadWrite package, but it seems that
it is removed form the CRAN repository, then I found your WriteXLS
package, which I am going to use.

I see that dataframes2xls is other package that can helps me too.

Thank you for your help.

______________________________________________
[hidden email] 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.