This function exports the passed in iso_files to Excel. The different kinds of data (raw data, file info, methods info, etc.) are exported to separate tabs within the excel file. Use the various include_... parameters to specify what information to include. Note that in rare instances where vectorized data columns exist in the file information (e.g. measurement_info), they are concatenated with ', ' in the excel export. Note that the openxlsx package required for this export is not installed automatically as part of isoreader. Please install it manually if missing using install.packages("openxlsx").
iso_export_to_excel(
iso_files,
filepath,
include_file_info = everything(),
include_raw_data = everything(),
include_standards = !!enexpr(include_method_info),
include_resistors = !!enquo(include_method_info),
include_vendor_data_table = everything(),
include_problems = everything(),
with_explicit_units = FALSE,
include_method_info = everything(),
with_ratios = NULL,
quiet = default(quiet)
)collection of iso_file objects
the path (folder and filename) to the export file. The correct file extension is automatically added if not already in the filename, i.e. filename can be provided with or without extension.
which file information to include (see iso_get_file_info). Use c(...) to select multiple, supports all select syntax including renaming columns.
which columns from the raw data to include. Use c(...) to select multiple columns, supports all select syntax including renaming columns. Includes all columns by default. Set to NULL to include no raw data.
which columns from the standards info to include. Use c(...) to select multiple columns, supports all select syntax including renaming columns. By default, everything is included (both standards and ratios). To omit the ratios, change to select = file_id:reference. Set to NULL to include no standards info.
which columns from the resistors info to include. Use c(...) to select multiple columns, supports all select syntax including renaming columns. Includes all columns by default. Set to NULL to include no resistors info.
which columns from the vendor data table to include. Use c(...) to select multiple columns, supports all select syntax including renaming columns. Includes all columns by default. Set parameter with_explicit_units = TRUE to make column units explicit (keep in mind that this will require specific include_vendor_data_table column selections to reflect the column names including the units). Set to NULL to include no vendor data table.
which columns from problems to include. Use c(...) to select multiple columns, supports all select syntax including renaming columns. Includes none of the read problems by default. Set to include_problems = everything() to include all columns.
whether to include units in the column headers of the returned data frame instead of the column data types (see iso_double_with_units). Note that any select conditions have to refer to the column names including the full units.
deprecated in favor of the more specific include_standards and include_resistors
deprecated, please use the select parameter to explicitly include or exclude ratio columns
whether to display (quiet=FALSE) or silence (quiet = TRUE) information messages. Set parameter to overwrite global defaults for this function or set global defaults with calls to iso_turn_info_messages_on and iso_turn_info_messages_off
returns the iso_files object invisibly for use in pipelines
Other export functions:
iso_export_to_feather(),
iso_save()