Gridlines in Excel export

[Kalli Kaldi]

Hi.

I'm using the standalone designer to design my report.  When I export to Excel, the gridlines are not visible (see attachec file, Gridlines.PNG).  How can I make them visible during export ?

Best regards,
Kalli Kaldi

 

[Ivan Hristov]

Hello Kalli,

The visibility of the grid lines in Excel is set to false by default, but can be changed through the device information settings. The name of the key is ShowGridlines. To make the grid lines visible during export from Standalone Report Designer, the following section needs to be added to its configuration file:

	<Telerik.Reporting>
		<extensions>
			<render>
				<extension name="XLSX">
					<parameters>
						<parameter name="ShowGridlines" value="true"/>
					</parameters>
				</extension>
			</render>
		</extensions>
	</Telerik.Reporting>

The reports produced with Standalone Report Designer will be probably rendered in an application. If you need to have the grid lines visible when exporting from this application to Excel, the same section needs to be added to the application configuration file as well.

Regards,
Ivan Hristov
Progress Telerik