Dear Allin,
 because I have over 60 banks in different sheets I tried to construct a loop with the open function (before I found that it can't be used in a loop construction) nevertheless while tweaking this script gretl crashed several times.
Maybe it's my poor scripting skill or perhaps a bug, anyway I thought you should see it.
Attached script file and terminal output. 

Mihai 


On Thu, 12 Sep 2013, cociuba mihai wrote:

> I have a spreadsheet file (simulation) which is attached , I'm trying to
> import it as panel data but if I try the built in import command from GUI I
> only can import the first sheet.
> Can you give me any suggestion?

Your data are sideways on, and need transposing. This is better done by 
script.

<hansl>
open simulation.xls --sheet=1 --rowoffset=2 --preserve
# grab the transpose of the data as a matrix
M = {dataset}'
# and record the length of the time dimension
scalar T = rows(M)

open simulation.xls --sheet=2 --rowoffset=2 --preserve
# stick on row-wise the transpose of the next data
M |= {dataset}'

open simulation.xls --sheet=3 --rowoffset=2 --preserve
# stick on some more data
M |= {dataset}'

scalar NT = rows(M)

# create a suitably sized dataset
nulldata NT --preserve
# pull out the columns of M as series
series v1 = M[,1]
series v2 = M[,2]
delete index
# hello gretl, this is a panel!
setobs T 1.1 --stacked-time-series
series year = time + 2004
# take a look
print --byobs
</hansl>

Allin Cottrell