Displaying 20 results from an estimated 2000 matches similar to: "append within worksheet in write.xls"
2007 Feb 09
1
newline with cell of Excel worksheet created with write.xls
As part of my project to put different types of results into worksheets,
I would like to be able to put an auto-generated methods section. If I
compose in RWinEdt, read into R, and use write.table with a .txt file
extension, what I get out has line-breaks that correspond to those I put
in in the first place.
If I do the same thing but write.xls with .xls extention, I get an Excel
worksheet
2009 Mar 12
1
read.xls and name of worksheet
Hi,
I would like to some excel files with some worksheets. I tried this with
the following R script:
library(gdata)
i<-1
rc<-0
while(rc != "try-error") {
wksh<-try(read.xls("cluster-microarray-FW.xls",sheet=i,verbose=TRUE,perl="perl"))
rc<-class(wksh)
print(sprintf("------- i=%2d rc=%s ---------------",i,rc))
if (rc !=
2010 Apr 25
4
Image into Excel file from R
Hi useRs,
I would like to know what R users are employing to get their
images/plots created in R, into Excel sheets.
I am aware of the various packages (xlsReadWrite, RODBC) to get data
frames into R, but I would like to copy images too.
Thank you for any help in solving this problem.
Regards,
Harsh Singhal
2011 Jun 24
3
extract worksheet names from an Excel file
Hi list,
Is there a R function I can use to extract the worksheet names from an Excel file?? If no, any other automatic ways (not using R) to do this?
thanks!
...Tao
2012 Feb 12
2
Reading data from a worksheet on the Internet
Dear R-users,
I have to read data from a worksheet that is available on the Internet. I
have been doing this by copying the worksheet from the browser.
But I would like to be able to copy the data automatically using the url
command.
But when using "url" command the result is the source code, I mean, a html
code.
I see that the data I need is in the source code but before thinking
2001 Mar 10
1
wine-20010305 MS Excel97 *.xls -> .xls.xls
Hi,
If I open up a worksheet in MS Excel 97, the file name is modified
by appending an extra .xls to the name. Multiple .xls's are possible,
and it is not necessary to save the worksheet.
I'm running Wine-20010305 compiled on a SuSE 7.0 running a stock
2.4.2 Linux kernel. MS Excel is being run from an existing Win98
system partition.
Thought someone might want to know,
Dick
--
2007 Feb 08
5
xlsReadWrite Pro and embedding objects and files in Excel worksheets
Hans-Peter and other R developers,
How are you? Have you made any progess with embedding Url's in Excel?
Well, I have been busy thinking of more things for you to do;)
My colleagues in the lab are not R literate, and some are barely
computer literate, so I give them everything in Excel workbooks. I have
gradually evolved a system such that these workbooks have become
compendia of my
2010 Nov 12
3
Replicate Excel's LOGEST worksheet function in R
Hi -
I have a dataframe of (x,y) values. I'd like to fit an exponential
curve to the data for further statistical analysis (pretty much the same
functionality provided by Excel's LOGEST worksheet array function). Can
someone point me to the (set of) functions/ package that is best suited to
provide this functionality? Admittedly, I am a novice in the use of R
statistical functions,
2004 Nov 09
1
RODBC bug or doc error in sqlFetch on xls files (PR#7354)
R 2.0.0 patched under win2000. MS Office Excel 2003. ODBC Drivers?
This may not come as a surprise -- sqlFetch() (and perhaps other ?) appear
not to handle table/worksheet names with spaces in them in Excel tables. I
was not able to find documentation that specifically mentioned this,
although the Help pages vaguely hinted that there might be difficulty with
Excel's "peculiar
2007 Mar 23
6
Updating a worksheet in Excel file using RODBC
Hello!
I have no problem reading Excel files (each worksheet in the file is a "table" which can be read - at least in my case).
What I would like to do is to read such a table, change it (just the contents, not the format) and write it back, and this I can not do. I am getting the following error messages (3 slightly different attempts):
> sqlSave(con, x, tablename =
2013 Oct 11
1
behaviour of read.xls (gdata package) when worksheet usesuser-defined cells formats
(I'm afraid this post didn't reach the list on last Wednesday, here it is again )
hi R-list,
And sorry for my frenglish !
I am running R < Good Sport > release ( i386-w64-mingw32/i386 (32-bit) ) ) under Windows 7 Professional, Service Pack 1.
My perl executable is ActivePerl build 817 [257965] (i.e. version 5.8.8.817). Usually it is working fine.
Using the gdata ::read.xls
2012 Apr 20
1
odbcConnectExcel() fails to fetch all columns
Folks,
Is there a parameter somewhere in RODBC that enables more columns to be
retrieved from an Excel worksheet?
# This next bit uses an undocumented call in RODBC
z <- odbcConnectExcel("./BBaselinePtQaires_apr2011.xls")
BQ <- sqlFetch(z, "BBaselinePtQaires")
Gives me:
z RODBC[1]
And
BQ 134 obs. of 59 variables
I have all the rows in the worksheet but only the
2006 Jun 29
1
RCOM Package
Hi list,
I just installed the rcom package and tried to read/give out some values
from/to Excel. Altogether it works great... but nevertheless I don't know
how the syntax works or in other words: "Which command needs which
parameters?"
Is there somwhere a manual about this package with good examples? I've read
the Package description... but there are not really good
2009 Mar 12
0
FW: Re: Writing xls - multiple sheets
Jorge was kind enough to point out that I made a mistake in referencing
gabor's solution.
See below. Thanks Jorge.
-------- Begin forwarded message --------
Subject: Re: [R] Writing xls - multiple sheets
Date: 3/12/2009 6:03:13 PM
From: Jorge Ivan Velez
To: markleeds@verizon.net
Hi Mark,
Yes, he did (as always), but it is not what Ferry needed. Here is
Gabor's post:
2007 Jul 08
1
Writing Excel (.xls) files on non-Windows OSs using Perl
Hi all,
There have been quite a few threads in the recent months pertaining to
the ability to directly write native Excel (.xls) files from R. For
example, exporting R matrices and/or data frames to an Excel file, with
perhaps the ability to create multiple tabs (worksheets) within a single
file, with one tab/sheet per R object.
There exists the xlsReadWrite package on CRAN by Hans-Peter Suter,
2011 Jun 14
3
Read in from multiple Excel wksheets
I?ve got an Excel workbook with about 30 worksheets. Each worksheet
has 10000 rows of data over 30 columns.
I?d like to read the data from each worksheet into a dataframe or
matrix in R for processing. Normally, I use read.csv when interacting
with Excel but I?d rather manipulate a multisheet workbook directly
than set about splitting the original workbook and saving down each
part as a csv.
2004 Mar 02
2
Import range of cells from Excel
Dear all,
I would like to import a range of cells (e.g. F10:K234) from an Excel
worksheet to R. I have looked for documentation on RODBC and RDCOMClient but
I was not able to find enough information to solve my problem and all the
examples I have seen were dealing with an entire worksheet, not a range of
cells.
Thanks,
Jean-Noel
Jean-Noel Candau
INRA - Unit? de Recherches Foresti?res
2011 May 26
1
Using read.xls
I am using read.xls command from the gdata package. I get the following error
when I try to read a work sheet from an excel sheet.
Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, :
Intermediate file 'C:\Tmp\RtmpYvLnAu\file7f06650f.csv' missing!
In addition: Warning message:
running command '"C:\Apps\Perl\bin\perl.exe" "C:/Program
2008 Aug 26
1
problem in reading the columns from an xls file
I am having a problem in reading the columns from an xls file.
Following is the code:
workbook = Spreadsheet::ParseExcel.parse(params[:dump][:file])
worksheet = workbook.worksheet(0)
skip=0
worksheet.each(skip) { |row|
puts row.at(0)
}
I am storing "Customer" in the first row first column. When I print, it
is received as
2011 Jul 10
3
OpenOffice ods spreadsheets in R?
I would like to open OpenOffice (LibreOffice) .ods files in R. I've
tried the ROpenOffice package from omegahat, but unfortunately, the
read.ods() function attempts to use the values of the first column in a
worksheet as row names, and thus does not allow duplicates in there
(which, even more unfortunately, occur in my files). Also, the function
does not allow to forward any other