saveAsExcel: Save grids as Microsoft Excel file (.xlsx)

In OpenRepGrid: Tools to Analyze Repertory Grid Data

Save grids as Microsoft Excel file (.xlsx)

Description

saveAsExcel will save one or more grids in an Excel file (.xlsx).

Usage

saveAsExcel(x, file, format = "wide", sheet = NULL, default_sheet = "grid")

Arguments

x	A repgrid object or a list of grids.
file	File path. Suffix must be .xlsx.
format	Two output formats are supported: wide (default) where each column represents one element, each row represent one constructs (a common grid representation), and long where each row contains an element-construct combination and the corresponding rating value. See importExcel() for details and examples.
sheet	Vector of sheet names with same length as x. If NULL (default), default_sheet is used. If x is a list if grids, a sequential index is appended. For named list entries (if x is a list of grids), the name overwrites the default sheet name.
default_sheet	Default sheet name to use if not supplied in sheet or via list names of x.

Value

Invisibly returns file path.

See Also

importExcel(), saveAsWorksheet()

Examples

# save one grid in wide format (default)
file <- tempfile(fileext = ".xlsx")
saveAsExcel(boeker, file)
## Not run: 
browseURL(file) # open file, requires Excel, may not work on all system

## End(Not run)

# save one grid in log format
file <- tempfile(fileext = ".xlsx")
saveAsExcel(boeker, file, format = "long")
## Not run: 
browseURL(file)

## End(Not run)

# save a list of grids
file <- tempfile(fileext = ".xlsx")
l <- list(boeker, feixas2004, bell2010)
saveAsExcel(l, file)
## Not run: 
  browseURL(file)

## End(Not run)

# pass some sheet names (2nd with named sheet)
file <- tempfile(fileext = ".xlsx")
l <- list(boeker, "feixas' grid" = feixas2004)
saveAsExcel(l, file)
## Not run: 
  browseURL(file)

## End(Not run)

OpenRepGrid documentation built on Aug. 10, 2025, 5:06 p.m.