Manage spreadsheet headers
You can hide the spreadsheet headers with column and row numbers, which are displayed by default on the grid.
To hide column and row numbers
Set the grid.showHeaders property to false in the Options Object.
There are several ways to apply this setting, depending on whether the pivot table is configured during report initialization or at runtime.
On initialization
This approach is useful when you want spreadsheet headers to be hidden by default.
report: {
options: {
grid: {
showHeaders: false
}
}
}
At runtime
You can toggle the visibility of spreadsheet headers at runtime by using the setOptions() API call.
webdatarocks.setOptions({ grid: { showHeaders: false }});
webdatarocks.refresh();