Click or drag to resize
DashboardObjectExportToExcel Method (DataTable, Boolean, String, CubeDataRenderer, Char) DataPA OpenAnalytics
DataPA OpenAnalytics API Reference
Export this dashboard object to Excel 2007 and above (XSLX)

Namespace: DataPAEnterpriseDashboard
Assembly: DataPAEnterpriseDashboard (in DataPAEnterpriseDashboard.dll) Version: 1.0.90.0 (1.0.90.0)
Syntax
public byte[] ExportToExcel(
	DataTable dataTable,
	bool showHeaders = true,
	string browserLanguage = "",
	CubeDataRenderer cube = null,
	char pivotDelimiter = '|'
)

Parameters

dataTable
Type: System.DataDataTable
The data to export
showHeaders (Optional)
Type: SystemBoolean
Show the column headers
browserLanguage (Optional)
Type: SystemString
Used to ensure correct culture-specific formatting, e.g. thousand separators
cube (Optional)
Type: DataPAEnterpriseDashboardCubeDataRenderer
If the grid is a Pivot Table, the CubeDataRenderer associated with it
pivotDelimiter (Optional)
Type: SystemChar

Return Value

Type: Byte
A byte array that contains the excel file
Remarks