Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

support multiple sheets in a page #4

Open
roasted-potatoe opened this issue Mar 27, 2019 · 3 comments
Open

support multiple sheets in a page #4

roasted-potatoe opened this issue Mar 27, 2019 · 3 comments

Comments

@roasted-potatoe
Copy link

roasted-potatoe commented Mar 27, 2019

Being able to choose the sheet of the spreadsheet would be a nice feature to have.

@radiatoryang
Copy link
Owner

looked into this; it looks like Google Sheets CSV export relies on a currently selected sheet. which gets defined as a "gid" variable in the URL string... and the GID is a bunch of randomly assigned digits, so Bobbin cannot predict or derive a GID from a document ID

so Bobbin would have to be able to extract the GID from the URL string (supplied by the user) and then insert that GID var in the export URL too, as well as modify the UI to show that a specific sheet was used... the user would still have to create a new entry for each sheet, unfortunately, due to limitations in Google Sheets' CSV export

a more robust solution: implement something like ExcelDataReader and export the .XLSX from Google Docs instead, which means we can process any / all sheets at once... however, that makes this tool considerably heavier / opens a big can of worms about how to support .XLSX properly

  • I'm currently really busy with other stuff, but I can come back to this in late April or May
  • in the meantime, anyone reading this is free to submit a PR for the "GID" solution I mentioned in the first 2 paragraphs

@ssmasrour
Copy link

TBH, your great tool only lacks this feature. Waiting to hearing that this plugin is updated. cheers

@ssmasrour
Copy link

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants