Create spreadsheet dynamically

Create spreadsheet dynamically

Postby pflick » Tue Mar 19, 2013 4:16 pm

I have a spreadsheet that contains the names of other spreadsheets I need to read in. I can't seem to create these new spreadsheets dynamically using the Create Global Data Item command:

SET rownum = 1
UNTIL CrimeNames[1,rownum] = ""
SET Crime = CrimeNames[2,rownum]
Create Global Data Item Crime, Sheet
SET rownum = rownum+1

The above syntax is not accepted and looking at the documentation I fear that it would just create the sheet called Crime over and over instead of a new sheet for each crime name. Is there a way to create sheets dynamically? Id rather not have to create the sheets in the information store since they change often.

Thanks for any advice.

Return to “SIMUL8 Cafe”