This function exports a data.frame to a Excel file.

This function exports a MSnSet data object to a Excel file. Each of the three data.frames in the MSnSet object (ie experimental data, phenoData and metaData are respectively integrated into separate sheets in the Excel file).

The colored cells in the experimental data correspond to the original missing values which have been imputed.

Usage

readExcel(file, sheet = NULL)

listSheets(file)

write_Assay_To_Excel(wb, obj, i, n)

WriteHistory(wb, obj, n)

Write_SamplesData_to_Excel(wb, obj, n)

Write_RowData(wb, obj, i, n)

write.excel(obj, filename)

Arguments

file

The name of the Excel file.

sheet

The name of the sheet

wb

xxxx

obj

xxx

i

xxx

n

xxx

filename

A character string for the name of the Excel file.

Value

A Excel file (.xlsx)

Author

Samuel Wieczorek

Examples

library(QFeatures)
data(Exp1_R25_pept, package="DaparToolshedData")
obj <- Exp1_R25_pept[seq_len(100)]
df <- assay(obj[[1]])
tags <- qMetacell(obj[[1]])
colors <- list(
    "Missing POV" = "lightblue",
    "Missing MEC" = "orange",
    "Quant. by recovery" = "lightgrey",
    "Quant. by direct id" = "white",
    "Combined tags" = "red"
)
write.excel(obj, filename = "toto.xlsx")
#> [1] "toto.xlsx"


data(Exp1_R25_pept, package="DaparToolshedData")
obj <- Exp1_R25_pept[seq_len(10)]
write.excel(obj, "foo.xlsx")
#> [1] "foo.xlsx"