Displaying 20 results from an estimated 10000 matches similar to: "Import xlsx file in Ubuntu 9.04"
2010 Jul 13
2
RODBC and Excel 2010 xlsx
Hi List, just to know if the issue is only a problem of mine or if it is a
general issue due to the new MS Office pack. I'm using R 2.11.1 32 bits in a
Windows 7 x64 with the MS office 2010 x64 installed. I can import .xls files
normally (the same way I did with my Excel 2007 32 bits). But the function
odbcConnectExcel2007 isn't able to import .xlsx files now that I have the
new version of
2012 Jan 09
2
RODBC vs gdata
Hi
one col in my Excel file contains many numbers. But on line 3000 and
some other lines are strings like "FG 1". "RODBS" seems to omit this
lines. "gdata" works, but is much slower.
Is this a bug of RODBC or do I apply it wrong?
Example with the same "file.xlsx"
library(RODBC); excel <- odbcConnectExcel2007("file.xlsx")
tab <-
2010 Jan 28
1
Problem associated with importing xlsx data file (Excel 2007)
Hi all,
I have imported xlsx file (Excel 2007) into R using the following scripts.
*library(RODBC)
*
*setwd(".......") *
*query <- odbcConnectExcel2007(xls.file = "GI 2010.xlsx", readOnly = TRUE)
dat <- sqlQuery(query, "select * from [sheet1$]", as.is = TRUE, na.strings =
"exp")*
*dat* contain one column consisting of intergers and characters
2011 Dec 04
3
RODBC connect to Excel (64-bit Windows 7)
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
2011 Jun 23
3
trying to import xls or xlsx files
library(xlsReadWrite)
mydata<-read.xls("file path", header=TRUE)
however if I change xls to csv it works just fine. Any ideas what I'm doing
wrong? I have have also using the package gdata with the exact same error.
Below is the error that pops up.
Error in findPerl(verbose = verbose) :
perl executable not found. Use perl= argument to specify the correct path.
Error in
2013 Jul 16
2
Importing data by odbcConnectExcel in 64 bit
I have probably an old question.
I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC
library does not work. Tried odbcConnectExcel2007 still does not work.
Any ideas.
Thanks
Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),sqtable
= "Sheet3",
+ na.strings = "NA", as.is = TRUE)
Error in
2008 Oct 28
2
odbcConnectExcel2007
Hi
sorry if this is really basic but I am just starting on R.
Can anyone point me at how to write R objects into Excel 2007 files. I
have seen how to set up a connection to a file through
odbcConnectExcel2007(xls.file, readOnly = FALSE, ...) but it doesn't say
anything on how to write data
Thanks
_____________________________________________________________________
The
2010 Jan 19
4
how to open excel 2007 (.xlsx) file in R
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.
2009 Jan 18
6
read a xls file
Hello,
i have a xls file. I will read it in r, what library-command i use for
this??
any ideas??
Thanks
Michele
[[alternative HTML version deleted]]
2014 Aug 15
2
leer ficheros excel en R en Ubuntu
Gracias Jorge por contestar tan rápido.
Con gdata hago eso del path, y directamente con el fichero, lo vi en una
web, y he intentado todas las opcioens que he visto.
En vez de install.packages('rJava', type = 'source')
he hecho install.packages('rJava')
Ahora probaré, y lo mismo con scan y readLines.
He visto en stackoverflow que mi problema puede ser actualizar java,
2014 Aug 15
2
leer ficheros excel en R en Ubuntu
offline? te lo envío a tu email, pq no creo que a toda la lista sea buena
idea.
El 15 de agosto de 2014, 9:47, Jorge I Velez <jorgeivanvelez en gmail.com>
escribió:
> De nada, Miguel. Es posible que me envies el archivo offline? --JIV
>
>
>
> 2014-08-15 17:45 GMT+10:00 Miguel Fiandor Gutiérrez <
> miguel.fiandor.gutierrez en gmail.com>:
>
> Gracias
2009 Apr 15
1
Writing .xlsx files
Dear all,
I have been looking for possibilities to read and write Excel 2007-files
in and from R.
The 'reading' part is ok through odbcConnectExcel2007 and sqlFetch(RODBC).
For 'writing' I thought of using sqlSave in the same package, but it
does not work (I think because this function starts from an existing
file). Is there a workaround for this, or are there other plausible
2014 Aug 15
5
leer ficheros excel en R en Ubuntu
Hola,
@javier, me gustaría no tener que hacer nada de forma manual, ni por fuera
de r, rstudio. Es decir, el típico comando de linux que me convierta de xls
a csv prefiero no usarlo. Me gustaría hacerlo todo desde R.
@jorge ->
Con RODBC me salta ->
Error: could not find function "odbcConnectExcel"
Lo que creo que es inevitable en Ubuntu
2009 Nov 18
3
Re ading multiple Excel 2007 files with a loop
I have several hundred Excel 2007 data files in a folder. I would like to
read every file in a single given folder using a loop.
I have searched the FAQ, the forum archives here, other or older R boards
and the R Import / Export documentation, and have asked some very
knowledgeable R users without learning of a solution. I hope someone here
can help.
I understand that the most common
2014 Aug 14
3
leer ficheros excel en R en Ubuntu
Hola,
Pensé que esto iba a ser trivial en R, pero me estoy encontrado muchos con
mi problema en internet, y que las soluciones ofrecidas no terminan de
funcionar.
Estoy intentando leer un fichero .xls en ubuntu con los siguientes paquetes
y nada:
require(RODBC)
conn = odbcConnectExcel("madrid.xls") # open a connection to the Excel file
sqlTables(conn)$TABLE_NAME # show all sheets
df =
2009 Apr 27
1
RODBC - XLSX files - dropping/clearing sheets
Hi!
I'm manipulating XLSX data using RODBC, however a limitation which appears
to be driver based is that you can't clear or drop sheets from the XLSX
files, as per the following example:
> library(RODBC)
> xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx,
*.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx;
ReadOnly=False")
>
2012 Jul 16
1
RODBC connection to locked Excel2010 files
Hi,
I am trying to connect to an Excel2010 file while another user is entering
data. (Obviously it would be better to set up a SQL database, but this is
not an option at this point.). Typically we are not working on the same
sheets. However, if possible I like to read the most current excel file
into R.
RODBC works great as long as the other user has not open the file. I tried:
channel <-
2013 Apr 02
1
gdata selectively not working
I can use gdata to successfully read in the example Excel file, but not any
other excel files. Why might this be the case? It seems that the problem
has something to do with opening the database but no indication as to what
the problem is. So i'm at a loss of how to fix it.
> library(gdata)
gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED.
gdata: read.xls support
2015 Mar 26
2
Conectividad con Excel
Hola amigos, buenos días
Esto sigue avanzando. Estoy ahora tratando de establecer la conectividad de
R con Excel y he seguido dos viídeos en YouTube de una profesora llamada
Bebilda que se explica muy bien.
Con ambos tengo el mismo problema así que planteo uno de ellos, éste es:
https://youtu.be/_pSJQO_9I4k?list=PL7DA3FDA21A1A6310
Pero os lo explico brevemente:
Cargo el paquete RODBC >
2012 May 29
1
RODBC, Excel, and data truncation when writing
Hi,
I am hoping to use the RODBC package to write a dataframe to an Excel .xlsx
file. The dataframe contains at least one field with character elements
that exceed 255 bytes, which appears to be the cell width limit in Excel.
Below is example code and the warning message received:
library(RODBC)
d <-