Wiki source code of Additional tips for ERExcelLook
Version 12.1 by David Holt on 2009/10/02 18:19
Show last authors
author | version | line-number | content |
---|---|---|---|
1 | === ERExcelLook-specific Rules === | ||
2 | |||
3 | ==== For quick reference: ==== | ||
4 | |||
5 | ~1. How do I change the default name of the downloadable spreadsheet? (It will be renamed the value for session.excelFileName) | ||
6 | |||
7 | {{noformat}} | ||
8 | |||
9 | |||
10 | 100: pageConfiguration = 'ListExcelFooBar' => excelFileName = "session.excelFileName" [ERDDelayedKeyValueAssignment] | ||
11 | |||
12 | |||
13 | {{/noformat}} | ||
14 | |||
15 | |||
16 | |||
17 | 2. How do I customize the columns that will appear within the downloadable spreadsheet? | ||
18 | |||
19 | {{noformat}} | ||
20 | |||
21 | |||
22 | 100 : pageConfiguration = 'ListExcelPerson' => displayPropertyKeys = (familyName, givenName,"currentContactAddress.address1", | ||
23 | "currentMContactAddress.address2", "currentContactAddress.city", "currentContactAddress.province", "currentContactAddress.postalCode", | ||
24 | "currentContactAddress.country", "currentContactAddress.email") [com.webobjects.directtoweb.Assignment] | ||
25 | |||
26 | |||
27 | {{/noformat}} | ||
28 | |||
29 | 3. How do I customize the worksheet names within the downloadable spreadsheet? (It will be called Contact List) | ||
30 | |||
31 | {{noformat}} | ||
32 | |||
33 | |||
34 | 100 : pageConfiguration = 'ListExcelPerson' => displayPropertyKeys = ("(Contact List)", familyName, givenName, | ||
35 | "currentContactAddress.address1", "currentMContactAddress.address2", "currentContactAddress.city", "currentContactAddress.province", | ||
36 | "currentContactAddress.postalCode", "currentContactAddress.country", "currentContactAddress.email") [com.webobjects.directtoweb.Assignment] | ||
37 | |||
38 | |||
39 | |||
40 | {{/noformat}} |