Combine TMA spreadsheets — combine_tma

This function combines multiple TMA spreadsheets into a single spreadsheet that can be used for deconvolution with TMAtools::deconvolute().

Usage

combine_tma_spreadsheets(
  tma_dir,
  output_file = "combined_tma_spreadsheet.xlsx",
  biomarker_sheet_index = 2,
  tma_map_sheet_index = 1
)

Arguments

tma_dir: The directory containing the TMA spreadsheets.
output_file: The name of the output file.
biomarker_sheet_index: The index of the sheet used for ALL files for the biomarker scores.
tma_map_sheet_index: The index of the sheet used for ALL files for the TMA map.

Value

List of data frames (invisible).

Examples

library(TMAtools)
tma_dir <- system.file("extdata", package = "TMAtools")
combine_tma_spreadsheets(
    tma_dir = tma_dir,
    output_file = "combined_tma_spreadsheet.xlsx",
    biomarker_sheet_index = 2,
    tma_map_sheet_index = 1
)
#> Using TMA map from the file: /home/runner/work/_temp/Library/TMAtools/extdata/example.xlsx
# check the output Excel file, which should then be used as
# the input for `TMAtools::deconvolute()`