DataPA Enterprise Dashboard Controls 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

C#
public byte[] ExportToExcel(
	DataTable dataTable,
	bool showHeaders = true,
	string browserLanguage = "",
	CubeDataRenderer cube = null,
	char pivotDelimiter = '|'
)
Visual Basic
Public Function ExportToExcel ( 
	dataTable As DataTable,
	Optional showHeaders As Boolean = true,
	Optional browserLanguage As String = "",
	Optional cube As CubeDataRenderer = Nothing,
	Optional pivotDelimiter As Char = "|"C
) As Byte()
Visual C++
public:
virtual array<unsigned char>^ ExportToExcel(
	DataTable^ dataTable, 
	bool showHeaders = true, 
	String^ browserLanguage = L"", 
	CubeDataRenderer^ cube = nullptr, 
	wchar_t pivotDelimiter = L'|'
) sealed

Parameters

dataTable
Type: System.Data..::..DataTable
The data to export
showHeaders (Optional)
Type: System..::..Boolean
Show the column headers
browserLanguage (Optional)
Type: System..::..String
Used to ensure correct culture-specific formatting, e.g. thousand separators
cube (Optional)
Type: DataPAEnterpriseDashboard..::..CubeDataRenderer
If the grid is a Pivot Table, the CubeDataRenderer associated with it
pivotDelimiter (Optional)
Type: System..::..Char

Return Value

Type: array<Byte>[]()[][]

Remarks