data.frame and import to xlsx
Hello,
Please keep the discussion on the list, the odds of you getting more and
better answers is greater. (I'm Cceing to R-Help.)
What package is read_spectra in?
What type of object does it return? Can you post the result of the
following instruction?
str(SP) # paste the output of this.
If it's a data.frame then package XLConnect can do the job. The
following code is the example in ?XLConnect::saveWorkbook adapted to a
file named etch1.xlsx and to a dataset named SP.
#install.packages('XLConnect') # do this only once
library(XLConnect) # load it in the R session
# Create a new workbook 'etch1.xlsx'
# (assuming the file does not exist already)
wb <- loadWorkbook("etch1.xlsx", create = TRUE)
# Create a worksheet called 'SP'
createSheet(wb, name = "SP")
# Write dataset SP to sheet 'SP' created above
writeWorksheet(wb, SP, sheet = "SP")
# Save workbook - this actually writes the file 'etch1.xlsx' to disk
saveWorkbook(wb)
Hope this helps,
Rui Barradas
Em 24-02-2013 17:42, Sihem Ben Zakour escreveu:
I have a data,
you can read them with this function
SP <-
read_spectra("path/etch1.svd")
but i want to open them on xlsx
The WL is the name variables (from 200......)
t is the time,
and SP is the observations on WL(i) and t(j)
please could you help me to convert them on xlsx with this form
t\WL 200 200.5 ...
.
.
________________________________ De : Rui Barradas <ruipbarradas at sapo.pt> ? : sisi26 <benzakour_s at ymail.com> Cc : r-help at r-project.org Envoy? le : Dimanche 24 f?vrier 2013 13h53 Objet : Re: [R] data.frame and import to xlsx Hello, I'm not sure I understand the question. You want to import an xlxs sheet to R? Look at package XLConnect. The vignette explains several ways of doing it. And as for the frame, the import functions in XLConnect (and the several read.* functions in base R) return data.frames so the problem should be solved. Hope this helps, Rui Barradas Em 23-02-2013 22:14, sisi26 escreveu: 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: http://r.789695.n4.nabble.com/data-frame-and-import-to-xlsx-tp4659486.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.