Take an edited flat-view workbook back into the YAML spec
Source:R/spec_xlsx_import.R
tfl_import_spec_xlsx.RdThe workbook tfl_write_spec_xlsx() wrote, edited in Excel, read back:
each row is matched by its key (toc: id; datasets: dataset;
populations: id; analysis_data and analyses: output_id + id;
codelists: output_id + variable + value; tokens: output_id +
name; header / footer / titles / footnotes: output_id +
line; page / report: output_id; listing_cols: output_id +
vars) and the item it names is updated with the row's cells; a row
with a new key is added; an item the workbook no longer has is reported
(missing), not removed. Cells read as the converter reads sheets: a | b a list, (none) an !unset, the columns that hold R as !r.
Nothing else of the YAML files changes.