OpenOffice Calc ODBC equivalent
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