Grid Lines in Export to Exce from Reports

[anu]

Hi,

I want to set Grid Lines when we do Export to Excel from Telerik Reports. But I did not find any such property to set for Excel.

Is there any way to do same?

Thanks & Regards,

Anu

[Nasko]

Hello Anu,

Setting the grid lines as described in the Show or hide gridlines on a worksheet is a feature specific to MS Excel and is not available in Telerik Reporting.
Depending on your report layout and structure some report items may have borders, but the default Excel grid lines will not be visible.

Regards,
Nasko
Telerik

[Werner]

Is this still the case? Is there a way to default the excel grid lines to always show after export is completed? 

[Silviya]

Hi Werner,

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 fro, for example, the 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 gridlines visible when exporting from this application to Excel, the same section needs to be added to the application configuration file as well.

 

Best Regards,
Silviya
Progress Telerik

[Werner]

Thank you, It worked! However, for me the Telerik Report control only allows exports of Excel 97 -2003, so I had to change the extension name from "XLSX to XLS.

[Silviya]

Hello Werner,

Yes, the extension name for the older version of Excel is XLS. 

I'm happy that this helped.

Best Regards,
Silviya
Progress Telerik