Opening a websheet that references an Excel file outside of TM1

You can open a websheet that references an Excel file.

Procedure

Use the format:

value="WebsheetPath

where WebsheetPath is the location and name of the Excel file. This can be either a path for a local file, or a UNC path for a file located on a network.

For example, to set a UNC network path for websheet:

value=//MySystem/Samples/classic_slice.xls

Results

The complete HomePageObject parameter looks like this:

<add key="HomePageObject" value="//MySystem/Samples/classic_slice.xls;Type=websheet;

Description=MyWebsheet;AllowOverwrite=true"/>