Synthoid / ExportSheetData

Add-on for Google Sheets that allows sheets to be exported as JSON or XML.
MIT License
234 stars 46 forks source link

(Bug) 'Export sheet arrays' + 'Export contents as array' only exports one sheet #141

Open Ryuichiro opened 3 years ago

Ryuichiro commented 3 years ago

Describe the bug 'Export sheet arrays' + 'Export contents as array' setting only exports the last sheet even if the export settings enable multiple 'targetSheets'.

To Reproduce Steps to reproduce the behavior:

  1. Create a 2. Sheet
  2. Set A1 of Sheet1 and Sheet2 to {#SHEET}{#ROW}Id
  3. Set A2 of Sheet1 1 and A2 of Sheet2 to 2
  4. Enable 'Nested Elements' && 'Export sheet arrays' && 'Export contents as array'
  5. Set 'Export Sheets' to All Sheets (or Custom and select both Sheet1 and Sheet2)
  6. Export or Visualize data
  7. Get an array which only contains the item from Sheet2.

Expected behavior Considering that exporting multiple files at a time is still a feature request, I would expect the generated array would concat the arrays of all enabled sheets.

Screenshots image

Info (please complete the following information):

Additional context Complete Settings:

{
  "exportType": "jsonFormat",
  "exportFolderType": "custom",
  "exportFolder": "16eBHLQhCC3ZmEICSoUlr-HMHO7wXiqmu",
  "exportSheets": "custom",
  "targetSheets": "{\"Sheet1\":\"true\",\"Sheet2\":\"true\"}",
  "replaceExistingFiles": true,
  "unwrapSingleRows": false,
  "collapseSingleRows": false,
  "ignoreEmptyCells": true,
  "ignoreColumnsWithPrefix": true,
  "minifyData": false,
  "includeFirstColumn": false,
  "ignorePrefix": "NOEX_",
  "unwrapSheetsWithPrefix": false,
  "unwrapPrefix": "US_",
  "collapseSheetsWithPrefix": false,
  "collapsePrefix": "CS_",
  "nestedElements": true,
  "forceArrayNest": false,
  "forceArrayPrefixNest": "NA_",
  "forceString": false,
  "exportCellArray": false,
  "exportSheetArray": true,
  "exportValueArray": false,
  "exportContentsAsArray": true,
  "exportCellObject": false,
  "emptyValueFormat": "null",
  "nullValueFormat": "null",
  "separatorChar": "~",
  "forceArray": true,
  "forceArrayPrefix": "JA_",
  "exportChildElements": false,
  "exportBoolsAsInts": false,
  "rootElement": "data",
  "nameReplacementChar": "_",
  "includeDeclaration": false,
  "declarationVersion": "1.0",
  "declarationEncoding": "none",
  "declarationStandalone": "none",
  "forceAttributes": false,
  "attributePrefix": "ATT_",
  "forceChildElements": false,
  "childElementPrefix": "CE_",
  "forceInnerText": false,
  "innerTextPrefix": "IT_",
  "rootNamespace": "",
  "namespaces": []
}