This WebService method creates an Excel workbook with all Anaplan XL functionality removed, suitable for viewing by users without the Anaplan XL Excel Edition. Allows slicer values to be changed before rendering.

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.), e.g. 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.
Guid[] slicerGuidsA list of slicer guids to modify in the report.
string[][] slicerSelectionsA list of selections to set on the slicers listed in slicerGuids.
out string reportNameReturns the published name of the report.
out string reportExtensionReturns the file extension (typically .xls or .xlsx).
out string[] emailAddressesInternal use only.

Remarks

    • The RenderReportChangingSlicersAsStaticExcel2 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.