[R] data.frame and import to xlsx
ruipbarradas at sapo.pt
Sun Feb 24 19:00:03 CET 2013
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
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
Hope this helps,
Em 24-02-2013 17:42, Sihem Ben Zakour escreveu:
> I have a data,
> you can read them with this function
> SP <-
> 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
> 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
> Hope this helps,
> Rui Barradas
> Em 23-02-2013 22:14, sisi26 escreveu:
>> 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
>> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help