Reporting Services export Excel files to avoid the layout of hidden rows and columns

To avoid hidden rows and columns in an exported Excel file when you develop Reporting Services, you must follow these rules:

The textbox in the 1.Page header must fit tightly together

The textbox width in the 2.Page header must be the same as the textbox width in the body

No gap is allowed between all controls in the 3.Page header and the body

4.Page header The location of the topmost control must be 0cm

The width of layout controls (such as: table,matrix,rectangle==) in 5.Body should be the same as the width of the report UI

A place in the red circle:

Reporting Services export Excel files to avoid the layout of hidden rows and columns