Export Sheets (All) not working

Synthoid / ExportSheetData

Add-on for Google Sheets that allows sheets to be exported as JSON or XML.

MIT License

236 stars 46 forks source link

Export Sheets (All) not working #100

Open imtrobin opened 4 years ago

imtrobin commented 4 years ago

Reporting, when I do Export Sheets (All), only the last sheet is exported. Even if I do Custom, Select All, same result.

Synthoid commented 4 years ago

What settings are you using?

imtrobin commented 4 years ago

JSONExport Export Sheet (s), All or Custom with All sheets selected Export Sheet Arrays Export contents as Array

Synthoid commented 4 years ago

Hmm. I've been able to export several sheets with those settings. Can you share the document with me so I can debug? If not, there could be a few explanations:

Are multiple accounts signed in? If so, try signing out of all but one. (This is a bug with how Google loads add-ons for some reason and I can't seem to fix it on my end)
Do you own the document or is it shared with you?

imtrobin commented 4 years ago

1 account only. I own the document but can I share with you in private? What's your email?

imtrobin commented 4 years ago

Created a sample sheet which has the problem

https://docs.google.com/spreadsheets/d/1Y8CvCKoS4QoMt2P3XZsARmnuaIvDkzlcV8BuET5WlQo/edit?usp=sharing

imtrobin commented 4 years ago

I found that the problem is selecting "Export Sheet Array". If selected, then it does not export all sheets

Synthoid commented 4 years ago

Hmm, I wonder if it is the combination of Export sheet arrays and Export contents as array then. Both of those individually should work as expected. I'll see what's happening there!