I need the exact functionality demonstrated at http://sheetnode.org/content/multiple-worksheet-demo using a template for a fixed number of sheets but cannot figure out how to get there.
I'm using Drupal 7.21, sheetnode 7.x-1.0-beta4, and all the latest required libraries, and everything seems to work fine, except...
- when I import an xls file with multiple worksheets, I get multiple nodes rather than one node with multiple sheets
- when I create a custom content type (which is how I actually need to use the functionality anyway), defining the field as holding more than one value does create multiple blank sheets--but without pre-defined sheet names (title inputs? field keys?) and I am also unable to specify more than one template
- when I create multiple sheetnode fields, the last which aggregates data from the previous ones runs extremely slow and fails to reference the previous sheets using any source of name that I can determine (using references like =ORG.DRUPAL.FIELD('title')!A1)
So simply put, where am I supposed to go to create exactly what's on that demo page, and is this possible while initializing all sheets with a template? (whether per-sheet templates or one template with all sheets, I don't really care, as long as it works--and doesn't freeze the browser for 20 seconds like now, despite using only 4 sheets and all very simple and small)
Comments
Comment #0.0
HonoredMule CreditAttribution: HonoredMule commentedblah
Comment #1
pepsimxm CreditAttribution: pepsimxm commentedHi HonoredMule,
I had the same problem but the answer was staring me right in the face on the demo page.
"This is a custom content type built with CCK and using the Spreadsheet field type. Exporting this node to XLS or XLSX generates a workbook with 2 worksheets."
So, you need to add a new content type and add multiple 'spreadsheet' fields to that.
...not sure if that's helpful 1 year on, but hopefully it is for someone.
Comment #2
infojunkieThanks @pepsimxm for the response. Marking this as fixed.