This WebService method creates an Excel workbook with all Anaplan XL functionality removed, suitable for viewing by users without the Anaplan XL Excel Edition.


Note: Available for Enterprise Edition only.

Parameters

ParameterDescription
string reportPathThe 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.

  • 0 - Workbook
  • 1 - Worksheet
string areaToRenderUsed if areaToRenderType == Worksheet; the name of the worksheet.
string localeThe culture code for the locale that the report should be rendered in (for dates, number formatting, etc.), for example en-US.
string[] roleNamesThe 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[] parameterNamesA list of web parameter names to pass to the report.
string[] parameterValuesA list of web parameter values, matching parameter names. See Remarks below.
string mustBeTrueParamNameInternal use only.
string emailAddressesParamNameInternal use only.
out string reportNameReturns the published name of the report.
out string reportExtensionReturns the filename extension (typically .xls or .xlsx).
out string[] emailAddressesInternal use only.

Remarks

    • The RenderReportAsStaticExcel2 method is preferred. This method uses all the same parameters except for the parameterValues parameter, which is an object[][]. This method supports multiple values being passed in for the parameter.