Additional tips for ERExcelLook

Last modified by Kieran Kelleher on 2010/02/19 19:25

ERExcelLook-specific Rules

For quick reference:

1. How do I change the default name of the downloadable spreadsheet?

Unknown macro: noformat. Click on this message for details.

If you want the excelFileName to be dynamic (i.e. pulled from a value in your code) you can use ERDDelayedKeyValueAssignment to assign its value from a keypath:

Unknown macro: noformat. Click on this message for details.

2. How do I customize the columns that will appear within the downloadable spreadsheet?

Unknown macro: noformat. Click on this message for details.

3. How do I customize the titles used by the columns that will appear on the downloadable spreadsheet?

Unknown macro: noformat. Click on this message for details.

4. How do I customize the worksheet names within the downloadable spreadsheet? You can specify the worksheet name by adding it in parenthesis as the first item in your displayPropertyKeys array. i.e: "Contact List" for the rule below

Unknown macro: noformat. Click on this message for details.

Alternately: You can use the key excelSheetName and assign it a value using a rule similar to tip 1

Unknown macro: noformat. Click on this message for details.

5. How do I display email addresses in the downloadable spreadsheet?

Unknown macro: noformat. Click on this message for details.

6. How do I use ERExcelLook when Click to Open is enabled? (Note the low priority number) This disables ClickToOpen for these Excel pages only

Unknown macro: noformat. Click on this message for details.