ChartSection object, (CubeQuery)QuerySection object,, DataModelSection ojbect, Document object, DashboardSection object, OLAPQuerySection object, PivotSection object, QuerySection object, ResultsSection object, Section object, TableSection object, ReportSection object
Enables you to use data streaming in EPM Workspace. Streamed data displays before the entire file is exported. This feature improves performance.
If the file name and associated path information are specified when this method, this information is ignored when streaming is enabled. In the case of the full clients (Interactive Reporting Studio and Interactive Reporting Web Client), the file name and associated path information are used for writing data to disk with no additional errors cited when streaming is enabled (as in the case of export without streaming).
For UNIX users of the Export and ExportToStream methods, Interactive Reporting references the umask command of the user running the Interactive Reporting Service to determine the three-digit octal code. This code defines the read-write-execute permissions to be turned off. Typically, umask is used in .login or .profile and in the Bourne and C shells. It is a built-in command. |
Note: | The use of the Export (Method) or ExportToStream (Method) does not display a prompt dialog in the EPM Workspace or Jobs/Scheduler. |
Note: | You cannot export Report sections using the Excel 2007 format (*xlsx). |
Expression.ExportToStream( [optional] String Filename, [optional] bqExportFileFormat FileFormat, [optional] Boolean IncludeHeaders, [optional] Boolean DataStreaming, [optional] Boolean Prompt, [optional] BqEncoding Encoding)
An expression that returns an object for any of these sections:
The ExportToStream (Method) uses the BqExportFileFormat constant group, which consists of these values:
bqExportFormatHTML = 1
bqExportFormatJPEG = 2
bqExportFormatExcel2 = 3
bqExportFormatExcel5 = 4
bqExportFormatText = 5
bqExportFormatCSV = 6
bqExportFormatLotus123 = 7
bqExportFormatPDF = 8
bqExportFormatOfficeHTML = 9
bqExportFormatOfficeMHTML = 10
bqExportFormatExcel8 = 11
bqExportFormatExcelXLSX = 12
Note: | You cannot export a report section using Excel 2007 |
The BqEncoding constant group values include:
bqEnc_Arabic_ISO
bqEnc_Arabic_Windows
bqEnc_Baltic_ISO
bqEnc_Baltic_Windows
bqEnc_CentralEuropean_ISO
bqEnc_CentralEuropean_Windows
bqEnc_Chinese_BIG5
bqEnc_Chinese_GB2312
bqEnc_Chinese_HZ
bqEnc_Cyrillic_DOS
bqEnc_Cyrillic_ISO
bqEnc_Cyrillic_KOI8R
bqEnc_Cyrillic_KOI8U
bqEnc_Greek_ISO
bqEnc_Greek_Windows
bqEnc_Hebrew_Windows
bqEnc_Japanese_EUC
bqEnc_Japanese_JIS
bqEnc_Korean
bqEnc_Thai_Windows
bqEnc_Turkish_ISO
bqEnc_Turkish_Windows
bqEnc_Unicode
bqEnc_Unicode_UTF16
bqEnc_Unicode_UTF16_BigEndian
bqEnc_Unicode_UTF16_LittleEndian
bqEnc_Unicode_UTF32
bqEnc_Unicode_UTF32_BigEndian
bqEnc_Unicode_UTF32_LittleEndian
bqEnc_Unicode_UTF8
bqEnc_Vietnamese_Windows
bqEnc_WesternEuropean_ISO
bqEnc_WesternEuropean_Windows
This example shows how to export a Results section in a data stream to HTML. Because the streaming is enabled, no file name and associated path information have been specified:
ActiveDocument.Sections["Results"].ExportToStream("", bqExportFormatHTML, false, true, false)