Displaying 20 results from an estimated 50000 matches similar to: "Import/Export excel files to/from R, without changing the file type"
2012 Sep 04
2
How can I export a big data.frame to excel 2010 - file.xlsx?
Hi,
I need some help to export a data frame with 83 rows and 1411 colums. I have
used the package RODBC until now. But now, I have 1411 colums that I can't
send to the old excel. If anybody knows a package to convert my data frame
in xlsx tell me!
Thanks for help in advance!
Pamela Botrel
--
View this message in context:
2012 Nov 16
2
Import excel file
Hello,
Is it possible to import an Excel 2000 file (32-bit version) into R 2.15.1 64-bit version?
Thanks.
Best regards,
Cyril Hervy
[[alternative HTML version deleted]]
2010 Jul 30
4
Need to read an Excel File
I am trying to read an Excel file using the following:
a<-read.xls("mydata.xls", sheet=1)
The file mydata.xls is stored in the working directory. However I am getting
the following error. Can anyone help.
Error in findPerl(verbose = verbose) :
perl executable not found. Use perl= argument to specify the correct path.
Error in file.exists(tfn) : invalid 'file' argument
--
2012 Nov 06
2
Append Data to an Excel File through each Iteration of a For Loop
Hi,
I would like to find a way to append data to an excel file through each
iteration of a for loop. Is there a way to use a command such as
write.table and append each iteration to a different sheet?
Thanks
[[alternative HTML version deleted]]
2013 Jul 22
1
problem loading large xlsx file into r
Hi,
I am facing trouble when trying to read large xlsx file into R. please find the code and error below. The file I was trying to read has 36,500 rows X 188 col, ~ 37 MB size.
> options( java.parameters = "-Xmx4g" )
> library(xlsx)
Loading required package: xlsxjars
Loading required package: rJava
> cftc =
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 >
2011 Sep 15
2
Reading Parts of Excel Files (within a sheet)
Dear R Users,
I have to read data from many excel spreadsheets, all which have some
frustrating formatting (lots of titles, headers, etc.). I am trying
to work directly from source data and the number of the spreadsheets I
would have to go through make reformatting one by one a pain. I have
found lots of ways to read excel files, but my question is whether
there is a way to only read
2015 Sep 17
2
Fwd: Creación fichero excel con loadWorkbook
>
>
> Hola chic en s,
>
> sigo intentando crear un archivo de Excel pero no hay manera. Sigo los pasos del documento de ayuda siguiente:
>
> http://altons.github.io/r/2015/02/13/quick-intro-to-xlconnect/#load
>
> los pasos que hago son:
>
> install.packages("XLConnect")
> require(XLConnect)
> wb <-
2011 Oct 11
5
help to ... import the data from Excel
Hi every one ,,,,
i have problem in R program to import the data from excel ,
I have done the following:
1. install.packages("xlsReadWrite")
2. library(xlsReadWrite)
3. z<- read.xls("ReadXls",LTS,colNames=FALSE,sheet,type,form,rowNames=FALSE)
and i got on the result:
Error in read.xls("ReadXls", LTS, colNames = FALSE, rowNames = FALSE) :
object
2013 Feb 23
3
data.frame and import to xlsx
Hi,
i have a very huge number of data with the size 2375ko, i want to import
them for R to xlsx
but the size of excel is limited
How can i resolve this problem?
And please how can i define the frame
Note that i have a table
rows times c(1.....100) columns WLc(200...1000) and inside S c(15,.........)
the table it is full values
--
View this message in context:
2012 May 09
4
Can't read xlsx file into R. Seem, Seem to have XLConnect loaded.
I have spent hours on R in Windows 7. Just installed 2 days ago so the R
package should be current.
Currently I am using the RGui (64-bit) for Windows.
I can not read an Excel file into R from my computer. Have hours on this.
Completely crazy!!
I have the XLConnect package loaded. I think it is loaded because when I
enter:
> loadedNamespaces()
[1] "base"
2013 Nov 04
3
Reading data from Excel file in r
Hi experts,
I want to read data from an excel data like this:
for the fifth column, from first row until 140 but only 1,3,5,7,.....139
(only 70 values),
How can I do it in R?
thanks
[[alternative HTML version deleted]]
2013 May 20
2
exportar a excel
Buenos días
Creo la siguiente tabla:
> tapply(hogares_larioja$DB090, list(HX060=hogares_larioja$HX060, HS190=hogares_larioja$HS190, HH040=hogares_larioja$HH040, HH050=hogares_larioja$HH050, HH081=hogares_larioja$HH081, HH091=hogares_larioja$HH091), sum)
y el resultado quiero exportarlo a excel (este y otros que he realizado, claro) para publicarlos. ¿Cómo puedo hacerlo?.
Gracias
BB
2011 Aug 12
1
Extract named regions from an Excel file using XLConnect?
Hi Everybody
In R, the XLConnect package can read and write named region to and from
Excel. In order to read a named region with the readNamedRegion function you
need to know it's name. You can check is a name exists with existsName, but
you still have to know the name. Is there a way to actually get a list of
the named regions in XLConnect sinilar to getRanges in the xlsx package.
On that
2011 Jul 13
7
Error when writing to Excel files using the packages xlsx and xlsx2
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
2012 Aug 08
4
Saving Splitted Series to Excel via XLConnect
Dear R Discussion List,
I would like to save my data as a xlsx file. But at first
I need to split it and then save each series into a Excel
column. Please take a look at the following code:
dados <- data.frame(matrix(c("2012-01-01","2012-02-01",
"2012-03-01","2012-04-01","2012-05-01","2012-06-01",
2009 Dec 17
8
how to import data from excel to R
Hi,
I am using R and I want to know how data can be transferred from Excel
Spread sheet to R for analyzing. I have done like this
mydata<-read.table("C:\Documents and Settings\admin\Desktop\data.txt");
but its not working how can i do it
regards
Sarath Sankar V
2012 Aug 17
4
Appending many different and separate Excel files using R
Dear all,
Good day!
I have a problem in reading Excel files in R and appending them to each other. Suppose we have several Excel files in a directory with headers and want to use R to append them in a single file with an additional variable in the final file indicating from which files the data come from.
As I have many Excel files and their sizes are very big I should write a loop in R to do
2017 Sep 24
0
"XLConnect" packages; Excel dates read incorrectly
> On Sep 23, 2017, at 6:30 AM, Eric Berger <ericjberger at gmail.com> wrote:
>
> Jim,
> I don't see how that link could be related to John's issue. Symptoms
> related to your link involve discrepancies of four years whereas John is
> seeing discrepancies of one day.
>
The MS Excel starting point was off by one day. R does not repeat that error. MS claims that
2017 Sep 23
2
"XLConnect" packages; Excel dates read incorrectly
Jim,
I don't see how that link could be related to John's issue. Symptoms
related to your link involve discrepancies of four years whereas John is
seeing discrepancies of one day.
John,
I do not see any attached files.
Regards
On Sat, Sep 23, 2017 at 1:30 PM, Jim Lemon <drjimlemon at gmail.com> wrote:
> Hi John,
> It could be due to this:
>
>