 |
Enterprise Edition Only |
This WebService method creates an Excel workbook, suitable for those with the FluenceXL Excel Edition.
Parameters
Parameter
|
Description
|
string reportPath
|
the report to render. Should be given relative to the Repository folder.
|
int areaToRenderType
|
specifies whether to render the entire workbook or a single sheet:
Specifying ranges is unsupported for Excel workbooks.
|
string areaToRender
|
used if areaToRenderType == Worksheet; the name of the worksheet.
|
string locale
|
the culture code for the locale that the report should be rendered in (for dates, number formatting, etc.), e.g. en-US.
|
string[] roleNames
|
the Analysis Services role names to use to render the report. Note that the user running the report should have access to the roles listed. Use null or an empty array to use the default roles for the user.
|
string[] parameterNames
|
a list of web parameter names to pass to the report.
|
string[] parameterValues
|
a list of web parameter values, matching parameter names. See Remarks below.
|
string mustBeTrueParamName
|
internal use only.
|
string emailAddressesParamName
|
internal use only.
|
out string reportName
|
returns the published name of the report.
|
out string reportExtension
|
returns the file extension (typically .xls or .xlsx).
|
out string[] emailAddresses
|
internal use only.
|
- From v8.1, the RenderReportAsLiveExcel2 method is preferred. This method uses all the same parameters except for the parameterValues parameter, which is an object[][]. This supports multiple values to be passed in for the parameter.