Skip to main content
Oct 15, 2026 7:50 PM UTC
Solved

Remove two blank rows at top of cube view Excel export

Dear Community, 

When I export cube view in Excel, I get two additional rows on the top, is it possible to remove them?


 

JJonesAnswer
OneStream Employee
Oct 16, 2026 6:17 PM UTC

The two additional rows that you are seeing are the report header for your Cube View.  The export process reserves the report-header rows in the generated worksheet, and there is currently not a way to remove these within as standard cube view formatting property.

If you were to add a Cube View Connection within Excel, there is an option to Include the Cube View Header or not in your connection, by default it does not include the header.  This setting currently does not exist on the cube view itself when exporting out to Excel from within the OneStream Windows Application.

1 reply

JJonesOneStream EmployeeAnswer
OneStream Employee
Oct 16, 2026 6:17 PM UTC

The two additional rows that you are seeing are the report header for your Cube View.  The export process reserves the report-header rows in the generated worksheet, and there is currently not a way to remove these within as standard cube view formatting property.

If you were to add a Cube View Connection within Excel, there is an option to Include the Cube View Header or not in your connection, by default it does not include the header.  This setting currently does not exist on the cube view itself when exporting out to Excel from within the OneStream Windows Application.