ti to load data from spreadsheets

[scrummyd]

can someone please give an example on how to use ti to have a spreadsheet as a datasource which will be password protected to open and sheet protected. I've only ever used csv files.

And is it possible to load data from different sheets?

[Martin Ryan]

It's not possible to use spreadsheets as a source to TI. The best you can do is save the file as csv then load from there. Or use DBS formulae.

Martin

[David Usherwood]

Yonks ago I tried using Excel as an ODBC source and it worked. This wasn't with TM1 though.

[Alan Kirk]

Yonks ago I tried using Excel as an ODBC source and it worked. This wasn't with TM1 though.

I played around with that idea yesterday myself just out of curiosity; couldn't get it it to work with a TI. Named ranges, dollar signs after the sheet names, all the usual bumpf; none of the syntaxes flew because the TI "couldn't connect to the database". Also I did notice one MSDN article (didn't keep a reference to it as it seems to be academic now) which stated that it won't ever work with a passworded workbook, even if you supply the password which pretty much negated the OP's plans.

[Viet]

Hi there,

Yes TI works well with ODBC on Excel files.

Don't forget to name the table range and provide a header row.

Viet

[Alan Kirk]

Yes TI works well with ODBC on Excel files.

Don't forget to name the table range and provide a header row.

Which version(s) have you done this on? Because that was exactly the configuration that I had when I tested it in 9.0 SP3 and it refused to read the data.

Also, have you tried it with a passworded workbook as per the original question, or only with unpassworded ones?

[Wim Gielis]

I tested it on TM1 9.4 MR1, and Excel 2007.

Passworded files cannot be used, it seems.