Crash Course

Part 4: Using Web Design API to export to Excel

Double click on the Output Table and choose "Edit" on the toolbar.

Specify this button as "Export to Excel", System Action=Hyperlink, and then click Formula.

Specify this formula:


NOTE: This URL is for the Web Analyzer PCD Location if Visual Composer is on the same server as BI-Java. If it is not, see the section on Mapping External BI locations.

Choose OK.

NOTE: This will export the default view of the data service to an Excel File. It will not keep filters or navigation states.

Deploy your model.

Run your iView and choose "Export to Excel".

Look at your exported Excel file.

    Requires Free Membership to View

Visual Composer for xApp analysis

  Home: Introduction
  Part 1: Architecture of Visual Composer BI Kit
  Part 2: Using the native Visual Composer export data functionality
  Part 3: Using Web Design API to export to CSV
  Part 4: Using Web Design API to export to Excel
  Part 5: Using Web Design API to export to PDF
  Review: Conclusion and additional resources

This was first published in December 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: