[ic] [query2xls] tag interpolation

[Rick Bragg]

Hi,

Does anybody know how I could get the query2xls tag to interpolate?
For example, I would like to do something like the following:

[tmp sql]SELECT * FROM tablename WHERE code = '1'[/tmp]

  [query2xls interpolate=1
    query.sheetname1="[scratch sql]"
    file-name="file-to-create.xls" 
    base.tablename
    width=25
    deliver=1
  ]

Actually, I would like to loop through the entire query.## area like
this:

  [query2xls interpolate=1
    [loop prefix=q list="1..[scratch q_count]" ranges=1]
        query.[calc] $Tag->scratch({ name => sheet_name_[q-code], });[/calc]="[calc] $Tag->scratch({ name => sql_[q-code], });[/calc]"
    [/loop]
    file-name="file-to-create.xls" 
    base.tablename
    width=25
    deliver=1
  ]

Anybody know the best way to do this?

Thanks
Rick