Skip to contents

Convert x-spreadsheet data to a list of data.frames

spreadsheetListToDf.Rd

Convert x-spreadsheet data to a list of data.frames, this function turns the data structure generated by the JS library (and parsed with jsonlite::fromJSON(simpifyVector = FALSE))) into a list of data.frames, one per sheet. It is the inverse of listToSpreadsheet.

Usage

spreadsheetListToDf(data, headerRow = TRUE)

Arguments

data

The data to convert, a list with the following structure

  • name

  • rows, which contains "cells", which contains entries with "text" other fields are ignored for now (customise this function and jsso it carries the following metadata:

  • field type for conversion

  • column names Y/N ) originating from a JSON object returned by x-spreadsheet, containing one entry per sheet, with the following structure: name: "Sheet1", rows: 0: cells: text: "A1",

headerRow

Whether the first row contains column names, TO DO: automatically detect this by carrying extra metadata with each sheet