大网数据广告活动
数据库与应用安全

Workbook contains hidden rows and columns

· 52CE 我爱测

This article provides a workaround for the problem where hidden rows or columns are inserted in an Excel workbook when you export reports from SQL Server Reporting Services to Excel.

This article helps you work around the problem where hidden rows or columns are inserted in an Excel workbook when you export reports from SQL Server Reporting Services (SSRS) to Excel.

Original product version:   SQL Server
Original KB number:   2777223

Symptoms

When you export a Microsoft SSRS report to an Excel workbook, there are hidden rows or columns in the workbook. The following image is an example of this problem:

Cause

This problem occurs because row heights or column widths are rounded.

Report Definition Language (RDL) enables you to use several measurement units (for example, inches, pixels, centimeters, and points) to specify position and size values. However, Excel uses only points. Therefore, the SSRS Excel rendering extension converts the height and width of the table, the heights of the rows, and the widths of the columns to points. This process may include rounding some values. In this situation, the table height or width and the sum of the row heights or column widths are different. To compensate for the difference, the SSRS Excel rendering extension inserts a small row or column to the workbook.

Workaround

To work around this issue, specify the measurement unit in points.

Note: You can convert other measurement units to points. For example, you can convert inches to points by using a ratio of 1 inch to 72 points.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 07/22/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。