DashboardObjectExportToExcel Method (DataTable, Boolean, String, CubeDataRenderer, Char) |
|
DataPA OpenAnalytics API Reference
Export this dashboard object to Excel 2007 and above (XSLX)
Namespace: DataPAEnterpriseDashboardAssembly: 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 = '|'
)
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()
public:
virtual array<unsigned char>^ ExportToExcel(
DataTable^ dataTable,
bool showHeaders = true,
String^ browserLanguage = L"",
CubeDataRenderer^ cube = nullptr,
wchar_t pivotDelimiter = L'|'
) sealed
function ExportToExcel(dataTable, showHeaders, browserLanguage, cube, 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:
ByteA byte array that contains the excel file
Remarks See Also