similar to: Exporting data to .xlsx file

Hello All, I am very new to the R and i want to know how to connect to the teradata in R and import data from there. Currently I am using SAS to import data and i use the following syntax to connect to teradata. *Proc Sql; connect to odbc (dsn=teradata username = '**********' password = '*********'); create table dorm.bkg_tables as select * from connection to odbc* Could you

i am unable to open a file which is saved as .xlsx format in R . The file contains approximately 1,50,000 rows. So I m not able to save it as csv file.Please suggest ways to open this file -- View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017273.html Sent from the R help mailing list archive at Nabble.com.

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

Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we get the following error, when trying to write the data frames to the excel sheets: Error in ls(envir = envir, all.names = private) : invalid 'envir' argument We figured out that

Dear all, How can I read .xlsx files in R Regards Nico [[alternative HTML version deleted]]

Hello R users, I want to export to an xls or .csv some predictions I produced with the auto.arima and forecast functions. A detail of all my work is presented below. I loaded a package called dataframes2xls and tried to use the function write.xls without any success. Can anybody help me figure this out? How could I get R to export the output to an xls file? Any help will be greatly

2009/8/30 Uwe Ligges <ligges at statistik.tu-dortmund.de>: [snip] > Guido van Steen wrote: [snip] >> Something that interests me too: What about R's policy with respect to >> including binary files? I saw that developers should include a file [snip] > Please do not include binary files and carefully watch for licenses of those > files (e.g. if GPL'ed, you need to

Hello, I am facing a problem in drawing heat map using R. I have a 70X3 matrix and I want to draw a heat map with 1 coloumn on X axis another on Y axis and want to show the value of 3rd coloumn using heat colours. Could you please help me with this . Thank you . Regards, Sumit [[alternative HTML version deleted]]

Hello, I am having problem with binning the data. I have a 50X3 matrix and I binned the data for all the 3 columns. Using table command I got the total no. of elements in a particular bin. Could you please tell me how to see that what all elements are there in a particular bin and then create a different matrix for each bin? Thanks. Regards, Sumit [[alternative HTML version deleted]]

Hi. I have had this URL passed to me in order to obtain the necessary driver to connect my R application to our Teradata warehouse, however, the URL does not seem to exist anymore, my internet explorer browser fails to connect for some reason. http://downloads.teradata.com/download/applications/teradata-r/1.0 Is there an alternative site or location for obtaining the necessary driver? Thanks

Hello R-users, Checking the archives, I recently came across this topic: "export tables to Excel files" (http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679), and the following interesting references have been proposed: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows

Hi, I try to use write.xls from dataframes2xls inside a function. The write.xls work normally in console, but inside a function it dont find the object. Look this example: > library(dataframes2xls) > test <- function(x){ + a <- data.frame(A=c(1,2),B=c(10,11)) + write.xls(a,file="a.xls") + } > test() Erro em get(s[i]) : objeto 'a' não encontrado Why the

Hello, Does anyone know a way to connect from R on Linux box to TeraData server? I can use ODBC connection on Windows box, but with amount of data I need (and prefer) to use large Linux box. Thanks, Vadim

Hi, Can anyone tell me how to find number of cluster for a data set. I have a data set in following format Group var1 var2 var3 A 1 2 3 A 1 2 3 A 1 2 3 B....... B....... C C.... C C..... I want to know for each group what is the optimum number of cluster. like A- 2 B-3

Hola. En un cierto directorio tengo archivos excel y de otros tipos. Cada uno de ellos corresponde a una encuesta a una empresa X. Me gustaria importar los datos de ciertas celdas de ciertas hojas de todos los archivos excel en una sola pasada. ¿Hay alguna forma de hacerlo? Yo se que la variable Z está siempre en la celda X de la hora tanto. Me gustaría ingresarlo todo en una matriz en que

Hello! I've generated multiple data frames that I wish to export to excel using the function write.table. When I do so all the data is merged into a single column in excel. I Would like the columns of my data frame in separate columns in excel as well but it doesn't work. I tried to download the package WriteXLS and installed Perl on my computer just like it was recommended. I also tried

Hi all, I am trying to connect Teradata with R using Windows. Due I need to install any specific package or what? I am bit clue-less. Can someone help. Regards, Saj _________________________________________________________________ [[alternative HTML version deleted]]

Hello, All: The "writeFindFn2xls" function in the "sos" package tries to write an Excel file with 3 sheets ('PackageSum2', 'findFn', 'call'). Unfortunately, it is often unable to do this because of configuration problems that are not easy to fix. I've found 3 contributed packages that provide facilities to write Excel files with

Hello I am trying to import the attached file Curva LIBOR to R. I am trying to use the following commands and obtaining the following errors > res <- read.xlsx("C:\\Users\\FELIPE PARRA\\Documents\\Quantil\\Federacion\\Curva LIBOR.xlsx", 4) Error en .jcall(rowCells[[ic]], "I", "getColumnIndex") : RcallMethod: invalid object parameter > res <-

Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) > channel <- odbcConnectExcel("results.xlsx") Error in odbcConnectExcel("results.xlsx") : odbcConnectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel