Configuring qExcelViewer

To configure qExcelViewer

1	Create a new blank page and give it an .aspx extension. This name must appear in the Excel Viewer URL property of qListView.

2	Add qExcelViewer to your page.

3	Open ezEdit.

The Primary Content page opens by default.

4	Enter a session name. This session must be the same as the Search Session Name created in qListView.

5	Select some display fields.

6	When done configuring each tab, click OK.

 

NOTE: If you are using Excel 2010, if you have more than 8 outline levels, some rows will be hidden. To show all data, select all rows and right-click the rows. Select Unhide.

 

 

 

Child View Display Fields

This property defines the fields that should be displayed in the Excel spreadsheet. When you select the Edit button, a dialog box opens with a list of field names based on the session name which you have saved in qListView.

The Child View Display Fields section contains the following:

 

Table 8. Child View Display Fields

Element	Description
Advanced Mode	Turn on if you want to edit Display Fields in XML format: <Fields LookupThresholdControlSetting="Default"> <Field Name="Title" InternalName="Title" /> </Fields>
Query All Fields	Controls how Web Parts behave in relation to the Excel View Lookup Threshold in SharePoint Resource Throttling. The options are: • Default — uses the level set in the Configuration Editor. If you have selected Query All Fields check box in the Configuration Editor, the Web Part will query only those fields that are not included in the Excel View Lookup Threshold. If the Query All Fields check box is cleared, the Web Part will query all fields. • On — If the Web Part level is On, the Web Part queries all fields in lists, except Lookup fields. • Off — If the Web Part level is Off, the Web Part queries all fields in lists, including Lookup fields. • Explicit — If the Web Part level is Explicit, the Web Part queries only those fields selected in the Display Fields. This option renders the best performance for your Web Part.
Title	Allows you to set the title for the field header. This is useful if the real field name is too long and you want to abbreviate the title in the field header, or if you simply want to display a different title in the field header. If this attribute is not specified, the value specified in the Name attribute is used in the field header.
Field Type	Indicates the type of the field selected. This is a read-only field and displays for all available list templates.
Align	Indicates the horizontal alignment for the field. The values is one of the following: left, right, or center. For example: <Field Name="Created" Align="right" />
Display Field Name	Allows you to specify the name of a field in the cross-site list. You only specify this if the field that you are trying to display is a cross-site lookup field. If you want to display multiple fields from the cross-site lookup field, use the Display Format.
Display Format	Allows you to set the format of the value that is displayed in a cross-site lookup field. You use this attribute if you want to display values from multiple fields. NOTE: You can use the field replacement expression <%Field%> to refer to a field. If you are using Advanced Mode, you must use the encoded form of the < and > characters, which are &lt; and &gt;, respectively, unless you use the Excel Viewer Editor which will encode it automatically for you. For more information, see Display Format