Saves a report as a Microsoft Excel (.xls) file.

TestRequestPage.SAVEASEXCEL(Filename)

Parameters

TestRequestPage

Type: TestRequestPageThe TestRequestPage from which you want to test saving the report as an Excel file.
Filename

Type: TextThe path and file name to which the report is saved. The file name extension should be .xls.

Remarks

All filters and options that have been set on the TestRequestPage are respected in the saved report.

After you run this function, you cannot continue to interact with the TestRequestPage. If you want to continue to use the TestRequestPage variable, you must run a report again.

Example

The following example shows the code for a test function to run a report and a request page handler function to test the request page. This example requires that you create the following:

This example also requires that you create the following variable in the C/AL Globals window of the SaveAsExcel codeunit.

Variable name DataType

Filename

Text

  Copy Code
//Test function: TestSaveAsExcel
Filename := TEMPORARYPATH + 'MyRep.xls';
MESSAGE(Filename);
IF NOT FILE.ERASE(Filename) THEN
  ERROR('Cannot erase %1',Filename);
REPORT.RUN(111);
IF NOT FILE.EXISTS(Filename) THEN
  ERROR('File should exist!');
//Request Page Handler function
RequestPage.Customer.SETFILTER("No.", '20000');
RequestPage.ChartType.VALUE('Pie chart');
RequestPage.SAVEASEXCEL(Filename);

See Also