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

HonoredMule’s picture

Issue summary: View changes

blah

pepsimxm’s picture

Issue summary: View changes

Hi 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.

infojunkie’s picture

Status: Active » Fixed

Thanks @pepsimxm for the response. Marking this as fixed.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.