Displaying 20 results from an estimated 2000 matches similar to: "xlsx [path input]"
2010 Sep 06
1
Help on write.xlsx library(xlsx)
Hi Adrian,
dat=data.frame(matrix(0,3,3))
write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F)
write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F)
The above code works and creates new worksheets. But if I want to append
to an existing worksheet I seem to get an error.
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")
>
2011 Aug 23
1
NA in last row while reading xlsx file
Hi,
I am using this script to read a xlsx file to a data frame:
library(xlsx)
File <- file.path("d:", "car ", "car95-99.xlsx")
B_car <- read.xlsx(File, "raw_data")
Car2x <- data.frame(month = B_car$Date,Ch = B_car$Ch.des,
lat=B_car$Latitude)
The last row in the data.frame is always NA, how can I remove it?
Thx.
--
View this message in
2016 Apr 23
1
Java memory error when reading a small xlsx file
Hi,
I tried to read a (small) xlsx file by "readWorksheetFromFile" function
of "XLConnect" package and "read.xlsx" function in "xlsx" package, but I
got this error message:
Error: OutOfMemoryError (Java): Java heap space
I tried to follow the solution on the web
2010 Feb 12
2
Help on loading "xlsx" package
Dear R users,
Im trying to load *"xlsx"* package which depends on *"xlsxjars"* and *
"rJava"* packages.
All the 3 packages (zipped files) are installed successfully in windows.
I have added "C:\Program Files\Java\jre1.6.0_03\bin\client" to the PATH
variable to get rJava working.
However, the following error message results after inputting
2013 Jan 09
2
writing to .xlsx
Dear r helpers;
I'm interested in reading from and writing to large .xlsx files fairly
regularly. (Why, the naysayers may ask - and the answer is basically
colleagues and clients who prefer that format). I've tried out the
XLConnect and xlsx libraries, but the java implementation they use just
takes too much RAM for the files I'm working with.
gdata leverages perl and works really
2024 Mar 15
1
write.xlsx error message
I think remember this error from trying to write an Excel file that already existed. If this file already exists, try to delete it and see, if this solves the issue.
Besides that you're writing that you are "Using write.xlsx to extract data from an Excel file", write.xlsx() is to write an Excel file, not to read from it. Should be read.xlsx() then iirc.
?
?
Gesendet:?Freitag, 15.
2010 Aug 03
1
xlsx package
HI, I was trying to install xlsx package for reading in Excel 2007 files. The
installation went smoothly. But when I tried to load the library, I got the
following error message:
> library(xlsx)
Loading required package: xlsxjars
Loading required package: rJava
Error : .onLoad failed in loadNamespace() for 'xlsxjars', details:
call: .jinit()
error: cannot obtain
2009 Jul 08
1
Import xlsx file in Ubuntu 9.04
Hi list,
By the entire last 2 weeks I was looking for a way to directly import xlsx
files to R in a Linux OS (Ubuntu 9.04). I already read the R Import/Export
guide, and I know how to use gdata to import xls files and read.table to
import .csv. My problem is that all data that I receive is in the xlsx
format, and I have to convert all the files to xls.
Well, when I was using Windows Vista OS,
2013 Apr 05
1
problems with indexing xlsx files
Hello,
I have a number of Excel .xlsx files that aren't indexed properly. To illustrate, I have a file called "this is a test.xlsx". It consists of four cells:
| this |
| is |
| a |
| test |
It gets indexed but I am unable to search for it.
I was able to determine the index number and use delve to see the term list:
#delve users -r 16496
Term List for record #16496:
2011 Jul 03
1
Error with package xlsx
Hi,
Could anyone help me with this error? I have no idea what that is about...
> file <- system.file("DADOSCASUMCCORMICK.xlsx", package = "xlsx")
> data <- read.xlsx(file, 1)
Error in .jnew("java/io/FileInputStream", file) :
java.io.FileNotFoundException: (No such file or directory)
Thanks!
--
Regards,
|| ------
|| Sergio Henrique Bento de Mira
2011 Aug 15
3
how can I read a xlsx file
Hello,
How can I read a xlsx file using xlsx package?
Thanks
Albert
[[alternative HTML version deleted]]
2012 Oct 16
1
Problems with xlsx and rjava
Hi,
I keep getting the below error regarding rJava which is required by package xlsx (I have used it in the past to directly import data from Excel 2010).
I was on R version 2.15.0 when I was getting this error this morning. So I upgraded to 2.15.1 but still the same problem. I tried unstalling and reinstalling xlsx and even rJava directly from the source as indicated here:
2011 Feb 09
3
Problem with xlsx package
I am trying to read an xlsx spreadsheet (1506 rows, 501columns) all
populated but getting the following error:
Please advise as to how to get around this issue.
> res <- read.xlsx("c:\\BSE_v2.xlsx",1)
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :
java.lang.OutOfMemoryError: Java heap space
Here is the session info:
2011 Mar 28
2
xlsx problem
Dear list,
I'm running windows xp with R 2.12.0. I'm trying to load a excel
spreadsheet into R using the xlsx package. I posted my code below with
the error I get.
> res <- read.xlsx("Copy of test_excel_input_data.xlsx", 6)
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :
java.lang.IllegalStateException: Cannot get
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:
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
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 =
2011 Aug 02
1
xlsx error
Hey All,
I'm trying to use the xlsx package to read a series of excel spreadsheets
into R, but my code is failing at the first step.
I setwd into my the directory with the spreadsheets, and, as a test ask for
the first one:
read.xlsx(file = "Argentina Final.xls", sheetIndex = 1)
I promptly get an error message:
Error in .jcall(row[[ir]],
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.